DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION, MAY 2016
RDBMS
(2003 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
20 100)
1. Discuss about the data base schema.
Describe about different user interfaces.
2. Explain the concepts of relational model.
Discuss about data manipulation and data control
facilities.
3. Explain the overview of oracle database
architecture.
Discuss about client/server systems.
4. Write queries for selecting distinct values and
joining multiple tables in SQL.
Describe the elements of SQL language.
5. Write table creation with examples.
Discuss about embedded SQL statements.
Sub. Code
34
DE-3371
2
WS 20
6. Explain types of databases and relational databases
properties.
Discuss about benefits of Oracle.
7. Write queries for using expressions and working
with Null values in SQL.
Describe the data access SQL commands and DML
commands.
8. Discuss about database objects and indexes.
Discuss about the languages supported by Oracle
precompiler.