DISTANCE EDUCATION
M.B.A. DEGREE EXAMINATION, DECEMBER 2017.
Fourth Semester
RELATIONAL DATABASE MANAGEMENT SYSTEMS
(2013-2014 Academic Year and 2014 Calendar Year Onwards)
Time Three hours Maximum 100 marks
SECTION A — x 8 40 marks)
Answer any FIVE questions.
1. What are the advantages of a Database management
system?
2. Write brief notes on Schema in DBMS.
3. Write in brief about semantic issues in Relational
database management system.
4. Explain in detail about Data Definition facilities.
5. Write a brief note on oracle client server system.
6. Explain how to handle numerical expressions in SQL.
7. Write about DML commands in SQL with your own
examples.
8. Write short notes on Embedded SQL.
Sub. Code
43
DE-3359
2
SP 5
SECTION B — × 15 60 marks)
Answer any FOUR questions.
9. Discuss in detail the characteristics of data in a database.
10. Explain about Data Manipulation facilities and Data
control facilities.
11. With a neat diagram explain the architecture of Oracle
Database.
12. Write short notes on following
Using sub queries.
Working with NULL and NOT NULL values.
13. Discuss the purpose of Network System Tables in Oracle.
14. Explain various table related operations with an example
for each.
15. Discuss in detail about database objects and indexes.