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

SQL PLSQL Interview Questions

Questions Answers Views Company eMail

Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?

5 17132

What are two virtual tables available during database trigger execution ?

2 12316

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 5424

Write the order of precedence for validation of a column in a table ?

2 8556

What is an Exception ? What are types of Exception ?

2 7366

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 10004

What is Raise_application_error ?

1 7653

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10985

Where the Pre_defined_exceptions are stored ?

2 8690

What is a stored procedure ?

9 11243

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12093

What are advantages of Stored Procedures?

Satyam,

3 16758

What are the modes of parameters that can be passed to a procedure ?

3 10225

What are the two parts of a procedure ?

Hi Caliber IT,

6 16269

Give the structure of the procedure ?

1 5597

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Is grant a ddl statement?

896

how many sql dml commands are supported by 'mysql'? : Sql dba

1123

What is sql in java?

1090

What are the benefits of triggers?

1172

What is rownum and rowid?

1032

Which constraints we can use while creating database in sql?

1082

what is column? : Sql dba

1004

What is the difference between delete and truncate commands?

1042

How do I save a sql query?

1015

What is clause in sql?

1109

What are packages in pl sql and also explain its advantages?

1040

How do I view output in sql developer?

1088

What is sql entity?

1107

What is null in pl/sql?

1071

Explain what is sql?

1119

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