DISTANCE EDUCATION
P.G.D.C.A. EXAMINATION, MAY 2017.
First Semester
Computer Applications
RELATIONAL DATABASE MANAGEMENT SYSTEMS
(2011 Calendar Year onwards)
Time Three hours Maximum 100 marks
SECTION A — × 8 40 marks)
Answer any FIVE questions.
1. Define the term "DBMS". What are the advantages of
DBMS?
2. Discuss the typical user friendly interfaces and the types
of users who use each.
3. Describe any five terminologies related to relational
model.
4. Explain about the mapping operations of relational
database.
5. Write down the benefits of Oracle.
6. State the various uses of a subquery.
7. Illustrate with examples, how joining multiple tables in a
query.
8. Explain how to create table in Oracle.
Sub. Code
13
DE-031
2
Ws 5
SECTION B — × 15 60 marks)
Answer any FOUR questions.
9. What is a Database Schema? Explain about the schema
and subschema of the database.
10. Discuss in detail about the referential integrity and
entity integrity properties.
11. What are Data Definition and Data Control commands in
relational model? Explain with examples.
12. Discuss the architecture of Oracle database.
13. What are DML commands in SQL? Explain.
14. Write a short note on
Database Privileges
Indexes
Oracle Precompiler.
15. What are the features of embedded SQL? Explain.