Interview Questions

Price and quantity supplied move in the same direction. As the price decreases, quantity supplied also decreases and viceversa.

Priority: concern with application from the business point of view. It answers  How quickly we need to fix the bug? Or How soon the bug should get fixed?

Severity: concern with functionality of application. It deals with the impact of the bug on the application.

- The better way to design the layout of the webpage is by using the <div> tag. 

- The <table> tag is used to present the data in tabular format

Call Transaction Method: In Call Transaction method we call the transaction in BDC program itself. If we want this program is executed by some one else then we need to expose the code to him. Call Transaction Method Works in Foreground. No Display Mode is equal to Background Processing in call transaction method. Call Transaction Method can handle only one Application at a time. In Call Transaction Method no Log File by Default. We have to design Log File by using BDCMSGCOLL. Call Transaction Method Updates the Database Asynchronously. (Note: Asynchronous updation is Faster than Synchronous)
 
Batch Session Method: On the other hand in batch session method we create a session which can be executed at any time by any authorized person without exposing the code of the program. Session Method works in Background and as well as in Foreground. Session Method can handle Multiple Applications at a time. Session Method holds Log File by Default. Session Method Updates the Database Synchronously.

Node.js is a framework for web applications built on Google Chrome's JavaScript Engine(V8 Engine).

Node.js is comes with runtime environment on which a cript based on javascript can be interpreted and executed (It is analogus to JVM to JAVA byte code). This runtime environment allows to execute a JavaScript code on any machine outside a browser. Because of this runtime of Node.js, JavaScript is now can be executed on server also.

Node.js is provides a rich library of various javascript modules which eases the developement of web application using Node.js to greater extents.

Time Estimation method for Testing Process:

Step 1 : count number of use cases (NUC) of system 

Step 2 : Set Avg. Time Test Cases(ATTC) as per test plan 

Step 3 : Estimate total number of test cases (NTC) 

Total number of test cases = Number of Use Cases X Avg. Test Cases per a use case 

Step 4 : Set Avg. Execution Time (AET) per a test case 

Step 5 : Calculate Total Execution Time (TET) 

TET = Total number of test cases * AET 

Step 6 : Calculate Test Case Creation Time (TCCT)

usually we will take 1.5 times of TET as TCCT

TCCT = 1.5 * TET

Step 7 : Time for Re-Test Case Execution (RTCE) this is for retesting

usually we take 0.5 times of TET

RTCE = 0.5 * TET

Step 8 : Set Report generation Time (RGT

usually we take 0.2 times of TET

RGT = 0.2 * TET

Step 9 : Set Test Environment Setup Time (TEST)

it also depends on test plan

Step 10 : Total Estimation time = TET + TCCT+ RTCE + RGT + TEST + some buffer.

- 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

Insurance can help you to protect your properties and assets like home, car, stocks,... against unexpected accidents.