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 1601

Explain 3 basic parts of a trigger.

1257

Show code of a cursor for loop.

1002

What does closing a cursor do?

1247

How many triggers can be applied to a table?

995

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

1021

Show the cursor attributes of pl/sql.

998

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

1182

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

1103

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

1016

What packages are available to pl/sql developers?

996

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

1000

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

1274

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

1116

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

1 1571

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is a database lock ? : Sql dba

1093

What is view explain with example?

887

Is a foreign key always unique?

884

What are data types in pl sql?

1077

What are inner outer left and right joins in sql?

965

how many sql ddl commands are supported by 'mysql'? : Sql dba

959

How many types of sql are there?

931

What is a sql*loader control file?

1165

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

955

what is schema? : Sql dba

987

Can one improve the performance of sql*loader? : aql loader

983

What is input buffer in sql*plus?

1127

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

What are sql*plus environment variables?

1032

What is an emotional trigger?

932

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