Home \ Interview Questions \ Oracle Interview Questions

Oracle Interview Questions

What is the significance of the & and && operators in PL SQL ?

Written by Oracle Saturday, 12 June 2010 07:18

The & operator means that the PL SQL block requires user input for a variable. The && operator means that the value of this variable should be the same as inputted by the user previously for this same variable. If a transaction is very large, and the rollback segment is not able to hold the rollback information, then will the transaction span across different rollback segments or will it terminate ? It will terminate (Please check ).

Can you pass a parameter to a cursor ?

General

Written by Oracle Saturday, 12 June 2010 07:18

Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear. CURSOR c1 (median IN NUMBER) IS SELECT job, ename FROM emp WHERE sal > median;

What are the various types of RollBack Segments ?

General

Written by Oracle Saturday, 12 June 2010 07:18

Public Available to all instances Private Available to specific instance

Can you use %RowCount as a parameter to a cursor ?

General

Written by Oracle Saturday, 12 June 2010 07:18

Yes

Definition of relational DataBase by Dr. Codd (IBM)?

General

Written by Oracle Saturday, 12 June 2010 07:18

A Relational Database is a database where all data visible to the user is organized strictly as tables of data values and where all database operations work on these tables.

Oracle Interview Questions

What is the significance of the & and && operators in PL SQL ?

Can you pass a parameter to a cursor ?

What are the various types of RollBack Segments ?

Can you use %RowCount as a parameter to a cursor ?

Definition of relational DataBase by Dr. Codd (IBM)?

More Articles...

Search TechHairBall.com

Login Form (Can use your Gmail Acct)

Latest Comments