DISTANCE EDUCATION
P.G.D.C.A. EXAMINATION, MAY 2016.
First Semester
RELATIONAL DATA BASE MANAGEMENT SYSTEMS
(2011 Calendar year onwards)
Time Three hours Maximum 100 marks
PART A — × 8 40 marks)
Answer any FIVE questions.
1. Define
Primary key
Foreign key with examples.
2. How database differs from data file?
3. Mention the concepts of relational model.
4. Discuss on Data manipulation facilities.
5. What are the benefits of Oracle?
6. Explain the concept of logical structures in Oracle.
7. What is Query? How it can join multiple tables?
8. How to create and modify a table?
Sub. Code
13
DE-3231
2
ws 15
PART B — × 15 60 marks)
Answer any FOUR questions.
9. Explain the concepts of Schema and sub Schema.
10. Mention the advantages of Database management
system.
11. How navigation and efficiency can be improved in
relational model?
12. Discuss on data control facilities.
13. Explain the architecture of oracle database.
14. Discuss on DML commands.
15. Briefly discuss on the languages supported by Oracle
precompiler.