SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is meant by tuning and tk proof?

2 12317

How would you hide a table in sql. ie the table can be only visible to its maker?

3 9691

what is definer rights invoke rights?

1 5875

How can we schedule the procedure to run automatically ?

3 9790

How toimport .dmp file in lower version of oracle from higher version ?

TCS,

4 12450

What are the Restrictions on Cursor Variables?

2 14963

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 9533

what is meant by forward declaration in functions?

TCS,

4 14768

what is difference between stored procedures and application procedures,stored function and application function?

1 10704

State the difference between implict and explict cursor's?

CTS,

7 20645

State the advatage and disadvantage of Cursor's?

2 8462

How to trace the errors in pl/sql block code?

TCS,

5 14706

How to display the contents of a current record fetched in a reference cursor?

2 7978

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 9799

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1694


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

534


What is record data type?

502


What does t sql mean?

521


What is package in pl sql?

566


what is the difference between cluster and non cluster index? : Sql dba

544






Can two tables have same primary key?

521


What operators deal with null?

593


What is database migration?

506


What is record in pl sql?

582


Differentiate between % rowtype and type record.

716


what are the differences among rownum, rank and dense_rank? : Sql dba

530


Can we write ddl statements in functions?

553


What is update query?

535


When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

612


how to get help information from the server? : Sql dba

517