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 uses of cursor.

1 1622

Explain 3 basic parts of a trigger.

1266

Show code of a cursor for loop.

1011

What does closing a cursor do?

1253

How many triggers can be applied to a table?

1002

How would you reference column values before and after you have inserted and deleted triggers?

1029

Show the cursor attributes of pl/sql.

1004

Which data dictionary views have the information on the triggers that are available in the database?

1190

What are the events on which a database trigger can be based?

1113

What is out parameter used for eventhough return statement can also be used in pl/sql?

1025

What packages are available to pl/sql developers?

1000

What does the base_object_type column shows in the user.triggers data dictionary view?

1007

What are the rules to be applied to nulls whilst doing comparisons?

1285

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1125

Explain two virtual tables available at the time of database trigger execution.

1 1586

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are commit, rollback, and savepoint?

945

Does google use sql?

915

What is an ndf file?

937

what is the functionality of the function htmlentities? : Sql dba

901

How do I filter in sql profiler?

951

what is a field in a database ? : Sql dba

998

How sql query is executed?

1078

What is the importance of sqlcode and sqlerrm?

1292

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

981

What are the various levels of constraints?

1068

Is inner join same as self join?

1071

What does stand for in sql?

926

What is difference between sql and excel?

1022

How many row comparison operators are used while working with a subquery?

988

what are properties of a transaction? : Sql dba

1039

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