SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

what is meant by tuning and tk proof?

2 13380

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

3 11001

what is definer rights invoke rights?

1 6541

How can we schedule the procedure to run automatically ?

3 11075

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

TCS,

4 14080

What are the Restrictions on Cursor Variables?

2 16049

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

3 10696

what is meant by forward declaration in functions?

TCS,

4 16390

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

1 11475

State the difference between implict and explict cursor's?

CTS,

7 23140

State the advatage and disadvantage of Cursor's?

2 9550

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

TCS,

5 16606

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

2 9083

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 11235

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

2216

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is varchar sql?

1129

What is before and after trigger?

949

Enlist the characteristics of pl/sql?

1791

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1068

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1222

What is the difference between delete and truncate statement in sql?

1060

What does the sign mean in sql?

983

List and explain the different types of join clauses supported in ansi-standard sql?

1351

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1093

What is difference between sql function and stored procedure?

1002

Does view store data in sql?

953

how to include numeric values in sql statements? : Sql dba

1097

In what condition is it good to disable a trigger?

1003

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

991

Why do we need unique key in a table?

952

For More Un-Answered { SQL PLSQL } Questions Click Here