Explain Commit, Save point and Rollback.
[5 marks]Explain DML Commands.
[5 marks]Explain Exclusive (X) Lock & Shared (S) Lock.
[5 marks]What is a deadlock in DBMS?
[5 marks]What is Row level locking.
[5 marks]Explain Sequences with example.
[5 marks]Explain Exception Handling using PL/SQL.
[5 marks]Explain Cursors Attributes.
[5 marks]What are procedures and functions?
[5 marks]What is a PL/SQL Package?
[5 marks]What is SQL Triggers?
[5 marks]What is Functional Dependency?
[5 marks]Difference Between Lossless and Lossy Join Decomposition Page 1 of
[2 marks]Convert Following Example into 2nd Normalization Form. Imagine we're building a restaurant management application. That application needs to store data about the company's employees and it starts out by creating the following table of employees: All the entries are atomic and there is a composite primary key (employee_id, job_code)
[5 marks]What is Concurrency control in DBMS?
[5 marks]Explain Third Normal Form (3NF).
[5 marks]Explain Dirty read problem in DBMS with example. Page 2 of
[2 marks]