Will you please give me question paper for Tamil Nadu Open University 3rd Year Relational Database Management Systems Examination ?

Here I am giving you question paper for Tamil Nadu Open University 3rd Year Relational Database Management Systems Examination in PDF file attached with it so you can get it easily.

1. With relevant example explain the following
Integrity Constraints:
(a) Entity integrity
(b) Referential Integrity.

2. Discuss the purpose of COMMIT, SAVEPOINT
and ROLLBACK.

3. What is a Table Space? Discuss the need for the
same.

4. Consider the following relations :
STUDENT (Enrolment-no, Name, Date-of-birth,
Sex-code, Department-no)
DEPARTMENT (Department-no, Departmentname)
Write queries in SQL to perform the
following:
(a) List the Department-no and number of
students in each department. (2)
(b) List the Enrolment-no, Name, Departmentno,
Department-name of all students. (3)

5. With relevant examples discuss the use of the
following in SQL :
(a) IN
(b) NOT IN.

6. Consider the following relations :
STUDENT (Enrolment-no, Name, Date-of-birth,
Sex-code, Department-no)
DEPARTMENT (Department-no, Departmentname)
Develop DDL in Oracle 8i / 9i for the above
schema enforcing necessary integrity constraints.
7. Why Embedded SQL? Discuss.


TNOU 3rd Year Relational Database Management Systems Exam paper