#1
June 21st, 2014, 05:30 PM
| |||
| |||
TNOU 3rd Year Relational Database Management Systems Exam paper
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 Last edited by Neelurk; April 22nd, 2020 at 02:14 PM. |
|