P.G.D.C.A. (Semester II) Examination Oct/Nov-2017
DBMS AND RDBMS USING ORACLE
Day Date: Saturday, 25-11-2017 Max. Marks: 80
Time: 02.30 PM to 05.30 PM
Instructions: Q.1. and Q.7 are compulsory.
Attempt any two questions from Q. No. 2.3 and 4.
Attempt any one question from Q.No.5 and 6.
Figures to the right indicate full marks.
Q.1 Choose the correct alternative: 12
is a valid RDBMS.
Oracle MS-Excel
MS-Word None of these
data constraint is used to accept only unique and NULL
values in a table column.
Primary Key Unique
Foreign Key None of these
is the component of SQL statement that manipulates the data
available in a table.
DDL DML
DCL All of these
PL/SQL not supports iteration.
True False
works as assignment operator in PL/SQL

None of these
When one query contains another query that is known as
Multiple query Query into query
Sub query None of these
Valid attribute(s) of explicit cursor is/are
%ISOPEN %FOUND
%ROWCOUNT All of these
Triggers decrease database security.
True False
is unconditional control structure available in PL/SQL.
GOTO FOR
IF.. THEN..ELSE ...ENDIF WHILE
10) is used to assign privileges to another user.
Resource Grant
Revoke None of these
Page 2 of 2
SLR-CF-9
11) In PL/SQL, is used to apply table column data type size to a
memory variable.
%TYPE %ROWTYPE
%APPLY None of these
12) ORDER BY clause is used to display data in sorted order.
True False
Fill in the blanks. 04
HAVING clause is used with only clause.
DBA stands for
In SQL, function is used to find square root of a number.
In SQL, data type is used to store date and time.
Q.2 What is SQL? Differentiate between SQL and PL/SQL. 06
What are the integrity constraints? Explain Primary Key. 06
Write a PL/SQL code to check the largest number between two numbers. 04
Q.3 Explain any three arithmetic functions in oracle. 06
What is sub query? Explain with syntax and example. 06
Write a PL/SQL code to check the given number is even or odd. 04
Q.4 Write Short Notes on the following. 16
Functional Dependencies.
SQL Operators.
Iterative Controls.
Privileges.
Q.5 What is cursor? Explain types of cursor. 08
Write a PL/SQL code to print the factorial of given numbers. 08
Q.6 Write on "Normalization. 08
Explain Codd's Rules. 08
Q.7 What is trigger? Explain with suitable example. 08
Explain all forms of SELECT command with syntax and example. 08