Thursday 22 November 2012

APRIL /MAY-2012(C-09)


C-09-CM-105/C09-IT-105
3232
BOARD DIPLOMA EXAMINATION, (C-09)
APRIL /MAY-2012
DCM-III YEAR EXAMINATION
RDBMS

TIME: 3 Hours]                                                                     [Total Marks :80]
PART   - A
INSTRUCTION:  (1) ANSWER ALL QUESTION AND EACH QUESTION
                                           CARRIES FOUR MARKS
                    (2)  ANSWER SHOULD BE BRIEF AND   STRAIGHT      TO  THE POINT AND SHALL NOT EXEED FIVE SIMPLE SENTENCES

1.     Define primary key. Give example.
2.     What is the difference between a 2NF and a 3NF relation?
3.     Construct an E-R diagram for the statement “Driver drives a car”.
4.     List different types of literals.
5.     Give the syntax for UPDATE command.
6.     What is an integrity constraint?
7.     Explain about dropping a table, with example.
8.     How to declare global variables?
9.     How many types of exceptions are there?
10.  What are the benefits of overloading?


Instructions :    (1) Answer any five questions and each question carries ten marks.
                  (2) The answers should be comprehensive and the criteria for valuation   is the content but not the length of the answer.

11.  describe the overall database system structure with block diagram.
12.  Explain various data models.
13.  Explain the process of accessing objects in remote database.
14.  Explain the creation of view from multiple tables with examples.
15.  (a) draw the block diagram of PL/SQL engine. (b) what are the differences between SQL and PL/SQL?
16.         List and explain the four steps involved in managing explicit cursors with example.
17.  Write the syntax for package body. Explain with example.
18.  (a) what is an outer-join? Give an example. (b) how do you manage the space usage of database tables?

1ptP � e h �>� �� 8.0pt'>                   EXCEPTION
                             WHEN A THEN
                                      RAISE B;
                             WHEN B THEN
                   END;
Explain the propagation of exception in the abouve block of code.
16.  (a) draw the block diagram of PL/SQL engine. (b) what are the differences between SQL and PL/SQL ?
17.  (a) how to create a stored subprogram? Explain with example. (b) explain how to call stored subprogram using Oracle objects.
18. (a) explain different categories of SQL data types. (b) List any two integrity constraints. State the reasons for enforcing each of these constraints.



OTHER SUBJECT PREVIOUS QUESTION PAPERS

No comments:

Post a Comment