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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

What are instead of triggers?

1099

What is the meaning of disabling a trigger?

1231

What is the difference between database trigger and stored procedure?

1128

difference between anonymous blocks and sub-programs.

1184

Explain the uses of control file.

1094

How can the performance of a trigger be improved?

1087

How can you view the errors encountered in a trigger?

1017

Explain autonomous transaction.

1211

Can a view be mutating? If yes, then how?

1082

Explain mutating table error.

1256

Can cursors be part of a trigger body?

1691

What is the importance of sqlcode and sqlerrm?

1389

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1115

Explain spool.

1213

Differentiate between sga and pga.

1204

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

How do I save a sql query?

1062

What is the difference between jpql and sql?

1139

What are commit, rollback, and savepoint?

1040

How many sql commands are there?

1152

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1063

What is a sql trace file?

1081

how to fetch common records from two tables? : Sql dba

1245

what is self join and what is the requirement of self join? : Sql dba

1185

What is dml with example?

1151

How do you modify a trigger?

976

What is write ahead logging in sql server?

1094

Which command is used to call a stored procedure?

1047

what are the authentication modes in sql server? How can it be changed? : Sql dba

1502

Why do we need cursor in pl sql?

1181

What is 19 null in sql?

1015

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