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

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 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. Write briefly :

(a) Importance of Data.

(b) Explain the term Entity.

(c)What is the use of Access in managing databases?

(d) Explain the term Data Recovery.

(e) Explain the term Data Security.

(f) What are the limitations of databases?

(g) What are the advantages of Relational Databases?

(h) Explain the term Tupple.

(i) How to create table in Access?

(j) What is the procedure of creating table in MS Access?

SECTION-B

2. Define, in your words, database and database management system. Discuss the objectives and advantages of database. Illustrate by giving suitable examples.

3. How would you differentiate between Hierarchal and Network Model? Explain in detail by citing suitable examples.

4. What are various aspects of Data Protection? Explain in detail by taking relevant examples.

5. What are the special features of Relational databases? Explain in detail by giving suitable examples.

6. What do you understand by Normalization? Explain the First and Second Normal forms of Database. Explain in detail.

7. Explain in detail the various features of SQL. Explain the procedure of creating database and running a query in SQL by giving suitable example.