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?
- OCTOBER/NOVEMBER-2010(C-05)
- OCTOBER/NOVEMBER-2010(C-09)
- APRIL/MAY-2011(C-05)
- OCTOER/NOVEMBER 2011(C-09)
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.
No comments:
Post a Comment