BIT 3rd Semester
Database Management System Board Question Paper 2080

Define serial, non-serial and serializable schedules with example. How can you test serializability of a schedule? Explain with an example

What is Transaction? State and explain the states of transaction with transition diagram.

From the the relations given below, answer the following questions.
EMPLOYEE (Ssn, Fname, Bdate, Address, Sex, Salary, Super_ssn, Dno)
DEPARTMENT (Dname, Dnumber, Mgr_ssn, Mgr_start_date)
PROJECT (Pname, Pnumber, Plocation, Dnum)
DEPENDENT (Essn, Dependent_name, Sex, Bdate, Relationship)
DEPT_LOCATIONS (Dnumber, Dlocation)
a) Retrieve the name and address of all employees who work for the 'Computer' department in SQL
b) For each Department, retrieve the department number, the number of employees in the department, and their average salary using SQL.
c) Retrieve the employees name and their Dname and Pname ordered by the employee's Dname.
d) Retrieve the name and salary of all employees who work in department number 5 using Relational Algebra.
e) Retrieve the name of the manager of each department using Relational Algebra.

What are the Advantages of using DBMS? Explain in brief.

What is Attributes? Explain different types of Attributes with example.

Define relation, instance and schema with example.

Wha is Shared/Exclusive (Read/Write) Locks? How it is different from binary Locks.

What is Deadlock in DBMS? Explain with example.

What is shadow paging? How it is used for database recovery?

What is data independence? How three schema architecture ensures logical and physical data independence?

What is NoSQL? Explain the characteristics of NoSQL.