QUESTION BANK ADBMS(3340701)

QUESTION BANK ADBMS(3340701)

1. Write a short note on :Functional Dependencies.
2. List and explain armstrong's axiom rule.
3. What is decomposition?Explain Lossy and Lossless join decomposition with example.
4. Write algorithm to find redundant functional dependency.
5. What is normalization? Give advantages of it.
6. Give example and explain 1NF.
7. Give example and explain 2NF.
8. Give example and explain 3NF.
9. Explain ACID properties of transaction.
10. Define Transaction.Draw and explain state transition diagram.
11. What is concurrency control?State and explain various problems of concurrency control.
12. What is deadlock?Explain deadlock detection and prevention technique.
13. Explain time-stamp method for concurrency control.
14. Explain optimistic method for concurrency control.
15. Differentiate commit/rollback.
16. Explain grant and revoke commands with example.
17. What is lock?Explain levels of lock.
18. What is view?Give advantages and types of view.
19. Give syntax to create and drop view.
20. Explain unique index with example.
21. What is sequence?Explain how to create and destroy sequence with example.
22. Differentiate SQL v/s PL/SQL.
23. Draw and explain generic PL/SQL block.
24. Explain for statement with example.
25. Describe explicit cursor.Explain various steps to manage explicit cursor.
26. What is parameterized cursor?Explain with suitable example.
27. List out any four predefined exceptions.Explain DUP_VAL_ON_INDEX exception.
28. Explain user defined exception with example.
29. Differentiate procedure/function.
30. Define package.Write steps to create package in PL/SQL.
31. What is trigger.Give advantages and types of trigger.
32. Give advantages of using function in PL/SQL.