Explain DML with example.
[5 marks]Explain Commit, Save point, Rollback with example.
[5 marks]Write a note on trigger.
[5 marks]Define Cursor. Explain its types with example.
[5 marks]Define Packages. Explain Package specifications and list the advantages of packages.
[5 marks]Explain data types of PL/SQL.
[5 marks]Define Functional dependency. Explain its types.
[5 marks]Write a note on Control Structures of PL/SQL.
[5 marks]Explain closures of a set of functional dependencies
[5 marks]Define Decomposition. Explain Lossy Decomposition with example.
[5 marks]Explain 1NF with example.
[5 marks]Define Decomposition. Explain Lossless Decomposition with example.
[5 marks]Write a note on normalization and its types.
[5 marks]Explain 2NF with example.
[5 marks]Define transaction. Explain transaction concepts in details.
[5 marks]Explain 3NF with example.
[5 marks]Explain methods for Concurrency Control.
[5 marks]