University of Madras
Chepauk, Chennai-600 005.
B.Sc Computer Science
SAE5B- NOVEMBER - 2005
PART A - (10 x 3 = 30 marks)
Answer any TEN questions. All questions carry equal marks. Each answer should not exceed 50 words. 1. What do you mean by Data Dictionary? 2. Write down the Three basic types of events occur in a database environment. 3. What is purpose of the keyword DISTINCT? Give an example. 4. What are the situations are to be considered while joining two tables? 5. What do you mean by Controls on FORMS? 6. What are 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 Data mining? 11.What are two basic difficulties to store the complex objects within relational databases? 12.What is Snapshot? PART B - (5 x 6 = 30 marks) Answer any FIVE questions. All questions carry equal marks. Each answer should not exceed 200 words. 13.Explain the potential benefits of feasibility study. 14. Discuss the two types of computations are used in queries. 15. Explain any three special operators frequently used in sub queries. 16.Explain the issues involved in designing reports. 17. What do you mean by a Custom Reports? Explain. 18. Explain the three major categories of operations affects tables. 19. Discuss the process of connecting a DBMS to a Web server. PART C - (4 x 10 = 40 marks) Answer any FOUR questions. All questions carry equal marks. Each answer should not exceed 500 words. 20. Discuss the procedure for converting a class diagram to normalized table with examples. 21. Illustrate various commands involved in DDL and DML. 22.Discuss various types of forms with examples. 23.Explain various primary methods of storing data. 24.Discuss the three user interface features. 25.Explain the Distributed database system. |
SAE5B-NOVEMBER - 2012
PART A - (10 * 2 = 20 marks)
Answer any TEN questions. Each answer should not exceed 50 words. 1. What are the Basic Components of a DBMS? 2. What is meant by First Normal Form? 3. Define: Data Dictionary. 4. What is SQL? 5. What is a subquery and in what situations it is useful? 6. What is the purpose of subforms? 7. What are the main reports types? 8. Define: Procedural Language. 9. What is the purpose of form events? 10. Define: Cluster Analysis. 11. Who is DBA? 12. Distinguish between Physical Security and Logical Security. PART B - (5 * 5 = 25 marks) Answer any FIVE questions. Each answer should not exceed 200 words. 13. Write Short Notes on: Data Types. 14. Discuss on Converting Class Diagrams to Normalized Tables, with examples. 15. Write Short Notes on: DDL Statements. 16. Discuss briefly on Form Layouts. 17. Write Short Notes on: Table Operations 18. Discuss in detail, Data Partitioning. 19. Write about Database Tasks by Development Stages. PART C - (3 * 10 = 30 marks) Answer any THREE questions. Each answer should not exceed 500 words. 20. What are the Advantages of a DBMS? Explain them. 21. Explain the computation using queries with suitable examples. 22. Explain creating forms with examples. 23. Explain the User Interface Features. 24. Describe in detail, Distributed Databases |