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

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.     What do you mean by field and record in a table?

b.     What id DML?

c.      Define an entity?

d.     List the ACID property.

e.      Write the syntax to delete a table in SQL.

f.       What are the advantages of encrypting data stored in a database?

g.     What is a foreign key?

h.     Which types of failures occur in a database?

i.       What is the use of reports in MS-Access?

j.       Define a query?

Section-B

2.     Explain the concept of relationship between tables. Write the steps for creating relationships between tables in MS-Access.

3.     Explain the following commands with syntax and example.

a.     Create a table

b.     Insertion of data into a table.

c.      Delete operations

4.      How would you classify the DBMS users?

5.     Explain the disadvantages of the file system over the database system.

6.     What do you mean by Normalization? Explain 1NF in detail.