dbms-qns

1
1.Explain about two phase locking protocol 2.With a short notes on 1) embedded SQL 2) database stored procedure 3. What is time stamp? Explain about time stamp ordering protocol 4. what are views? Explain the problems with updating a view ? 5. how to create a triggers? Explain about assertion of trigger 6.Explain about ACID properties of transaction 7. Write a short note on ARIES algorithm 8. Write a short note on transaction support in SQL ******ALL THE BEST****** NHCE/IQP/009

Upload: rani

Post on 28-Jan-2016

219 views

Category:

Documents


0 download

DESCRIPTION

dbms questions

TRANSCRIPT

Page 1: dbms-qns

1.Explain about two phase locking protocol

2.With a short notes on 1) embedded SQL 2) database stored procedure

3. What is time stamp? Explain about time stamp ordering protocol

4. what are views? Explain the problems with updating a view ?

5. how to create a triggers? Explain about assertion of trigger

6.Explain about ACID properties of transaction

7. Write a short note on ARIES algorithm

8. Write a short note on transaction support in SQL

******ALL THE BEST******

NHCE/IQP/009