DISTANCE EDUCATION
MASTER OF COMPUTER APPLICATION DEGREE
EXAMINATION, DECEMBER 2017.
First Semester
RELATIONAL DATABASE MANAGEMENT SYSTEMS
(2010 Academic year onwards)
Time Three hours Maximum 100 marks
PART A — X 8 40 marks)
Answer any FIVE questions.
1. What are the different user interfaces? Discuss.
2. Specify the manipulative capabilities of the DBMS.
3. Briefly discuss the mapping operation of relational model.
4. Describe the navigation and efficiency of relational
model.
5. What are the relational database's properties? Explain.
6. Write about the client/server systems.
7. Mention the data access SQL commands.
8. What are the embedded SQL statements available?
Describe.
Sub. Code
103
DE- 2985
2
wk 3
PART B — X 15 60 marks)
Answer any FOUR questions.
9. Explain the database management system in detail with
neat diagram.
10. Discuss the data control and data definition facilities.
11. Give an overview of oracle database architecture with
neat diagram.
12. Discuss the basic queries and sub queries with suitable
examples.
13. Write the queries to perform the following:
Create table
Insert row into a table
Copying another table
Rename table
Delete table.
14. Explain in detail the relational model based DBMS.
15. What are the languages supported by oracle precompiler?
Explain in detail.
————————