AR 22

GIET UNIVERSITY, GUNUPUR – 765022

B. Tech ( 3rd Semester) Question Bank
Database Management System
(CSE,AIML,DS)

UNIT – I
PART – A (2 Marks)

Short Answer Questions CO # Blooms

Level

1. Define and discuss data constraints CO1 KL2

2. Describe the components of DBMS CO1 KL2
3. Create a table for Student with following attributes Sid Number, Sname Varchar2,
CO1 KL4
Marks Number and Average Number (3, 2). Enter 5 students detail into it.
4. List the differences between DROP and DELETE CO1 KL2
5. What is a data dictionary? CO1 KL2
6. Define the following terms: CO1 KL2
i. meta-data​ ii. View of data
7. List the difference between schema and instances. CO1 KL2
8. List and Define the different types of data independency. CO1 KL2
9. Define mapping in 3-schema architecture with example. CO1 KL2
10. Illustrate how the redundancy is controlled by the database approach CO1 KL2
11. Write the syntax to ADD a column to the existing table CO1 KL1
12. Describe the components of DBMS CO1 KL2
13. Narrate the disadvantages of File Processing System? CO1 KL2
14. What is SQL stands for and explain features CO1 KL1
15. Who is a DBA? What are the responsibilities of a DBA? CO1 KL1

PART – B (15 Marks)

Long Answer Questions Marks CO # Blooms

Level

1. a. Explain 3 level- architecture with block- diagram. 8M CO1 KL2

b. Explain about Data abstraction with its levels? 7M CO1 KL2
2.a. Discuss about DBMS Users. Explain about DBA and his/her 8M KL3
CO1
responsibility on DBMS?
b. Discuss the various disadvantages of file system and explain how it can 7M KL3
CO1
be overcome in DBMS
3. a. Explain the structure of DBMS With neat diagram 8M CO1 KL2
b. Discuss different data models of Database 7M CO1 KL3
4.a. Define database language? Write its types? 8M CO1 KL2
b. What you mean as mapping cardinalities and explain? 7M CO1 KL2
5. a. 1.​ Write a query to create a table employee with empno, ename,
8M CO1 KL4
designation, and salary.

Page 1 of 6
 2.​ Write a query to display the column name and data type of the
table employee.
3.​ Write a query for create a table from an existing table with all
the fields
4.​ Write a query to add multiple columns in to employee
b. Explain about database constraints in details 7M CO1 KL2
6.a. What is data integrity? Explain the types of integrity constraints 8M CO1 KL2
b. Define DBMS? List the various applications of DBMS 7M CO1 KL2
7.a. Draw an ER diagram for University Management System 10M CO1 KL4
b. Discuss about the purpose of Database management System 5M CO1 KL2

UNIT – II
PART – A (2 Marks)

Short Answer Questions CO # Blooms

Level

1. The syntax to insert a value to the existing table. CO2 KL3

2. What do you mean by Specialization and Generalization CO2 KL2
3. How Relational Calculus is different from Relational Algebra? CO2 KL2
4. Name and briefly describe the five SQL built-in functions. CO2 KL2
5. Define Normalization and Explain 2NF? CO2 KL2
6. Enlist the various relationships of database with suitable example? CO2 KL2
7. Define Join and Explain Full Outer Join CO2 KL2
8. What is an SQL sub query? CO2 KL1
9. Define Decomposition. CO2 KL2
10. Define Query processing and Query Optimization CO2 KL2
11. Explain importance of Query Optimizer CO2 KL2
12. What is Multivalued Dependency and Explain CO2 KL1
13. What do you meant by integrity constraint? CO2 KL1
14. What is Database Design and Explain CO2 KL1
15. For a relation R(A,B,C,D,E) the functional dependency is given by CO2 KL3
FD:{A B,D E}. Find the candidate keys.

PART – B (15 Marks)

Long Answer Questions Marks CO # Blooms

