Introduction to DBMS, Question Paper of BBA 4th Semester, Download Previous Years Question Paper 5

Roll No. ...........

Total No. of Questions : 07

BBA (Sem. - 4th)

INTRODUCTION TO DATABASE 

MANAGEMENT SYSTEMS

SUBJECT CODE : BB - 406

Paper ID [C0223]

INSTRUCTION TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.

2. SECTION-B contains SIX questions carrying TEN marks each and students has to attempt any FOUR questions.

SECTION-A

l. Answer briefly :

a. Define DBMS.

b. Define Metadata.

c. Expand the terms

i) DML

ii) DDL.

d. Differentiate between DBMS and RDBMS.

e. Define Normalization.

f. Differentiate between Primary Key and Unique Key.

g. Write a query to create a table of employees in SQL.

h. Explain the benefit for creating a view with taking a suitable example.

i. Write a SQL query which DBA uses to save the changes made in

database.

j. List the commands that are a part of DML.

SECTION-B

2. Draw an ER diagram for the library management database.

3. Explain network model in detail. How is it different from hierarchical model?

4. Explain the process of creating, saving and managing a database in MS-Access.

5. What do you understand by concurrency control? Explain any three techniques to achieve concurrency control.

6. Explain the concept of shadow paging and log-based recovery in recovery system with help of a suitable example.

7. Explain the role of DBA in management of database.