Thursday 22 November 2012

APRIL/MAY-2012(C-05)


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.

&� 5 ; / �>� �� n style='font-size:7.0pt;mso-bidi-font-size:11.0pt;font-family:"'Times New Roman'","serif"; mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial; color:black'> 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