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 1683

Explain 3 basic parts of a trigger.

1323

Show code of a cursor for loop.

1054

What does closing a cursor do?

1320

How many triggers can be applied to a table?

1063

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

1065

Show the cursor attributes of pl/sql.

1049

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

1236

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

1188

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

1077

What packages are available to pl/sql developers?

1057

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

1052

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

1323

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

1164

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

1 1671

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the advantages of pl sql?

1122

What are the differences between implicit and explicit cursors?

1067

What is hibernate and its relation to sql?

1123

What is rownum?

980

What is the difference between explicit and implicit cursors in oracle?

1068

how can we submit a form without a submit button? : Sql dba

985

what are the different tables present in mysql? : Sql dba

984

How many triggers can be applied to a table?

1063

What are different types of indexes?

1010

What is server name sql?

1143

How many types of triggers exist in pl/sql?

1071

what is recursive stored procedure? : Sql dba

986

Can a foreign key be a duplicate?

910

What is the largest value that can be stored in a byte data field?

1012

what are the different functions in sorting an array? : Sql dba

1017

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