www.keralapsctips.blogspot.in (Rutronix and C-Dit Computer Previous Questions)

CENTRE FOR DEVELOPMENT OF IMAGING TECHNOLOGY (Under Government of Kerala)

CEP EXAMINATION- MAY 2013 Subject:RDBMS DCA Register No.

I. Fill in the blanks. Answer ALL questions.

Time: 3 Hours Maximum Marks:100

(10 x 1 = 10)

1. ___________ are used to ensure accuracy and consistency of data in a relational database. 2. Overall design of the database is called ___________ 3. A _________ key is a candidate key, chosen as a principal to identify a unique tuple of a relation. 4. Automatically executed code in DBMS is known as ____________ 5. ___________ is a computer language for defining data structures. 6. In ___________ database model, all the data in the database are represented using a simple rowcolumn type. 7. A __________ is a logical linkage between two entities, that describes how those entities are associated with each other. 8. ____________ is a technique for reducing disk accesses for direct access. 9. Number of attributes in a relation is called ____________ of a relation. 10. ____________ is a constraint between two sets of attributes in a relation from a database. II.Explain briefly. Answer any TEN questions.

(10 x 4 = 40)

1. Explain briefly about Referential Integrity. 2. Write a short note on Aggregate Functions in Oracle. 3. What is Cross join? Give an example. 4. Explain briefly about Log-Record Buffering. 5. Write a short note on THREE levels of Data Abstraction. 6. What are the disadvantages to the shadow-page technique? 7. What is indexing? Explain with the help of an example.

Code No.Q13MAY 252

[P.T.O]

www.keralapsctips.blogspot.in (Rutronix and C-Dit Computer Previous Questions)

8. What are the functions of DBMS? Explain. 9. Write a note on integrity constraints. 10. Explain the concepts of Hashing. 11. Explain concurrency control mechanism. 12. Explain briefly about Referential Integrity. 13. Explain the concept of keys. III.Answer any FIVE questions. Explain in detail. 1. Write short notes on: (a) Advantages of RDBMS. (b) Foreign Key and Primary key. 2. Give an idea about File Organization. Explain briefly about the different types of file organization. 3. What do you know about Normalization? Explain 1st, 2nd, and 3rd normal forms. 4. Explain different types of data model. 5. Explain database system architecture. 6. Briefly explain deadlock. Discuss deadlock detection and prevention mechanisms. 7. Explain fundamental relational operations with example.

---------------

Code No.Q13MAY 252

(5 x 10 = 50)