Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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

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