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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Does pl/sql support create command?

1102

How to disable a trigger name update_salary?

1266

What is the purpose of using pl/sql?

1144

How do you declare a user-defined exception?

1024

How exception is different from error?

1016

What is the difference between syntax error and runtime error?

1140

What are pl/sql exceptions? Tell me any three.

1 1302

What will you get by the cursor attribute sql%rowcount?

1037

What are the two virtual tables available at the time of database trigger execution?

1222

What are the two different parts of the pl/sql packages?

1087

What are the advantages of stored procedure?

1003

Which command is used to delete a trigger?

1331

What is cursor and why it is required?

1183

Explain the savepoint statement.

1096

How many types of cursors are available in pl/sql?

1109

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql injection owasp?

1060

How is debugging done?

976

how mysql optimizes distinct? : Sql dba

1079

What are stuff and replace function?

1079

differentiate between float and double. : Sql dba

1056

what does it mean to have quoted_identifier on? : Sql dba

1144

what is user defined functions? : Sql dba

1031

What is the most important ddl statements in sql are?

997

how to show all tables with 'mysql'? : Sql dba

1118

How exception is different from error?

1016

How do I create a memory optimized filegroup?

959

What are the types of triggers in sql?

1089

what happens if you no create privilege in a database? : Sql dba

1001

Can instead of triggers be used to fire once for each statement on a view?

962

how can we repair a mysql table? : Sql dba

979

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