SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Explain uses of cursor.

1 1348

Explain 3 basic parts of a trigger.

1092

Show code of a cursor for loop.

825

What does closing a cursor do?

1029

How many triggers can be applied to a table?

829

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

864

Show the cursor attributes of pl/sql.

816

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

994

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

874

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

847

What packages are available to pl/sql developers?

840

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

805

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

1060

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

938

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

1 1297


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is stored procedure faster than query?

769


How do you update sql?

756


Which constraints we can use while creating database in sql?

843


What company owns postgresql?

810


What are the different datatypes available in PL/SQL?

806


Is left join and outer join same?

816


What do you mean by “trigger” in sql?

849


What are tables and fields?

804


How to sort the rows in sql.

860


How can get second highest salary in sql?

736


What is clustered and nonclustered index in sql?

756


How to fix oracle error ora-00942: table or view does not exist

811


What are the differences between implicit and explicit cursors?

756


Is ms sql is free?

741


What are the advantages of stored procedure?

788