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?

1099

How to disable a trigger name update_salary?

1260

What is the purpose of using pl/sql?

1135

How do you declare a user-defined exception?

1020

How exception is different from error?

1011

What is the difference between syntax error and runtime error?

1130

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

1 1298

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

1029

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

1218

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

1077

What are the advantages of stored procedure?

1000

Which command is used to delete a trigger?

1323

What is cursor and why it is required?

1178

Explain the savepoint statement.

1088

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

1098

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what are numeric data types? : Sql dba

1058

How to use sql*plus built-in timers?

1185

What does plv msg allows you to do?

1134

how to add a new column to an existing table in mysql? : Sql dba

1063

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

1077

Can you upgrade sql express to full sql?

1056

How can we link a sql database to an existing android app?

1021

List the ways to get the count of records in a table?

900

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3564

Can you have more than one trigger on a table?

996

How do you exit in sql?

1104

How does sql*loader handles newline characters in a record? : aql loader

1041

Is sql a backend language?

1088

How do I create a sql database?

992

Can we insert data into materialized view?

938

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