DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION, MAY 2017.
RDBMS
(2003 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. Draw the overall system structure of database
system.
Describe various types of user interfaces.
2. Explain about the semantic issues in Relational
model.
How data manipulation is done in Relational model?

3. Discuss about the benefits of Oracle in detail.
Explain about the various Oracle users in detail.
4. Briefly explain about the elements of SQL language.

How to join multiple tables in a query? Explain with
an example.
Sub. Code
34
DE-184
2
WK 6
5. Discuss on the Relational database properties in
detail.
Explain the Union and multiple part queries with
an example for each.
6. Write SQL query to create a student table with the
fields are student name, regno, mark1, mark2,
mark3, mark4 and mark5.
Write SQL query to calculate the total, average and
display the student details.
7. Give the syntax and purpose for joining table
command with an example.
What is the importance of Privilege command?
Explain with an example.
8. Explain in detail about Embedded SQL commands with
an example.