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?

1206

What is the location of pre_defined_functions.

1162

What is a call statement? Explain with an example.

996

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

1159

Explain polymorphism in pl/sql.

1111

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

1035

Is it possible to pass parameters to triggers?

1099

What are the different types of triggers?

1128

Explain the uses of database trigger.

1110

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

1046

Can a select statement fire a trigger?

1152

What are conditional predicates?

1053

Does a user_objects view have an entry for a trigger?

1005

Explain some predefined exceptions.

1027

Does user triggers have entry for trigger with compilation errors?

1025

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What operating systems are supported by oracle sql developer?

950

How do you write a subquery?

1022

What is sql in oracle?

1055

What are some emotional triggers?

975

What are the types of variables use in pl sql?

1036

Can we create a trigger on view?

891

What is a trigger in sql?

1200

How do I sort a table in sql?

1026

What is substitution variable?

1043

How do you create a db file?

1009

What is a nested table in word?

952

What will you get by the cursor attribute sql%notfound?

1055

What does trigger mean in slang?

1047

Can we use commit inside a trigger?

1080

Can we use delete in merge statement?

1033

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