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

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

1.       

a.     Define candidate and alternate keys. What are its uses?

b.     What is relationship between entity and attribute? Explain with example.

c.      Define cardinality and degree of relation.

d.     What is role of relational keys in relational database? What are its different types?

e.      Why concurrency control is needed? Explain

f.       What is lost update problem?

g.     What is table ? How it is different from relation.

h.     Explain how query is created in Ms Access? Explain its use.

i.       What is difference between delete and drop statement of SQL.

j.       What are various techniques of database recovery?

Section –B

2.     What is need of DBMS? Explain various advantages and disadvantages of DBMS.

3.     What is normalization? What are its goals? Explain how first and second normal form makes data consistent.

4.       

a.     Define SQL ? explain various features of DDL, DML and  DCI.. Also tell which of these statements can never be rolled back.

b.     What is view? Explain various advantages of view.

5.     What is MS Access? Explain its features. Explain how you will create table and database in MS Access.

6.     What are physical and object data model? Explain how relational model is different form hierarchical and network model.

7.     Write note on:

a.     Explain different methods to secure data in database.

b.     What is grant and revoke statement. Explain their purpose.