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 1674

Explain 3 basic parts of a trigger.

1304

Show code of a cursor for loop.

1052

What does closing a cursor do?

1313

How many triggers can be applied to a table?

1054

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

1063

Show the cursor attributes of pl/sql.

1043

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

1232

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

1179

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

1068

What packages are available to pl/sql developers?

1042

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

1042

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

1321

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

1160

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

1 1663

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the order of sql statement execution?

1040

what is the difference between char and varchar data types? : Sql dba

1085

What are different types of functions in sql?

999

what is the stuff function and how does it differ from the replace function? : Sql dba

1040

What are sql ddl commands?

1084

How to prepare for oracle pl sql certification?

1055

What is data types in sql?

998

what is clause? : Sql dba

1056

what are rollup and cube in t-sql? : Transact sql

1091

what is the difference between a web-garden and a web-farm? : Sql dba

1077

What is an inner join sql?

1021

how do you control the max size of a heap table? : Sql dba

970

Is sql microsoft?

1038

What are the syntax and use of the coalesce function?

1192

Is sql better than excel?

1139

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