Amrita Vishwa Vidyapeetham 2007 M.C.A Database Management Systems - Question Paper

M.C.A. MAY 2007
Database Management Systems
Time : 3 hours Maximum : 100 marks
ans any 5 ques..
All ques. carry equal marks.
(5 × 20 = 100)
1. (a) What are the pitfalls of DBMS? discuss.
(b) Explain Subschema with an example.
2. (a) Explain the advantages of Relational Model.
(b) Explain the Data Control facilities in Relational Model.
3. (a) Explain Client Server architecture with a diagram.
(b) Write short notes on Physical files.
4. (a) Explain the 4 DCL commands with example.
(b) Explain with the example how you will choose distinct values using a query.
5. (a) Explain with example how tables are created and values are inserted.
(b) Explain the Object Oriented concept in Oracle.
6. (a) Explain various user interfaces of DBMS.
(b) Explain any 5 DML commands with example.
7. (a) Explain Network system tables with example.
(b) Write short notes on Embedded SQL.
8. (a) Create a table called EMPLOYEE with fields name, id, department, age, DOB and Basic–pay. Write queries to view.
(i) All the employees in a neat format.
(ii) Employees department wise.
(iii) Age greater than 55.
(iv) Students in a particular DOB.
(b) Explain how can you work with NULL values.

Earning:   Approval pending.