« MCA Papers : NIMCET Test for admission in MCA programme | Home | MCA Papers : Computer Engineering »
MCA Papers : MCA RDBMS Question paper of Alagappa University
By Contributor | September 5, 2008
M.C.A. (S) DEGREE EXAMINATION, MAY 2008.
Third Semester
RDBMS
(2005 onwards)
Time : Three hours Maximum : 100 marks
Answer any FIVE questions.
All questions carry equal marks.
(5 × 20 = 100)
1. (a) What are the pitfalls of DBMS? Explain.
(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 FOUR DCL commands with example.
(b) Explain with the example how you will select 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 different user interfaces of DBMS.
(b) Explain any FIVE 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.
Topics: MCA Question Papers, mcapapers |
Recent Posts
- MCA Papers : Career in Computer Programming
- Admission Schedule of MCA Course of Delhi University for 2009-10
- MCA Papers : Online Computer Training
- MCA Papers : Career In Computer Graphic Design
- MCA Papers : Computer Engineering
- MCA Papers : MCA RDBMS Question paper of Alagappa University
- MCA Papers : NIMCET Test for admission in MCA programme
- MCA Papers : Online computer education on the rise
- Syllabus of MCA Entrance Test for JNU and Delhi University
- MCA Papers : Careers With a Computer Degree