II CSE DBMS Question Bank(IUnit)

Department of CSE
Q. Questions Questions Bloo m’s
No. CO Taxonomy
Leve1
UNIT-I

1 Define database management system and its Co1 BTL1

applications.

2 What are the advantages of using a DBMS? What is the CO1 BTL1
purpose of database management system ?

3 List and explain the limitations of file processing CO1 BTL5

system?
4 Compare database vs file processing system? CO1 BTL2

5 Explain the database system architecture with neat CO1 BTL2

diagram?

6 List and describe the components of database CO1 BTL2

management system with neat diagram

7 List and explain various database languages with CO1 BTL2

example?

8 Define Instance and Schema with examples CO1 BTL1

9 What is DBA?Explain functionalities of DBA. CO1 BTL2

10 Discuss about Database users and Administrators? CO1 BTL2

11 (a)Illustrate the importance of Database over File CO1 BTL2

Systems.
(b)What are the Functionalities of DBA and explain all
functionalities.
PART-II

1 What is ER Model? List the components of ER Model CO2 BTL1

2. Explain all the notations of ER Model CO2 BTL2

3. List the types of attributes. Explain each type with CO2 BTL2
example

4. What is an Entity and Entity set CO2 BTL1

5 Distinguish strong entity set with weak entity set? Draw CO2 BTL2
an ER diagram to illustrate weak entity set?

6. Identify the Classes Hierarchy in Database design with CO2 BTL3

neat diagram diagram

7. What is mapping cardinality? Explain cardinality types CO2 BTL2

with examples

8. Compare specialization and generalization properties in Co2 BTL2

classes hierarchy concept

9 Explain conceptual database design for large enterprises CO2 BTL2

with Example.
10 Compare Weak Entity set and Strong Entity with CO2 BTL2
example.

11 Explain the following keys CO2 BTL2

(i)Primary key (ii)Foreign key (iii)Unique
(iv)super key (v).Candidate key (Vi).Composite Key

12 Explain various relation ships , relationship sets and CO2 BTL2

various participation constraints among the entity sets.
13 Explain total and partial participation among the entity CO2 BTL2
sets with examples.

14 Draw ER Diagram for CO3

a. Railway Reservation System
b. Library Management System
c. Hospital Management System

UNIT-II
1 (a)Develop the below schemas in to ER Model CO3 BTL3
EMP (EID, ENAME, ESAL, EAGE) WORKS (EID, DID,
SINCE) DEPT (DID, DNAME)
(b)Show the Equivalent SQL queries for the following
questions
(i).Find the names of employees who belong to admin
department and earning more than 10,000.
(ii).Find the names of employees whose name starting
letter with ‘V’.
(iii).Find the names of employees who working for both
CSE and ECE Dept.
(iv).Find the maximum age of employee

2 Explain the following relational Algebra operators with CO4 BTL2

examples
(i)selection (ii)projection(iii).Cross product (iv)Rename

3 Explain all set operations in relational relational algebra CO4 BTL4

operations with examples

4 What is join operation in relational algebra? Discuss in CO4 BTL1

detail about variants of joins.

5. What is view? Explain importance of view with the CO4 BTL2

example.

6. Develop any ER Model into relational model(refer sailor CO4 BTL3

database)
7. Write the following queries in to SQL,Relational algebra CO4 BTL3
format
Supplier(sid,sname,srating,age,sadd)
Supplies(sid,pid,sdate,cost)
Parts(pid,pname,pcolor,pgurantee)
[Link] the above schemas into ER Model
[Link] all the table creations with keys.
[Link] 5 rows in each table
[Link] the names of supplier who supply red part
[Link] the cost of parts who supply washing machine
[Link] the supplier name who supply either refrigerator
or fan
[Link] the supply date of Laptop
[Link] the cost of all Aircoolers
[Link] the ages of supplier who supply all green color
parts
10 find the supplier who supply both air-cooler and
laptops.

8 Explain the basic operations and set operations of CO4 BTL2

relational algebra with suitable examples.

9 a) Explain division, selection and projection operators in CO4 BTL2

relation algebra with examples?
b) Explain aggregate operators with examples?

10 Illustrate the following Join operations and give one CO4 BTL2
example for each

i) Natural join ii)conditional join

iv)Eqi- join

11 What is an integrity constraints? Distinguish Primary CO4 BTL4

Key constraints and Foreign Key constraint with
example.

12 How can we Drop the table and view? Explain with CO4 BTL2
example.

UNIT II-PART-2
[Link] Basic form of SQL Query structure with Syntax
[Link] is nested and correlated nested queries and explain with example

[Link] set comparison operators with examples

[Link] Group by clause with example and also explain when will we using
Having Clause

[Link] Comparison using Null Values and Logical Connectives AND, OR,
and NOT operators with SQL Queries

[Link] the following with example SQL Queries in TRC & DRC format

Explain Relational Algebra Operations with example

(a)Left outer (b)Right outer (c) Full outer join

[Link] Complex integrity constraints in SQL (Both single level and multilevel)

[Link] is Trigger? Explain parts in triggers with sample trigger program.

UNIT-III

[Link] is Decomposition? Explain Problems caused by redundancy with example

[Link] Functional Dependency with Multivalued dependency

[Link] 1NF,2NF,3NF with examples.

[Link] BCNF with 3NF

[Link] lossless and lossy decomposable relations with examples

[Link] Closures of Attributes with example

[Link] out Inference rules

[Link] BCNF and 4NF with examples

[Link] is Partial dependency and fully functional dependency sets ?Explain with examples
UNIT-IV
 1. What is a transaction and Explain ACID properties?
(b).Explain transaction state diagram
3. What is Schedule? Explain types of schedule executions with examples?

4. What are the problems in interleaved execution? Explain with examples

5. Explain concurrency control with locking method. Explain 2phase locking and strict 2PL with
examples.

6. Explain concurrency control with time stamping method. Explain with Thomas write rule.

7. Explain concurrency control with optimistic method(Validation based protocol). Explain with
examples.

8. What is serializability?Explain Conflict serializability and view serializability.

9. Explain Failure classification
10. Explain the following
(a).Storage structures (b).Check points (c) Remote Backup Systems
11. Explain Log based and ARIES Recovery approaches.

UNIT-V

[Link] physical storage structures

[Link] RAID levels with Neat Diagram

[Link] Hierarchy of storage medium and also explain Magnetic Disk with neat diagram

[Link] Primary and secondary indexing and also explain sparse and dense indexing with
example

Explain Hash based indexing with example

Explain ISAM tree with example

Explain B+ Tree with search and insert operations

NOTE: Please Read All the Questions with answers for the examination

All The Best