DISTANCE EDUCATION
B.C.A./B.C.A. (Lateral) DEGREE EXAMINATION, MAY 2018.
RDBMS
(2003 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
x 20 100)
1. Differentiate between schema and subschema.
With a neat sketch, describe the various
components of database management system.
2. Explain the concept of relational model with an
example.
Describe the data definition facilities with suitable
examples.
3. Write the properties of Relational Database.
Outline the overview of Oracle architecture.
4. How can you work with NULL values?
What are the arithmetic operations that can be
performed on date fields? Explain.
5. How can you create and drop a table? Explain with
an example.
What is an Index? Explain how can you use indexes.
Sub. Code
34
DE-3587
WSS
2
6. What are nested queries? How would you use the
operators IN, ANY and ALL in writing nested
queries?
Explain the following set-manipulation constructs
UNION
INTERSECT.
7. How do we declare variables and exceptions in
Embedded SQL?
Write about database objects.
8. Compare and contrast the features of hierarchical,
network with relational data model.
————————