DISTANCE EDUCATION
P.G.D.C.A. EXAMINATION, MAY 2018.
First Semester
RELATIONAL DATABASE MANAGEMENT SYSTEMS
(2011 Calendar Year onwards)
Time Three hours Maximum 100 marks
SECTION A — x 8 40 marks)
Answer any FIVE questions.
1. Write a short note on the characteristics of Database.
2. What are the mapping operations in a relational model?
3. Discuss the benefits of oracle client/server systems.
4. Write short note about the elements of SQL language.
5. Give the reasons for database objects with an example.
6. Discuss the different user interfaces used in database
management system.
7. What are the commands available in DML? Write its
syntax and example.
8. Write a short note on embedded SQL statements with an
example.
Sub. Code
13
DE-3431
2
sp4
SECTION B — × 15 60 marks)
Answer any FOUR questions.
9. Explain in detail the schema and sub schema.
10. Write a brief note on relational model semantic issues
and efficiency.
11. Describe the architecture and network system in Oracle.
12. Illustrate with an example the different types of Joins in
SQL.
13. Discuss the following
Indexes
Embedded SQL languages.
14. Write brief note on data manipulation and data control
facilities m relational data model.
15. Discuss the various commands in DML and TCL with
their syntax and its uses.