[go: up one dir, main page]

0% found this document useful (0 votes)
103 views2 pages

Database Management System KCS501

This 3-paragraph summary covers the key points from the document: The document outlines questions for a Database Management Systems exam, covering topics such as physical data independence, the four functions of a DBA, recursive relationships, currency in databases, relational calculus, equi-joins, SQL clauses, attribute closures, transaction rollback, locking levels, DBMS components, relational algebra operations, dependency types, ACID properties, concurrency control methods, data models, DML types, database schemas, SQL and relational algebra queries, triggers, Armstrong's rules, normal forms, serializable schedules, deadlock detection and recovery, and concurrency control protocols. The exam aims to test students' understanding of fundamental database

Uploaded by

Mohit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
103 views2 pages

Database Management System KCS501

This 3-paragraph summary covers the key points from the document: The document outlines questions for a Database Management Systems exam, covering topics such as physical data independence, the four functions of a DBA, recursive relationships, currency in databases, relational calculus, equi-joins, SQL clauses, attribute closures, transaction rollback, locking levels, DBMS components, relational algebra operations, dependency types, ACID properties, concurrency control methods, data models, DML types, database schemas, SQL and relational algebra queries, triggers, Armstrong's rules, normal forms, serializable schedules, deadlock detection and recovery, and concurrency control protocols. The exam aims to test students' understanding of fundamental database

Uploaded by

Mohit
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

ilr ilil I illi il r Iililr I firr rffiilr I ililr ililil ilt

PAPER ID.410247
Roll No:

B. TECH.
(sEM V) THEORY EXAMINATION 2021-22
DATABASE MAI,{AGEMENT SYSTBM
Time: 3 Hours 'I'otal Mtrks: 100
Note: l. Attempt all Sections, lf require any missing data; then choose suitably.

SECTION A
1. Attempt all questions in brief. 2x I0:2(|
a. What is the signiticance of Physiciri Dara Independence'l
b. List. the four functions of DBA.
c. When a relation set is called a rer.:ursive relationship set?
d. \\&at do you msan by currency with respect to database?
e. What is Relational Calculus'/
t. What is Equi-Join in database?
g. What is a CLAUSE in terms of SQL?
h. Define the closnre of an attribute set.
i. When is a transaction Rolled Back?
j List the various levels o{'locking?

sEcrloN s
2. Attempt of the ibllowing:
any. three ' 10x3=30
a. Draw the overall strurcture of DBMS aud explain its various conrponents.
b. Which relational algebra operations require the participating tables to be union-
compatible? Give the Reason in detail.
What do you understand by transitive depenclencies? ExpIin u,ith an example
any tu,o problems that can arise in the database if transitive dependencies are
present in the database.
d. List ACID properties of transaction. Explain the usefi"rlness of each. What is
the importance ol'log?
e. What do you mean by time stamping protocol for concurrency controlling?
Discuss multi version scheme of concurrency control.

SECTION C
3" Attempt any one part of the tbllowing: l0xl:10
(a) What are the difl-erent types of Data Models in DBMS? Explain them.
(b) State the procedural DML and nonprocedrual DML rvith tlieir difI'ercnccs.

4. Attempt one part of the following:


any, 10 x I : l0
(a) Consider the follo\ving schema lor institute library:
Shrdent (RollNo, Name, Father Name, Branch)
Book (ISBN, Title, Author, Publisher)
Issue (RollNo, ISBN, Date-of -Issue)
Write the following queries in SQL and relational algebra.
I. List roll number and name of all students of the branch 'CSE'.
II. Find the name of student who has issued a book published by 'ABC'
j publisher.
III. List title of all books and their authors issued to a student 'R-{M'.
IV. List title sf all books issucd on or before December 1,2020.
V. List all books published by publisher'ABC'.
(b) What do you mean by trigger? Explain it by a suitable example.

L
rrl[reu rtgea Lor a
Subject Code: KC5501
l r ffill I illl ll I llllll
lll I t
PAPER ID410247
lllllll I lll ll llll ll lll
Roll No: li
Attempt one part of the following: 10x1: t0
-
^ny
(r) Describe Armstrong's axioms in detail' What the role of these rules in
database develoPment Process?
(b) Describe the term MVD in the context of DBMS by giving an example. Discuss
4NF and 5NF also.

6. Attempt any onepart of the following: 10 x I: 10


'bescribe
(a) serializable schedule: Discuss conflict serializability with suitable
examPle.
(b) Discuss the procedure ofdeadlock detection and recovery in transaction?

Lny onepart of the l'ollorving: 10 x 1 : 10


1. Attempt
^
(a) Givin u *rhrdul". S fbr transactions Tl and T2 with set of read and write
operations'
R l(x) R2(x) R2(y) w2(y) R I (Y) w I (x).
Identify, whether given schedule is equivalent to serial schedule or not?
(b) Discuss 2 phase cimmit (2PC) protoiol and time stamp based protocol
with
suitable example. How the validation based protocols differ from 2PC?

You might also like