Mahatma Gandhi University (MGU) 2008 B.Tech Computer Science and Engineering Database Management Systems(Improvement/Supplymentary)- - Question Paper

1. What is meant by data independence?

2. List the components of DBMS.

3. Differentiate ranging from DDL and DML.

4. Write a note on views of SQL.

5. What is meant by catastrophic failure?

6. Discuss the storage organization in Oracle.

7. What is meant by multi valued dependency?

8. Explain 5th normal form.

9. What is data replication? elaborate its advantages?

10. Discuss vertical fragmentation. [10*4=40 marks]

11. Explain the three-schema architecture of DBMS.

OR

12. Design an ER schema diagram for a Library Management system.

13. Explain in detail with examples and syntax, different forms of queries in SQL.

OR

14. Describe the structure of a relational database schema in general. With the help of an example illustrate all basic concepts like keys, constraints relationships etc. in the schema.
15. Discuss the cost components for a cost function that is used to estimate query execution cost.
OR
16. Explain the database structure and its manipulations in Oracle.

17. What are the pitfalls in Relational database design? explain with examples.

OR
18. Use the axions for functional and multi valued dependencies to show that the subsequent rules are sound:-
(i)The multi valued union rule.
(ii)The intersection rule.
(iii)The difference rule.

19. When it is useful to have replication or fragmentation of data? discuss.
OR
20. Narrate the distributed database systems in Oracle. [5*12=60 marks]

Earning:   Approval pending.