DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION,
DECEMBER 2017.
Computer Applications
RDBMS
(2003 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
× 20 100)
1. Explain the logical and physical schema.
Describe about different user interfaces.
2. Explain in detail about the Mapping operations of
Relational Model.
3. What are the benefits of RDBMS?
Write a note on Data dictionary System tables.

4. Discuss about DML.
Discuss on the basic queries using expressions.
Show that with examples.
5. State the various uses of a sub query. What
constraints are transferred to the newly created
table with a sub query?
What are the differences between SQL and SQL*
plus?
Sub. Code
34
DE-2487
2
Ws6
6. Explain on how to create a table, modify a table, Rename
a table, copying from another table and to drop the table
with examples.
7. Write bout client/server system.
What is Database schema? Explain.
8. List the reasons why the null values might be
introduced into the database.
Write a detail note on query optimization.
————————