BOARD DIPLOMA EXAMINATION, (C-09)
DCM-III YEAR EXAMINATION
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?
- OCTOER/NOVEMBER 2011(C-09)
WHEN A THEN
WHEN B THEN
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.