1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category
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 15263

What are two virtual tables available during database trigger execution ?

 2 11269

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

 1 4762

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

 2 7491

What is an Exception ? What are types of Exception ?

 2 6045

What is Pragma EXECPTION_INIT ? Explain the usage ?

 2 8854

What is Raise_application_error ?

 1 6882

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 10010

Where the Pre_defined_exceptions are stored ?

 2 7709

What is a stored procedure ?

 5 8108

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 10047

What are advantages of Stored Procedures?

Satyam,

3 15547

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

 3 8898

What are the two parts of a procedure ?

Hi Caliber IT,

6 14014

Give the structure of the procedure ?

 1 4869

Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

557

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

572

What is the syntax and use of the coalesce function?

605

Can I create table without primary key?

531

What is trigger types of trigger?

554




What are the sql versions?

522

What is the difference between partitioning and sharding?

530

What is trigger explain with example?

552

What is compilation error in pl sql?

506

Is sqlexception checked or unchecked?

541

how many groups of data types? : Sql dba

569

Is ms sql traffic encrypted?

505

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

529

What is the reports view in oracle sql developer?

545

Explain the commit statement.

613

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