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 1684

Explain 3 basic parts of a trigger.

1323

Show code of a cursor for loop.

1054

What does closing a cursor do?

1322

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.

1050

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?

1189

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

1078

What packages are available to pl/sql developers?

1059

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?

1166

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

1 1672

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is partition in sql query?

999

What is a join query?

964

What are the two virtual tables available at the time of database trigger execution?

1222

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

What does pragma mean?

1055

What is a pragma statement?

1262

What are triggers and its uses?

1047

How do I edit a trigger in sql developer?

994

what is primary key? : Sql dba

1029

What are the various restrictions imposed on view in terms of dml?

965

Explain aggregate functions are available there in sql?

1007

What is sql table?

972

What is difference sql and mysql?

989

What is left join in sql?

1051

what is union? : Sql dba

1027

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