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 the limitation on the block size of pl/sql?

1033

What is a mutating table and a constraining table?

1175

Why triggers are used?

1035

Explain cursor types?

1079

What are pl/sql cursors?

1098

Explain the difference between triggers and constraints?

1022

Enlist the data types that can be used in pl/sql?

1106

What is the difference between function, procedure and package in pl/sql?

1347

What is the difference between execution of triggers and stored procedures?

1155

Differentiate between pl/sql and sql?

1211

What is a pl/sql block?

1324

What is pl/sql table? Why is it used?

1088

What is the difference between rollback and rollback to statements?

1097

How many types of triggers exist in pl/sql?

1129

What are some predefined exceptions in pl/sql?

1220

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How can use stored procedures in sql?

1188

Can we edit a view in sql?

1040

What does plv msg allows you to do?

1177

How do I run sql profiler?

1117

What is using in sql?

1138

what are enums used for in mysql? : Sql dba

1228

What is rank function in sql?

1068

What port does sql server use?

1110

What is row_number () in sql?

1023

How do you define a foreign key?

1061

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2608

What is data control language (dcl)?

1202

What is the difference between count 1 and count (*) in a sql query?

1051

What is record data type?

977

Which is better join or subquery?

1187

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