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

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 a database?

 b) What are the major functions performed by a DBA?

 c) Define DDL.

 d) What is a Tuple?

 e) Write the Syntax for modification of structure of a table.

 f) What is the difference between physical schema and logical schema?

 g) What is Integrity?

 h) What is a primary key?

 i) Define Instances and Schema.

 j) What are Macros?

Section - B

Q2) Discuss the different components of MS-Access.

Q3) Describe the procedure to create a form.

Q4) What are the advantages and disadvantages of a DBMS?

Q5) Write notes on:

a) Concurrency control 

b) Integrity constraints

Q6) Define Transaction. Explain transaction with state diagram and also write

in detail the ACID property.