Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

SQL Interview Questions and Answers

Test your skills through the online practice test: SQL Quiz Online Practice Test

Ques 6. What is a event handler ?

An event handler is a routine that is written to respond to a particular event.

Is it helpful? Add Comment View Comments
 

Ques 7. What is an integrity constraint ?

An integrity constraint allows the definition of certain restrictions, at the table level, on the data that is entered into a table.

Is it helpful? Add Comment View Comments
 

Ques 8. What are the various uses of database triggers ?

Database triggers can be used to enforce business rules, to maintain derived values and perform value-based auditing.

Is it helpful? Add Comment View Comments
 

Ques 9. What is a transaction ?

A transaction is a set of operations that begin when the first DML is issued and end when a commit or rollback is issued. BEGIN COMMIT/ROLLBACK are the boundries of a transaction.

Is it helpful? Add Comment View Comments
 

Ques 10. Why are the integrity constraints preferred to database triggers ?

Because it is easier to define an integrity constraint than a database trigger.

Is it helpful? Add Comment View Comments
 

Most helpful rated by users:

©2024 WithoutBook