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 17123

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 8552

What is an Exception ? What are types of Exception ?

2 7359

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 10001

What is Raise_application_error ?

1 7650

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10980

Where the Pre_defined_exceptions are stored ?

2 8686

What is a stored procedure ?

9 11223

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 12079

What are advantages of Stored Procedures?

Satyam,

3 16750

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

3 10219

What are the two parts of a procedure ?

Hi Caliber IT,

6 16252

Give the structure of the procedure ?

1 5595

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What are the sql aggregate functions?

1128

Which is better trigger or stored procedure?

950

Explain isolation levels. : Transact sql

1068

What is data control language (dcl)?

1137

How many subqueries can be nested in a statement?

982

Is pl sql a programming language?

989

what is union? : Sql dba

1025

How to add a column ‘salary’ to a table employee_details?

1012

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

I need a function for a train ticket reservation please answer it thanks in advance

1024

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1031

What is pl sql architecture?

959

What is an index in sql with example?

974

What does 0 mean in sql?

965

What is cascade in sql?

961

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