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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Explain the rollback statement?

1000

What is exception? What are the types of exceptions?

1066

How to execute a stored procedure?

1084

What is mutating table error?

1175

Explain ddl statements in pl/sql?

1002

How to return multiple rows from the stored procedure?

961

What is the life of an sql statement?

1015

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1010

What steps server process has to take to execute an update statement?

973

Can %notfound return null after a fetch?

1051

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1199

Determine if oracle date is on a weekend?

1033

How to create a menu in sqlplus or pl/sql?

1117

How to use boolean type in select statement?

1065

How to check if a column is nullable before setting to nullable?

1115

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Mention what does the hierarchical profiler does?

1082

Can we use ddl statements in stored procedure sql server?

1006

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

962

Is and as keyword in pl sql?

954

Does sql view stored data?

949

What is oracle pl sql developer?

977

What is %rowtype in pl sql?

984

What is a Mapplet?

1116

How to read/write files from pl/sql?

1032

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2015

What are inner outer left and right joins in sql?

1006

What is the difference between the conventional and direct path loader? : aql loader

1149

Is keyword pl sql?

978

Can one improve the performance of sql*loader? : aql loader

1040

What are the types of functions in sql?

1010

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