Answer the following questions. 1. Afunctional dependency X → Zis redundant if X → Yand Y → Z already exist due to ______. 2. In a relation Student(RollNo, Name), the dependency RollNo → Name means that RollNo is a ______ key. 3. Afunction is a PL/SQL subprogram that returns a single value.[True/False] 4. A ______ is a collection of related procedures, functions, variables, and cursors. 5. How is closure denoted?
[5 marks]Explain DML, DQL, and DCL commands.
[5 marks]Define Cursor. Explain types of Cursor with example.
[5 marks]Explain the FOR, WHILE LOOP in PL/SQL with examples.
[5 marks]What is a view ? Explain how to create, replace, update, and alter a view with suitable examples.
[5 marks]Discuss the concept of trigger. Explain advantages and disadvantages of triggers.
[5 marks]Explain Armstrong’s Axioms for functional dependencies.
[5 marks]Define functional dependency .Differentiate between trivial and non- trivial functional dependencies.
[5 marks]Explain ACID properties.
[5 marks]Define Normal Form. Explain 1 NF, 2NF, 3NF with example.
[5 marks]Explain the role of a package specification and package body. Explain advantages of using package.
[5 marks]Describe lossless join decomposition and lossy decomposition with an example.
[5 marks]Explain the concept of sequence with example.
[5 marks]Discuss the concept of the three phases of optimistic concurrency control.
[5 marks]Define closure of a set of functional dependencies
[5 marks]Define Lock. Explain types of lock.
[5 marks]Define Exception.Describe the concept of Exceptions in brief.
[5 marks]