Monday, April 20, 2015

B.Sc Computer Science SEE5B Database Management System Madras University 2013 Question Paper

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. 
Share This
Previous Post
Next Post

B.E Civil Engineer Graduated from Government College of Engineering Tirunelveli in the year 2016. She has developed this website for the welfare of students community not only for students under Anna University Chennai, but for all universities located in India. That's why her website is named as www.IndianUniversityQuestionPapers.com . If you don't find any study materials that you are looking for, you may intimate her through contact page of this website to know her so that it will be useful for providing them as early as possible. You can also share your own study materials and it can be published in this website after verification and reviewing. Thank you!

0 comments:

Pen down your valuable important comments below

Search Everything Here