Interview Questions

Q:

How can you generate debugging output from PL/SQL?

Answer

Use the DBMS_OUTPUT package. Another possible method is to use the SHOW ERROR command.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 4457
Q:

What is the difference between paycheck and payslip?

Answer

Paycheck - this is the method by which the Employee is paid (A Bank Check/Cheque or Direct Deposit to Bank)


Payslip - Also called as Pay Stub is the paper which will typically detail the gross income and all taxes and any other deductions such as retirement plan contributions, insurances, garnishments, or charitable contributions taken out of the gross amount to arrive at the final net amount of the pay, also including the year to date totals in some circumstances.

Report Error

View answer Workspace Report Error Discuss

0 4454
Q:

What operator tests column for the absence of data?

A) NOT operator B) IS NULL operator
C) EXISTS operator D) All of the above
 
Answer & Explanation Answer: B) IS NULL operator

Explanation:

SELECT "column_name"


FROM "table_name"


WHERE "column_name" IS NULL.

Report Error

View Answer Report Error Discuss

1 4452
Q:

What is ILOC (Irrevocable Letter Of Credit) ?

Answer

It is a letter of credit or a contractual agreement between financial institute (Bank) and the party to which the letter is handed. The ILOC letter cannot be cancelled under any circumstance and, guarantees the payment to the party. It requires the bank to pay against the drafts meeting all the terms of ILOC. It is valid upto the stated period of time. For example, if a small business wanted to contract with an overseas supplier for a specified item they would come to an agreement on the terms of the sale like quality standards and pricing, and ask their respective banks to open a letter of credit for the transaction. The buyer’s bank would forward the letter of credit to the seller’s bank, where the payment terms would be finalized and the shipment would be made.

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview

1 4451
Q:

Series of interface points that allow other computers to communicate with the other layers of network protocol stack is called SAP

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

1 4446
Q:

Server control events are handled in the server whereas HTML control events are handled in the page

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

Server control events can be handled inside a server itself

Report Error

View Answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Software Architect

0 4445
Q:

How the different permutations are ordered in c++?

A) Compare lexicographicaly to each other elements B) By finding the highest element in the range
C) By finding the lowest element in the range D) None of the mentioned
 
Answer & Explanation Answer: A) Compare lexicographicaly to each other elements

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: C++

1 4430
Q:

What is the difference between Notify URL and Return URL?

Answer

Notify URL and Return URL is used in Paypal Payment Gateway integration. Notify URL is used by PayPal to post information about the transaction. Return URL is used by the browser; A url where the user needs to be redirected on completion of the payment process.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

2 4424