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?

1007

What is exception? What are the types of exceptions?

1073

How to execute a stored procedure?

1089

What is mutating table error?

1178

Explain ddl statements in pl/sql?

1009

How to return multiple rows from the stored procedure?

970

What is the life of an sql statement?

1024

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

1015

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

975

Can %notfound return null after a fetch?

1060

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

1208

Determine if oracle date is on a weekend?

1041

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

1122

How to use boolean type in select statement?

1073

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

1124

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is case function?

1040

what is auto increment? : Sql dba

1008

What is the difference between the implicit and explicit cursors?

1048

What is data modelling in sql?

1017

Can %notfound return null after a fetch?

1060

What is forward declaration in pl sql?

1077

explain primary keys and auto increment fields in mysql : sql dba

977

how to delete an existing column in a table? : Sql dba

1005

Is pl sql better than sql?

1030

How can we optimize a sql query?

1049

Is sql free?

966

How can we avoid duplicating records in a query?

982

Explain the purpose of %type and %rowtype data types?

928

What is an alias command?

1068

Does oracle roll back the transaction on an error?

1013

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