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 17087

What are two virtual tables available during database trigger execution ?

2 12301

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

1 5413

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

2 8537

What is an Exception ? What are types of Exception ?

2 7339

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 9975

What is Raise_application_error ?

1 7639

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10974

Where the Pre_defined_exceptions are stored ?

2 8673

What is a stored procedure ?

9 11180

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12061

What are advantages of Stored Procedures?

Satyam,

3 16737

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

3 10196

What are the two parts of a procedure ?

Hi Caliber IT,

6 16227

Give the structure of the procedure ?

1 5588

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is java sql connection?

1042

what is sp_pkeys? : Transact sql

1149

What is sap sql?

971

Is t sql a programming language?

1058

What is pl sql package?

1029

What is full join?

947

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1034

What program will open a mdb file?

958

Can unique keys be null?

898

How to add new employee details in an employee_details table with the following details

1085

Explain the difference between drop and truncate commands in sql?

1035

List the different type of joins?

1059

What are keys in sql?

995

What is a natural join?

1059

How can I make sql query run faster?

1009

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