DISTANCE EDUCATION
P.G.D.C.A. EXAMINATION, DECEMBER 2017.
First Semester
RELATIONAL DATABASE MANAGEMENT SYSTEMS
(2011 Calendar Year onwards)
Time Three hours Maximum 100 marks
PART A — × 8 40 marks)
Answer any FIVE questions.
1. What are the guidelines to be considered while using a
database with different user interfaces?
2. Distinguish schema of a database from subschema of the
same database.
3. Elucidate the semantic issues of a relational model.
4. Give a note on network system tables of oracle.
5. Discuss on various types of relational databases.
6. List and explain the various elements of SQL language.
7. Elucidate the languages that are supported by oracle
precompiler.
8. Illustrate and explain the procedure of joining multiple
tables using a query statement.
Sub. Code
13
DE-2331
2
Ws3
PART B — × 15 60 marks)
Answer any FOUR questions.
9. Give a neat description on database schema. Also list the
features, advantages and applications of DBMS.
10. Compare and contrast Data Manipulation Language with
Data Definition language.
11. Write notes on:
Relational Database properties.
Benefits of oracle.
Logical structures used in oracle.
12. Discuss the concept of datalogs used as data control
facilities.
13. What are physical files of oracle database? Explain with
oracle database architecture.
14. Give a detailed note on oracle queries with basic queries,
working with NULL values and unions and multiple past
queries.
15. Explain the following with syntax and suitable examples:
Creation and description of a table.
Modifying and copying table.
Embedded SQL statements (any three).
————————