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?

1211

What is the location of pre_defined_functions.

1166

What is a call statement? Explain with an example.

1010

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

1167

Explain polymorphism in pl/sql.

1119

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

1036

Is it possible to pass parameters to triggers?

1103

What are the different types of triggers?

1136

Explain the uses of database trigger.

1115

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

1048

Can a select statement fire a trigger?

1158

What are conditional predicates?

1059

Does a user_objects view have an entry for a trigger?

1011

Explain some predefined exceptions.

1035

Does user triggers have entry for trigger with compilation errors?

1034

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is meant by urlencode and urldocode? : Sql dba

1176

How can you get sql*loader to commit only at the end of the load file? : aql loader

1014

What does stand for in sql?

967

What are string functions in sql?

1240

Is there a 64 bit version of ssms?

961

What kind of join is join?

969

What is an intersect?

1102

What is execution plan in sql?

1046

What if we write return in procedure?

1429

how can we repair a mysql table? : Sql dba

979

Explain how to use transactions efficiently : transact sql

980

Can we create a trigger on view?

895

What is a column in a table?

1125

Is sql a dbms?

1011

Does mysql_real_escape_string prevent sql injection?

946

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