Download AKTU B-Tech 4th Sem 2016-17 Database Management System Question Paper

FirstRanker.com

Roll

B.TECH.

--- Content provided by​ FirstRanker.com ---

THEORY EXAMINATION (SEM–IV) 2016-17

DATABASE MANAGEMENT SYSTEM

Time: 3 Hours

Max. Marks : 100

Note: Be precise in your answer.

--- Content provided by​ FirstRanker.com ---

SECTION – A

10 x 2 = 20

1. Attempt the following:

   1. Explain Specialization.

   --- Content provided by FirstRanker.com ---

   2. Write Advantages of Database.

   3. Define DML.

   4. Explain Logical data Independence.

      --- Content provided by‍ FirstRanker.com ---

   5. Explain Entity Integrity Constraints.

   6. Define 2 NF.

   --- Content provided by‍ FirstRanker.com ---

   7. Explain I in ACID Property.

   8. Define schedule.

   9. Define Exclusive Lock.

      --- Content provided by⁠ FirstRanker.com ---

   10. Define replication in distributed database.

SECTION - B

--- Content provided by⁠ FirstRanker.com ---

2. Attempt any five of the following questions:

   5 x 10 = 50

   1. Discuss the role of database administrator.

   2. Explain the Primary Key, Super Key, Foreign Key and Candidate key with example.

      --- Content provided by​ FirstRanker.com ---

   3. Draw an ER diagram of Hospital or Bank with showing the Specialization, Aggregation, and Generalization. Also convert it in to relational schemas and SQL DDL.

   4. Discuss Join and Types with suitable example.

   --- Content provided by​ FirstRanker.com ---

   5. What is Trigger? Explain different trigger with example

   6. Short Notes on the Following:

      1. MVD or JD

      --- Content provided by FirstRanker.com ---

      2. Normalization with advantages

      3. BCNF VS 3NF

   --- Content provided by​ FirstRanker.com ---

   7. What is Log? How is it maintained? Discuss the features of deferred database modification and immediate database modification in brief.

   8. What is Two phase Locking (2PL)? Describe with the help of example.

--- Content provided by FirstRanker.com ---

SECTION – C

3. Attempt any two of the following questions:

   2 x 15 = 30

   What do you mean by serializability? Discuss the conflict and view serializability with example. Discuss the testing of serializability also.

--- Content provided by FirstRanker.com ---

4. What are multi version schemes of concurrency control? Describe with the help of an example. Discuss the various Time stamping protocols for concurrency control also.

5. Consider the following relation. The Primary key is Roll No, ISBN –Student (Roll No, Name, Branch), Book (ISBN, Title, Author, Publisher), Issue (Roll No, ISBN, Date_of_issue) Write the query in Relational algebra and SQL of the following-

   1. List the Roll Number and Name of All CSE Branch Student.

   --- Content provided by FirstRanker.com ---

   2. List the title and author of all books which are issued by a student name started with a.

   3. List the title of all books issued on or before 20/09/2012.

   4. List the name of student who will read the book of author named ‘Sanjeev’.

      --- Content provided by​ FirstRanker.com ---

FirstRanker.com