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 16877

What are two virtual tables available during database trigger execution ?

2 12208

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

1 5354

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

2 8439

What is an Exception ? What are types of Exception ?

2 7207

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 9853

What is Raise_application_error ?

1 7571

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10874

Where the Pre_defined_exceptions are stored ?

2 8581

What is a stored procedure ?

9 10924

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 11830

What are advantages of Stored Procedures?

Satyam,

3 16613

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

3 10058

What are the two parts of a procedure ?

Hi Caliber IT,

6 16001

Give the structure of the procedure ?

1 5533

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

Inline the values in PL/SQL, what does it mean.?

1165

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

948

How many types of functions are there in sql?

902

What is %s in sql?

980

Explain what is a column in a table?

1052

What is sql not null constraint?

987

What is thread join () in threading?

952

How is indexing done in search engines?

937

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

953

What is the syntax and use of the coalesce function?

1106

Is delete faster than truncate?

973

What are views in sql?

934

What are the two types of cursors in pl sql?

1013

What is a database event trigger?

1095

What is the maximum number of columns in sql table?

1097

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