Technology Questions

Q:

What is an Interactive Report?

Answer

An Interactive report allows the user to participate in retrieving and present data at each level.while classical report doesn't have access to interact.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2301
Q:

what is use case? What is the diffrence between test cases and use cases?

Answer

Use case is nothing but the functional specification document in which all the customer requirements are documented.


Test case is a document which tells wat to test, steps to test and expected and actual results.


 

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 2299
Q:

Where can you define the icon for your Activity ?

Answer

Icon for an Activity is defined in the manifest file.


Code


<activity android:icon="@drawable/app_icon" android:name=".MyTestActivity"></activity>


...

Report Error

View answer Workspace Report Error Discuss

1 2299
Q:

Name any three PL/SQL exceptions?

Answer

Too_many_rows.


No_Data_Found.


Zero_Error.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2298
Q:

What are the reasons for slow loading of the web page?

Answer

- The web pages that are loading slowly might be using heavy scripts or might be getting loaded on an overloaded server. 


- If the content like flash is used then the web page performs really slowly in comparison to the normal pages that get created. 


- If the caching is inactive on the web browsers and the same web page is getting loaded again and again then the performance get degraded.


- Web pages load slowly due to the content on that page as if it is text it loads faster then the site that is made up of large photographs. 


- It takes longer time for a picture to get rendered and the transmission time also remains higher then the text.

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2298
Q:

What are presentation, application and database servers in SAP R/3?

Answer

The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2298
Q:

What are Number Functions in SQL?

Answer

- ABS(number)

Returns the absolute positive value of an expression.
Syntax:
ABS(expression)
Example:
SELECT ABS(-1.0), ABS(0.0), ABS(1.0)
Output:
1.0    .0    1.0

- CEIL(number)

Returns the smallest integer greater than, or equal to, the specified numeric expression.
Syntax:
CEILING(expression)
Example:
SELECT CEILING($223.45), CEILING($-223.45), CEILING($0.0)
Output:
224.00    -223.00        0.00

- FLOOR(number)

Returns the largest integer less than, or equal to, the specified numeric expression.
Syntax:
FLOOR(expression)
Example:
SELECT FLOOR($223.45), CEILING($-223.45), CEILING($0.0)
Output:
223.00      -224.00        0.00

- MOD(number, divisor)

Returns the remainder of the division from 2 integer values.
Syntax:
MOD(dividend, divisor)
Example:
SELECT MOD(20,3)
Output:
2

- POWER(number, power)

Returns the exponential value for the numeric expression.
Syntax:
POWER(number, power)
Example:
SELECT POWER(2.0, 3.0)
Output:
8.0

- SIGN(number)

Returns the sign i.e. positive or negative value for the numeric expression. It returns -1 for negative expressions, a value of 0 for zero
Syntax:
SIGN(number)
Example:
SELECT SIGN(4)
Output:
1

- ROUND(number, precision)

Returns the numeric value rounded off to the next value specified.
Syntax:
ROUND(number, number of places)
Example:
SELECT ROUND(1.3456, 2)

- SQRT(number)

Returns the square root value of the expression.
Syntax:
SQRT(number)
Example:
SELECT SQRT(4.0)
Output:
2.0

- TRUNC(number, precision)

Returns a numeric value that truncate to the specific places
Syntax:
TRUNCATE(number,places)
Example:
SELECT TRUNCATE(1.3456, 2)
Output:
1.34

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2298
Q:

What does coalescing a tablespace do?

Answer

Coalescing is only valid for dictionary-managed tablespaces and de-fragments space by combining neighboring free extents into large single extents.

Report Error

View answer Workspace Report Error Discuss

3 2297