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 1319

Explain 3 basic parts of a trigger.

 1078

Show code of a cursor for loop.

 805

What does closing a cursor do?

 1011

How many triggers can be applied to a table?

 806

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

 852

Show the cursor attributes of pl/sql.

 799

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

 980

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

 849

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

 827

What packages are available to pl/sql developers?

 829

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

 795

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

 1037

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

 919

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

 1 1270

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is union, minus and interact commands? : Sql dba

896

Is pl sql different from sql?

739

Why are aggregate functions called so?

704

What is sql*loader and what is it used for?

773

How many tables can a sql database have?

739

What is dcl in sql?

731

Why do we use view in sql?

751

Is it possible to sort a column using a column alias?

837

how to see the create table statement of an existing table? : Sql dba

777

Is nosql faster than sql?

774

What is the difference between subquery and correlated query?

752

What is a mutating table and a constraining table?

784

What is sql and explain its components?

828

What is database white box testing and black box testing?

879

Which type of cursor is used to execute the dml statement?

730

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