Oracle Interview Questions

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

General

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.
 

Page 1 of 6

«StartPrev123456NextEnd»

Login Form (Can use your Gmail Acct)

Latest Comments

Copyright © 2017 Interview Questions, Tutorials, Certification Questions. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.