C-09-CM306
3232
BOARD DIPLOMA EXAMINATION, (C-09)
OCT/NOV-2012
DCME-THIRD SEMESTER EXAMINATION
RDBMS
Time: 3 hours] [Total
Marks:80
PART-A
Instructions: (1)
Answer all questions
(2) Each question
carries three marks.
(3) Answers should be
brief and straight to the point and shall not exceed five simple sentences.
1. Define
an instance and a schema.
2. Define
Database Management System (DBMS).
3. What
is a weak entity? Give an example.
4. What
are the parts of objects?
5. What
is the difference between char and varchar2?
6. List
the types of view.
7. Write
the syntax of the command for creation of a table and explain with an example.
8. What
are P//SQL tables?
9. Hwat
are the advantages of subprogram?
10. Differentiate
between subprogram and stored subprogram.
PART-B
Instructions: (1) Answer any five questions.
(2) Each question carries ten marks.
(3) Answers should be
comprehensive and the criteria for valuation is the content but not the length
of the answer
11. Explain
BCNF with an example.
12. Explain
generalization, specialization and aggregation with examples.
13. Explain
different types of join.
14. List
and explain the integrity constraints with examples.
15. Explain
explicit cursor along with its attributes with example.
16. (a)
define an exception. Give example. (b) Consider the following block of PL/SQL
code: DECLARE
A EXCEPTION;
B EXCEPTION;
BEGIN
RAISE A;
EXCEPTION
WHEN A THEN
RAISE B;
WHEN B THEN
…
END;
Explain the propagation of
exception in the above block of code.
17. Explain
,with flowchart, how the compiler resolves a particular overloaded subprogram.
18. (a)
give the syntax for UPDATE command and explain with an example. (b) How do you
manage the space usage of database tables?
PART-A
(2) Each question carries three marks.
1. Define
an instance and a schema.
Ans:
Instance: the actual content of the data base at a
particular point in time is called an instance. It is analogous to the value of
a variable.
Schema: the logical structure of the database is
called as schema.
Example: the database consists of information about a
set of customers and accounts and the relationships between them. It is
analogous to type information of a variable in a program. A schema is owned by
a database user and has the same name as that of the user. Each user owns a
single schema. Schema objects can be created and manipulated with SQL.
Depending on the levels of abstraction, schema are of three types- physical
schema, logical-schema and sub schema.
2. Define Database Management System (DBMS).
Database management system is a collection of interrelated data
and a set of programs to access the data. It provides an environment to the
user that is both convenient and efficient to use . dbms contains information about
a particular enterprise.
3. What is a weak entity? Give an example.
An entity set that does not have a primary key is referred to as
a weak entity set. The primary key of a weak entity set is formed by taking the
primary key of the strong entity set on which it is existence dependent and its
discriminator. A weak entity set is depicted by double rectangles. The discriminator
of a weak entity set is underlined with a dashed line.
For example.
4. What are the parts of objects?
A schema object is a collection of logical structures of data. A
schema object is owned by a database user and has the same name as that user. Some
schema objects are made up of parts that a user can or must name, such as the
columns in a table or view. Index and table partitions
5. What is the difference between char and
varchar2?
6. List the types of view.
7. Write the syntax of the command for creation
of a table and explain with an example.
8. What are P//SQL tables?
9. Hwat are the advantages of subprogram?
10. Differentiate between subprogram and stored
subprogram.
PART-B
Instructions: (1)
Answer any five questions.
(2) Each question
carries ten marks.
(3) Answers should be
comprehensive and the criteria for valuation is the content but not the length
of the answer
11. Explain BCNF with an example.
12. Explain generalization, specialization and
aggregation with examples.
13. Explain different types of join.
14. List and explain the integrity constraints
with examples.
15. Explain explicit cursor along with its
attributes with example.
16. (a) define an exception. Give example. (b)
Consider the following block of PL/SQL
code:
DECLARE
A EXCEPTION;
B EXCEPTION;
BEGIN
RAISE A;
EXCEPTION
WHEN A THEN
RAISE B;
WHEN B THEN
…
END;
Explain the
propagation of exception in the above block of code.
17. Explain ,with flowchart, how the compiler
resolves a particular overloaded subprogram.
18. (a) give the syntax for UPDATE command and
explain with 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)
- APRIL /MAY-2012(C-09)
- APRIL/MAY-2012(C-05)
- OCT /NOV-2011(C-05)
OTHER SUBJECT PREVIOUS QUESTION PAPERS
