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 17126

What are two virtual tables available during database trigger execution ?

2 12314

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

1 5420

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

2 8554

What is an Exception ? What are types of Exception ?

2 7363

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 10002

What is Raise_application_error ?

1 7650

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10982

Where the Pre_defined_exceptions are stored ?

2 8686

What is a stored procedure ?

9 11229

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12086

What are advantages of Stored Procedures?

Satyam,

3 16750

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

3 10222

What are the two parts of a procedure ?

Hi Caliber IT,

6 16257

Give the structure of the procedure ?

1 5596

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is a memo field?

969

What is informix sql?

975

How to read/write files from pl/sql?

1035

Why is sharding used?

995

What is clause?

1151

How do sql triggers work?

1041

What is the difference between delete and truncate commands?

1037

Is mariadb nosql?

1041

Show how functions and procedures are called in a pl/sql block.

1127

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

what is the difference between undefined value and null value? : Sql dba

1101

What is output spooling in sql*plus?

1035

Is primary key always clustered index?

1023

Difference between global and parameter variables?

1966

What is a subquery in sql?

1040

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