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.

1134

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.

1155

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

1027

Explain mutating table error.

1204

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.

1180

Differentiate between sga and pga.

1164

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Explain the methods used to protect source code of pl/sql.

1019

What is indexing oracle sql?

1105

What is synchronized subquery?

1168

how to create a new table by selecting rows from another table in mysql? : Sql dba

1102

What are keys in sql?

999

What is sql and its types?

1188

List out the acid properties and explain?

950

What are different types of queries in sql?

1121

Why functions are used in sql?

990

What is pls_integer in pl sql?

1105

What is pl sql collection?

969

explain the difference between delete , truncate and drop commands? : Sql dba

1093

What is Difference Between Unique and Primary Key Constraints?

1106

Which one is better subquery or joins?

1062

what are integrity rules?

1026

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