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

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

Total No. of Questions : 07

BBA (Sem. - 4th)

INTRODUCTION TO DATABASE

MANAGEMENT SYSTEMS

SUBJECT CODE : BB - 406

Paper ID [C0223]

Time : 03 Hours

Instruction to Candidates:

1) Section - A is Compulsory,.

2) Attempt any Four questions from Section - B.

Section – A

Q1)

a) What is data? Explain the need of data in an organization.

b) What is entity and attribute? Explain with an example.

c) Define Data independence,

d) What is SQL? Write the syntax for creating a table in SQL.

e) What is use of query in MS Access?

f) What is role of form in database management?

g) What is log based recovery?

h) What are integrity constraints? Explain.

I) What are '"weak entities? How is it different from strong entities?

j) Who is DBA? Explain his role in database management.

Section – B

Q2) What is DBMS? What are its advantages and disadvantages? Explain three level architecture of DBMS.

Q3) What are data models? Compare and contrast hierarchical, network and relational data models.

Q4) Define DDL, DML and DCL. Explain how view is created and destroyed.

Q5) What are anomalies in database? How normalization removes the anomalies? Explain First and Second normal form by taking suitable example. 

Q6) What are various threats to data security? Explain how data can be protected? Also discuss the use of biometrics in data security.

Q7) What is role of MS Access in database development? Explain the various components of MS Access.