Level

1. a. With relevant examples discuss the various operations in Relational 10M CO2 KL2
Algebras.
b. Give the following queries in the relational algebra using the relational 5M CO2 KL3
schema
student(id, name)
enrolledIn(id, code)
subject(code, lecturer)
i.​ What are the names of students in both cs1500 and cs1200?

Page 2 of 6
 ii.​ What are the names of all the students in cs1500?
Who teaches cs1500 or cs3020?
2.a. Explain about Normalization with its advantages? 10M CO2 KL2
b. Define RDBMS and explain about redundancy and Anomaly? 5M CO2 KL2
3. a. Give the following queries in SQL 8M CO2 KL3
i.​ To change the column EMPNO NUMBER (4) TO EMPNO
NUMBER (6) in Employees table.
ii.​ To display name, job, salary of employees whose name is
starting with ‘B’.
iii.​ To display empno, name, job, salary, location whose
salaries not from 10000 to 30000.
iv.​ Find the name of the employee working at Mumbai.
b. What you mean as mapping cardinalities and explain? 7M CO2 KL2
4.a. Consider​ the​ following​ relation​ : EMP 5M CO2 KL3
(ENO, NAME, DATE_OF_BIRTH, SEX, DATE_OF_JOINING,
BASIC_PAY, DEPT) Develop an SQL
query that will find and display the average BASIC_PAY in each
DEPT.
b. Discuss different data models of DBMS. Construct an E-R diagram 10M CO2 KL3
for a car-insurance company whose customers own one or more cars
each. Each car has associated with it zero to any number of recorded
accidents. State
any assumptions you make
5. a. Define​ following​ a)​ functional​ dependency.​ b)Partial 8M CO2 KL2
dependency c0Join dependency
b. Discuss Join Dependencies and Fifth Normal Form, and explain why 7M CO2 KL2
5NF?
6.a. Illustrate about Query evaluations cost & Selection operation 7M CO2 KL2
b. Write short notes on the following 8M CO2 KL2
Transaction Control Statements (TCS),Data Control Language (DCL)
7.a. What you mean as enhanced ER Model and discuss about 7M CO2 KL2
Generalization and specialization
b. Explain about relational query languages? 8M CO2 KL2
8.a. Discuss about Transitional dependency with suitable example tables? 7M CO2 KL2
b. Consider two set of FD’s F and G and find out whether they are 8M CO2 KL3
equivalent or not?
F:{A C,AC D,E AD,E H} & G:{A CD,E AH}

UNIT – III
PART – A (2 Marks)

Short Answer Questions CO # Blooms

Level

1. Explain Cache Memory. CO3 KL2

2. What is called mirroring? CO3 KL1
3. Distinguish between sparse index and dense index CO3 KL2
4. Explain database Trigger? CO3 KL2

Page 3 of 6
 5. Explain any two storage devices. CO3 KL2
6. Describe flash memory. CO3 KL2
7. How does B-tree differ from a B+ tree? Why B+ tree usually preferred as an access CO3 KL2
structure to a data file?
8. Explain bit and block -level striping? CO3 KL2
9. What are a block and a block number? CO3 KL1
10. What are the factors to be taken into account when choosing a RAID level? CO3 KL2
11. What is known as heap, sequential and hashing file organization? CO3 KL1
12. What is the role of the disk space manager? CO3 KL1
13. Define Security in Database CO3 KL2
14. Explain B+ tree index files CO3 KL2
15. List the advantages and disadvantages of indexed sequential file CO3 KL2

PART – B (15 Marks)

Long Answer Questions Marks CO # Blooms

Level

1. a. Describe the different types of file organization? 10M CO3 KL2

