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 16844

What are two virtual tables available during database trigger execution ?

2 12192

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

1 5337

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

2 8418

What is an Exception ? What are types of Exception ?

2 7181

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 9826

What is Raise_application_error ?

1 7556

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10858

Where the Pre_defined_exceptions are stored ?

2 8562

What is a stored procedure ?

9 10862

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 11795

What are advantages of Stored Procedures?

Satyam,

3 16590

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

3 10039

What are the two parts of a procedure ?

Hi Caliber IT,

6 15960

Give the structure of the procedure ?

1 5511

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

What is sql dialect?

1036

When sql appeared?

1023

Can pl sql procedure have a return statement?

959

what is the different between now() and current_date()? : Sql dba

934

How can you select unique records from a table?

992

What is sql partition function?

1117

what is the difference between delete and truncate statement in sql? : Sql dba

1127

What is clustered index in sql?

1001

What is the difference between a query and a report?

901

What is column?

940

Which is faster truncate or drop?

981

What is union and union all keyword in sql?

969

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1383

How do I run a query in pl sql developer?

926

What is the difference between count 1 and count (*) in a sql query?

908

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