Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 12971

What are two virtual tables available during database trigger execution ?

2 9789

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

1 4027

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

2 6531

What is an Exception ? What are types of Exception ?

2 5130

What is Pragma EXECPTION_INIT ? Explain the usage ?

2 7743

What is Raise_application_error ?

1 6019

What are the return values of functions SQLCODE and SQLERRM ?

PreVator,

2 9123

Where the Pre_defined_exceptions are stored ?

2 6775

What is a stored procedure ?

5 6338

What is difference between a PROCEDURE & FUNCTION ?

Satyam,

6 8268

What are advantages of Stored Procedures?

Satyam,

3 14151

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

3 7865

What are the two parts of a procedure ?

Hi Caliber IT,

6 12136

Give the structure of the procedure ?

1 4152


Post New SQL PLSQL Questions






Un-Answered Questions { SQL PLSQL }

How can you tell the difference between an index and a view?

130


What is nvarchar max in sql?

162


What is rownum in sql?

149


What are different types of triggers?

153


Explain the uses of database trigger.

211






What is sql integrity?

190


Does sqlite need a server?

139


What is the difference between jpql and sql?

136


Explain two virtual tables available at the time of database trigger execution.

200


What is difference between table and view?

125


What are tables and fields in the database?

188


What is the difference between cluster and non-cluster index?

166


What is sqlca in powerbuilder?

147


Can we join tables without foreign key?

139


Is left join inner or outer by default?

142