b. Describe flash memory. 5M CO3 KL2
2.a. Illustrate about RAID in detail 10M CO3 KL2
b. Describe static hashing and dynamic hashing 5M CO3 KL2
3. a. Describe the structure of B+ tree and give the algorithm for search in 8M CO3 KL3
the B+ tree with example.
b. Illustrate the two types of ordered indices? 7M CO3 KL2
4.a. Define cardinality ratio and participation constraint. Explain with 8M CO3 KL2
suitable examples.
b. Illustrate what you mean by Schema-based constraint with a suitable 7M CO3 KL2
example.
5. a. Describe the storage structure of B+ tree files and their access method 8M CO3 KL2
with examples.
b. Explain different storage devices in database 7M CO3 KL2
6.a. Discuss about network and object oriented data models? 8M CO3 KL2
b. Explain current page table and shadow page table. 7M CO3 KL2
7.a. Distinguish between Primary and secondary indexing. 7M CO3 KL2
b. Consider the universal relation R={A,B,C,D,E,F,G,H,I} and the set of 8M CO3 KL3
functional dependencies
F={A,B C, A D,E,B F,F G,H,D-- I, J}
i.​ What is the key for R?
ii.​ Decompose R into 2NF,then 3 NF relations
8.a. The primary keys of the records are given as : 5,1,3,12,10,18,2,7,4,20 7M CO3 KL2
Using B+ tree of order 4, explain how the records are arranged in the
file.
b. What are Armstrong‘s axioms and why its required? Use Armstrong 8M CO3 KL2
axioms to prove the soundness of decomposition rule and pseudo
transitive rule.

UNIT – IV
Page 4 of 6
 PART – A (2 Marks)

Short Answer Questions CO # Blooms

Level

1. Define Isolation Property with example. CO4 KL2

2. Explain about Locking and Timestamp. CO4 KL2
3. Explain about database recovery system. CO4 KL2
4. When a transaction is said to be rolled back? CO4 KL2
5. Explain Shared-Exclusive locking protocol CO4 KL2
6. Describe different types of failure & why recovery is needed? CO4 KL2
7. Define serializability. CO4 KL2
8. What is Parallel database and explain CO4 KL1
9. What you mean as concurrent execution? CO4 KL1
10. What you mean as commit and undo in case of transaction? CO4 KL1
11. List the two commonly used Concurrency Controlled techniques CO4 KL2
12. What are two pitfalls (problems) of lock-based protocols? CO4 KL1
13. What do you mean by a transaction CO4 KL1
14. What are the states of transaction? CO4 KL1
15. What are the ACID properties? CO4 KL1

PART – B (15 Marks)

Long Answer Questions Marks CO # Blooms

Level

1. a. Explain Transaction process and concurrency control and 8M CO4 KL2

explain properties of Transaction control
b. Discuss on strict, two-phase locking protocol and time stamp- 7M CO4 KL2
based protocol
2.a. Explain the Properties of transactions? How can you implement 8M CO4 KL2
atomicity in transactions? Explain.
b. Explain about concurrency control schemes in detail? 7M CO4 KL2
3. a. Explain the following a)database failure b)database recovery 8M CO4 KL2
b. Discuss the following: a)Distributed databases b)Parallel databases 7M CO4 KL2
4.a. Explain about data warehousing and data mining 8M CO4 KL2
b. Illustrate in detail about object oriented databases? 7M CO4 KL2
5. a. Explain about log based recovery in DBMS? 7M CO4 KL2
b. What is concurrent transaction recovery? And explain Check points? 8M CO4 KL2
6.a. Write Short notes on i) shadow paging ii )Equivalence iii) Data 8M CO4 KL2
Mining
b. Explain about deadlock handling mechanism in DBMS. 7M CO4 KL2
7.a. What is clustered index organization? Illustrate with example. 8M CO4 KL2
b. Discuss about different states of transaction. 7M CO4 KL2
8.a. Explain Query processing by using suitable block diagram. 8M CO4 KL2
b. Explain about various file operation performed on DBMS. 7M CO4 KL2

Page 5 of 6
 ---

Page 6 of 6