Looking for original question paper Madras University B.Sc Computer Science? Given below is an original question paper of 05th Semester B.Sc Computer Science in Madras University. The exam paper is Database Management System which was conducted in the exam year 2013 in November. Question Paper Number is 51313 for the exam. The maximum marks for the exam is 75 marks. Collect the contents below.
Get another sample old model previous years question paper, Madras University II year BCA - SAZ4A Programming in Java 2014 Question Paper
University: Madras University
Month and Year of Examination: November - 2013
Question Paper Number: 51313
Course: B.Sc Computer Science
Subject Name: Database Management System
Subject Code: SEE5B
Semester: 05
Year: Third Year
Time: Three hours
Maximum: 75 Marks
Section – A (10 x 2 = 20 marks)
Answer any TWO questions.
All questions carry equal marks.
Each questions carry equal marks.
1. Write any two integrity rules of the relational model.
2. What is denormalization?
3. Define SQL.
4. Write any four data types.
5. How do you delete unwanted rows?
6. Write any four Arithmetic Operation.
7. Define JOIN.
8. What do you mean my Literals?
9. Differentiate between static and dynamic cursor.
10.What is a PL/SQL table?
11.Differentiate between Actual and Formal parameters.
12. What is Composite Key?
Section – B (5 x 5 = 25 marks)
Answer any FIVE questions.
All questions carry equal marks.
13. Explain any two normal form.
14. What is the need of Dependency diagram? Explain it.
15. What are the functions of the SQL*PLUS environment?
16. Write any four set operator? Explain it.
17. Explain Data Manipulation language.
18. What are the two parts of blocks in PL / SQL? What are the differences between them?
19. Differentiate between array and PL/SQL table.
Section – C (3 x 10 = 30 marks)
Answer any THREE questions.
All questions carry equal marks.
20. Explain Relational algebra and Calculus.
21. (a) How do you create Oracle table?
(b) Name any two oracle data dictionary tables and give their use.
22. Describe the various types of Built-in-function.
23. Write short notes on PL/SQL cursor and exception.
24. Explain with an example of Pl/SQL named blocks.
Get another sample old model previous years question paper, Madras University II year BCA - SAZ4A Programming in Java 2014 Question Paper
University: Madras University
Month and Year of Examination: November - 2013
Question Paper Number: 51313
Course: B.Sc Computer Science
Subject Name: Database Management System
Subject Code: SEE5B
Semester: 05
Year: Third Year
Time: Three hours
Maximum: 75 Marks
Section – A (10 x 2 = 20 marks)
Answer any TWO questions.
All questions carry equal marks.
Each questions carry equal marks.
1. Write any two integrity rules of the relational model.
2. What is denormalization?
3. Define SQL.
4. Write any four data types.
5. How do you delete unwanted rows?
6. Write any four Arithmetic Operation.
7. Define JOIN.
8. What do you mean my Literals?
9. Differentiate between static and dynamic cursor.
10.What is a PL/SQL table?
11.Differentiate between Actual and Formal parameters.
12. What is Composite Key?
Section – B (5 x 5 = 25 marks)
Answer any FIVE questions.
All questions carry equal marks.
13. Explain any two normal form.
14. What is the need of Dependency diagram? Explain it.
15. What are the functions of the SQL*PLUS environment?
16. Write any four set operator? Explain it.
17. Explain Data Manipulation language.
18. What are the two parts of blocks in PL / SQL? What are the differences between them?
19. Differentiate between array and PL/SQL table.
Section – C (3 x 10 = 30 marks)
Answer any THREE questions.
All questions carry equal marks.
20. Explain Relational algebra and Calculus.
21. (a) How do you create Oracle table?
(b) Name any two oracle data dictionary tables and give their use.
22. Describe the various types of Built-in-function.
23. Write short notes on PL/SQL cursor and exception.
24. Explain with an example of Pl/SQL named blocks.
0 comments:
Pen down your valuable important comments below