DISTANCE EDUCATION
B.Sc. (IT)/B.Sc. (Lateral) DEGREE EXAMINATION,
MAY 2018.
RDBMS
(2007 onwards)
Time Three hours Maximum 100 marks
Answer any FIVE questions.
All questions carry equal marks.
1. Write short notes on DBMS with its advantages and
disadvantages.
Discuss in detail about the schema and sub schema.
2. Give short notes on Relational model.
Explain the various mapping operations in
relational model.
3. Compare and contrast different types of database
with example.
Explain the overview of oracle database
architecture.
4. Write short notes on Relational Database
Properties.
Explain about working with NULL values with
suitable example.
5. Create a table with sufficient entries for employee
database and perform basic query operations.
Explain in detail about Embedded SQL.
Sub. Code
35
DE-3632
2
Ws3
6. Discuss about the concept of DML commands and
oracle queries.
Describe about the Data definition and facilities.
7. Generate Queries using the following statement
with suitable example.
Group by statement
Order by statement.
Briefly explain about data objects and data access
commands.
8. Explain in detail about the different languages that
are supported by the oracle pre compiler.
Discuss in detail about the privileges required by
the user to create table.
————————