Introduction To Database Management System 2021 – BSc CS Part 3

Total No. of Questions : 10] [To No. of Printed Pages : 4

Time: $1\tfrac{1}{2}$ Hours] [Maximum Marks: 50

Note : Attempt all sections as directed.

Section-A

Note : Attempt any two questions. 15 each

1. (a) What is Database ? What is DBMS ?

(b) Define primary key and foreign key with example.

2. (a) What is instance ? What is schema ?

(b) Explain the role of DBA.

3. (a) Explain the models : R. Codasyl with example.

(b) Explain hierarchical DBMS model with example.

4. (a) Define Normalization. Explain I and II Normal forms.

(b) Explain DBTG and IMS.

Section-B

Note : Attempt any one question. 20 each

5. Explain security, Privacy and authentication aspects in database.

6. (a) Define Data independence and list its types.

(b) Explain data integrity and reliability con-current operations on database.

7. (a) What is distributed Database ? Explain its advantages and disadvantages.

(b) What is relational model ? Give suitable example.

8. (a) Explain Data fragmentation.

(b) Explain deadlock and crashes.

9. (a) Explain the features of ORACLE 8i.

(b) Explain the data types in ORACLE 8i.

10. Write short notes on any two of the following :

(i) TCL

(ii) ACID

(iii) SQL

(iv) Checkpoint and Recovery

……..End……..

Thank You 🙂