P.G.D.C.A. (Semester II) (CBCS) Examination Mar/Apr-2018
DBMS AND RDBMS USING ORACLE
Time: 2½ Hours
Max. Marks: 70
Instructions: All questions are compulsory. Figures to the right indicate full marks.
Q.1
Choose the correct alternative:
14
A in a table represents a relationship among a set of values.
Column
Key
Row
Entry
The term attribute refers to a of a table.
record
column
tuple
key
The term is used to refer to a row.
attribute
tuple
field
instance
Which of the following is not an integrity constraint?
Not Null
Positive
Unique
Check
Foreign key is the one in which the of one relation is referenced in another relation.
foreign key
primary key
references
check constraint
Aggregate functions are the functions that take a as input and return a single value.
collection of values
single value
aggregate value
none of these
All the aggregate functions except ignore null values in their input collection.
Count(attribute)

avg(
Sum(
In the normal form, a composite attribute is converted to individual attributes.
first
second
third
fourth
CREATE TABLE EMPLOYE(NAME VARCHAR2(10), ID What type statement is this?
DML
DCL
View
DDL
10) Which of the following performs pattern matching?
BETWEEN
LIKE
EXISTS
None of these
Page 2 of 2
SLR-CR-6
11) In SQL, which of the following is not a data definition language command?
Rename
Revoke
Grant
Update
12) Which of the following SQL commands is used to retrieve table data?
Delete
Insert
Select
Join
13) increases database security.
Trigger
Cursor
Join
Sub query
14) GRANT is not assign privileges to a user.
True
False
Q.2

What is oracle? Explain historical development of oracle.
07

Explain DDL, DML and DCL.
07
Q.3

What is sub query? Explain nested sun query.
07

Write a PL/SQL code block to print the multiplication table of a given number.
07
Q.4
Solve any one from the following.
14

Explain different control statement in PL/SQL.

What is Cursor? Explain types of cursor.
Q.5
Solve any one from the following.
14

What is trigger? What are the types of trigger? Explain with syntax and suitable example.

Discuss on 'Normalization.'