Questions Search

This website covers previous years question papers of various universities and colleges in India. Moreover, the information on admission to various courses from various universities/institutes/colleges are also available. Also the latest teaching faculty plus teachers jobs, Government jobs, Banking Jobs, and other jobs are regularly updated to help jobless candidates. Admit cards of various recruitment of Govt organisation are updated. Search your terms using the search box provided.

Follow by Email

Monday, January 4, 2016

DATABASE MANAGEMENT SYSTEM,2011 Question Paper, NCP,Madras University Question Paper

Madras University Question Paper
Subject Code : NCP
OCTOBER 2011 U/ID 14677/NCP
Time : Three hours Maximum : 100 marks
PART A — (5 × 8 = 40 marks)
Answer any FIVE questions.
All questions carry equal marks.
1. Briefly explain the data base components.
2. Explain the formal query languages with example.
3. Explain the basic structure of relational database
with example.
 4. Explain the declaration and usages of the PL/SQL
data types with example.
 5. Explain the advanced data management
commands and SQL functions.
6. Briefly describe the mapping constraints in
database system.
7. Explain how to create the multiple form
applications using developer 2000.
8. Briefly explain the canvases and views.
 Canvases ©ØÖ® viewsø¯ _¸UP©õP ÂÍUSP.
PART B — (3 × 20 = 60 marks)
Answer any THREE questions.
All questions carry equal marks.
9. Explain the components of E-R model and scheme
diagram in detail with example.
10. Explain any four basic relational-algebra
operations with example.
11. Explain the following :
 (a) Boyce-Codd Normal Form (BCNF) (10)
 (b) Normalization using multivalued
dependencies. (10)
12. Discuss the PL/SQL procedures and exception
handling with example.
13. Explain the following :
 (a) List boxes and Dialog boxes (10)
 (b) Event and triggers. (10)

No comments:

Post a Comment

Pen down your valuable important comments below