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?

1046

What is the meaning of disabling a trigger?

1182

What is the difference between database trigger and stored procedure?

1074

difference between anonymous blocks and sub-programs.

1133

Explain the uses of control file.

1050

How can the performance of a trigger be improved?

1047

How can you view the errors encountered in a trigger?

962

Explain autonomous transaction.

1154

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

1026

Explain mutating table error.

1203

Can cursors be part of a trigger body?

1641

What is the importance of sqlcode and sqlerrm?

1356

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

1068

Explain spool.

1179

Differentiate between sga and pga.

1163

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is scalar function?

1051

What is the use of pl/sql table?

1066

Explain polymorphism in pl/sql.

1119

how can we optimize or increase the speed of a mysql select query? : Sql dba

948

Why do we go for stored procedures?

1057

how to get a list of indexes of an existing table? : Sql dba

958

Is sql dba a good career? : SQL DBA

991

What is duration in sql profiler trace?

1079

Why is pl sql used?

980

explain what is mysql? : Sql dba

1080

What is the difference between microsoft access and sql?

1023

What is materialized view. What are different methods of refresh?

1393

what is a constraint? : Sql dba

1168

What are the different sql commands?

1073

What are tables and fields?

1033

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