P.G.D.C.A. (Semester II) (CBCS) Examination Oct/Nov-2017
DBMS AND RDBMS USING ORACLE
Day Date: Saturday, 25-11-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions: All questions are compulsory.
Figures to the right indicate full marks.
Q.1 Choose the correct alternative: 14
Which of the following is not DBMS or RDBMS?
Oracle MS-Access
MySQL None of these
is valid data type in SQL.
String Integer
Number None of these
SQL statements starts
Verb Clause
Delimiter None of these
Primary key constraint allows NULL values in a table column for which it is
applied.
True False
wild cards are used with LIKE predicate.
and and
and? and
Which of the following not valid string function?
Upper() Substr()
Lower()
PL/SQL Code block ends with keyword.
Stop Exit
End None of these
FETCH is used in implicit cursor.
True False
is an iterative statement in PL/SQL.
GOTO IF….THEN
FOR None of these
10) increases database security
Cursor Trigger
Function None of these
11) There are two types of
Internal, External Single, Multiple
Entry Control, Exit Control Implicit, Explicit
Page 2 of 2
SLR-CF-6
12) Oralce version 7.0 supports PL/SQL.
True False
13) Valid DCL command is
ALTER TABLE GRANT
SELECT DELETE
14) When one sub query contains sub query that is known as
Nested sub query Sub query
Multiple queries None of these
Q.2 Explain Dr. E.F. Codde's rules. 07
Explain "Normalization" 07
Q.3 Explain primary key and foreign key constraints. 07
Explain any four arithmetic functions. 07
Q.4 Solve any one from the following. 14
What is cursor? What are the types of cursor? Explain in detail.
Write a PL/SQL code to-
Print the given number is prime or not.
Print the factorial of a given number.
Q.5 Solve any one from the following. 14
What is PL/SQL? Which control statements are available in PL/SQL?
Explain.
Explain in detail "Triggers".