C05-CM-503
632
BOARD
DIPLOMA EXAMINATION, (C-05)
APRIL/MAY-2012
DCME
V SEMESTER EXAMINATION
RELATIONAL
DATABASE MANAGEMENT SYSTEMS
Time
: 3
Hours]
[Total Marks: 100
PART-A 10*4=40
Instructions: (1) Answer
all questions and each question caries four marks. (2) Answers should be brief
and straight to t the point and shall not exceed five simple sentences.
1. Define entity and
relationshsip.
2. Define DDL and DML
3. What are the differences
between char and varchar2 datatypes?
4. What are conversion
functions?
5. What is the process of
creating a table?
6. Difference between view
and table.
7. List any four built in
functions of PL/SQL.
8. List any four predefined
PL/SQL exceptions
9. What are the benefits of
overloading?
10. Explain briefly about
stored sub program..
PART-B 5*12=60
Instructions: (1) Answer
any five questions and each question caries twelve marks. (2) The Answers
should be comprehensive and criteria for valuation is the Content but not the
length of the answer.
11. Explain various mapping
cardinalities.
12. (a) explain how will you
convert E-R diagram into table (b) classify the database users into various
types.
13. Explain any 12 functions
of SQL.
14. (a) explain about DML
statements. (b) explain the process of creating (i) synonym (ii) index.
15. Explain the following
commands commit, rollback and save point
16. Explain the architecture
of PL/SQL.
17. Explain recursion with
the help of an example.
18. (a) explain overloading
in PL/SQL with an example. (b) what is a package? Write its advantages.
- OCTOBER/NOVEMBER-2010(C-05)
- OCTOBER/NOVEMBER-2010(C-09)
- APRIL/MAY-2011(C-05)
- OCTOER/NOVEMBER 2011(C-09)
- APRIL /MAY-2012(C-09)
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