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?

1144

What is the location of pre_defined_functions.

1113

What is a call statement? Explain with an example.

954

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

1105

Explain polymorphism in pl/sql.

1059

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

988

Is it possible to pass parameters to triggers?

1033

What are the different types of triggers?

1057

Explain the uses of database trigger.

1055

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

998

Can a select statement fire a trigger?

1099

What are conditional predicates?

990

Does a user_objects view have an entry for a trigger?

963

Explain some predefined exceptions.

993

Does user triggers have entry for trigger with compilation errors?

975

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is msql? : Sql dba

943

Does truncate need commit?

895

what is 'mysqld'? : Sql dba

909

How many times can we commit in a loop?

959

How do you delete duplicates in sql query using rowid?

895

what are ddl statements in mysql? : Sql dba

1114

how to create a test table in your mysql server? : Sql dba

947

What are the types of subqueries?

1018

What does a pl/sql package consist of?

931

How can I change database name in sql?

1003

How is use pl and sql?

1004

Explain the uses of a database trigger?

985

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3928

What is sqlite format?

1113

Why do we use procedures in pl sql?

965

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