Madras University (UnOM) 2005 B.Sc Computer Science database management systems - Question Paper

PART A - (10 x three = 30 marks)

ans any TEN ques..All ques. carry equal marks.

every ans should not exceed 50 words.

1.What do you mean by Data Dictionary?

2. Write down the 3 basic kinds of events occur in a database environment.

3. What is purpose of the keyword DISTINCT? provide an example.

4. elaborate the situations are to be considered while joining 2 tables?

5.What do you mean by Controls on FORMS?

6. elaborate the primary philosophies for handling errors?

7.What are main strengths of a reports?

8. How do you decide which method should be preferred to store and retrieve data?

9.What do you mean by icons?

10.What is Datamining?

11. elaborate 2 basic difficulties to store the complex objects within relational databases?

12.What is Snapshot?

PART B - (5 x six = 30 marks)

ans any 5 ques..

All ques. carry equal marks.

every ans should not exceed 200 words.

13.Explain the potential benefits of feasibility study.

14. explain the 2 kinds of calculations are used in queries.

15. discuss any 3 special operators frequently used in sub queries.

16.Explain the problems involved in designing reports.

17. What do you mean by a Custom Reports? discuss.

18. discuss the 3 major categories of operations affects tables.

19. explain the process of connecting a DBMS to a Web server.



PART C - (4 x 10 = 40 marks)

ans any 4 ques..

All ques. carry equal marks.

every ans should not exceed 500 words.

20. explain the procedure for converting a class diagram to normalized table with examples.

21. Illustrate different commands involved in DDL and DML.

22.Discuss different kinds of forms with examples.

23.Explain different primary methods of storing data.

24.Discuss the 3 user interface features.

25.Explain the Distributed database system.

Earning:   Approval pending.