SQL PLSQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Define SQL and state the differences between SQL and other conventional programming Languages?

1156

What is the location of pre_defined_functions.

1121

What is a call statement? Explain with an example.

963

If a cursor is open, how can we find in a pl/sql block?

1110

Explain polymorphism in pl/sql.

1065

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

996

Is it possible to pass parameters to triggers?

1042

What are the different types of triggers?

1065

Explain the uses of database trigger.

1057

Can a commit statement be executed as part of a trigger?

1000

Can a select statement fire a trigger?

1103

What are conditional predicates?

997

Does a user_objects view have an entry for a trigger?

969

Explain some predefined exceptions.

997

Does user triggers have entry for trigger with compilation errors?

984

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Differentiate between % rowtype and type record.

1212

What are the indexing methods?

1009

When is the explicit cursor used ?

990

How to set up sql*plus output format in oracle?

983

Which one is better sql or oracle?

913

What is percent sign in sql?

1227

what is self-join? : Sql dba

1070

How to rename a table?

971

Why trigger is used in sql?

925

How do you copy a table in sql?

1021

what are the t string functions available in tsql? : Transact sql

953

What is the default isolation level in sql server? : Transact sql

975

What are the types of queries in sql?

1029

Show the cursor attributes of pl/sql.

1002

Explain how to use transactions efficiently : transact sql

940

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