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 16044

What are two virtual tables available during database trigger execution ?

2 11748

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

1 5076

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

2 7965

What is an Exception ? What are types of Exception ?

2 6500

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 9290

What is Raise_application_error ?

1 7204

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10418

Where the Pre_defined_exceptions are stored ?

2 8136

What is a stored procedure ?

9 9500

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 10813

What are advantages of Stored Procedures?

Satyam,

3 16034

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

3 9441

What are the two parts of a procedure ?

Hi Caliber IT,

6 14920

Give the structure of the procedure ?

1 5167


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is data integrity? : Sql dba

792


What are the basic techniques of indexing?

794


explain access control lists. : Sql dba

733


What is serial sql?

713


What is cursor in pl sql?

775


How many types of keys are there in sql?

766


what are all the common sql function? : Sql dba

794


What is normalisation in sql?

794


What is a left inner join?

718


What are sql triggers used for?

734


What is record data type?

689


How do I quit sql?

695


what is the difference between cluster and non cluster index? : Sql dba

741


what are the nonstandard string types? : Sql dba

823


How much does sqlite cost?

738