M.B.A. (SM) RELATIONAL DATABASE MANAGEMENT SYSTEMS

[monishav]

M.B.A. (SM) DEGREE EXAMINATION, MAY 2018.
Fourth Semester

RELATIONAL DATABASE MANAGEMENT SYSTEMS

(2013-14 Academic Year and 2014 Calendar Year Onwards)
Time : Three hours Maximum : 100 marks

SECTION A — (5 x 8 = 40 marks)
Answer any FIVE questions.

1. Discuss briefly the basic features of a database management system.

2. Explain about manipulative capabilities in database management system.

3. Write in brief about navigation efficiency in relational database management system.

4. How do you handle null values? Explain with an example.

5. Explain briefly about Client/Server System.

6. What are sub queries and multiple part queries in Oracle?

7. Explain with examples about data access using SQL commands.

8. Discuss the languages supported by Oracle Pre-compiler.

SECTION B — (4 × 15 = 60 marks)
Answer any FOUR questions.

9. Discuss in detail about the user interfaces in a DBMS.

10. Explain in detail about data definition and data control facilities.

11. Explain in detail about relational model for database management.

12. Discuss in detail about the logical structure of Oracle database.

13. Discuss on basic SQL queries using expressions with your own examples.

14. What is Embedded SQL? Discuss the same with an example.

15. Discuss the privileges required during table related operations.

                                                             ——————