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?

1162

How to disable a trigger name update_salary?

1307

What is the purpose of using pl/sql?

1186

How do you declare a user-defined exception?

1070

How exception is different from error?

1060

What is the difference between syntax error and runtime error?

1178

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

1 1367

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

1072

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

1266

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

1136

What are the advantages of stored procedure?

1037

Which command is used to delete a trigger?

1397

What is cursor and why it is required?

1251

Explain the savepoint statement.

1133

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

1155

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1235

What is the difference between sql, mysql and sql server?

1169

How can you fetch common records from two tables?

1099

What are actual parameters and formal parameters?

1166

Explain the difference between drop and truncate commands in sql?

1102

What is number function in sql?

1014

How does join work in sql?

1048

What is a constraint? Tell me about its various levels.

1241

what is sub-query? : Transact sql

1152

What is the difference between left outer join and left join?

1032

What is embedded sql in db2?

1057

State few characteristics of pl/sql?

1015

Are stored procedures compiled?

976

What is embedded sql what are its advantages?

1100

what is the difference between where clause and having clause? : Sql dba

1040

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