P.G.D.C.A. (Semester II) (CBCS) Examination, 2017
DBMS RDBMS USING ORACLE
Day Date: Thursday, 04-05-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
The overall description of the database is known is
Instance Schema Snapshot None of these
PL/SQL is a language.
Programming Procedural Natural All of the above
The table with columns and rows is called.
Table Relation Key None of these
An attribute of one table is matching the primary key of another table is
called as.
Foreign key Secondary key
Primary key Candidate key
DCL stands for
Data Control Language Data Communication Language
Data Choice Language None of these
A buffer use to store results of the recent query.
Cursor Triggers Package Exceptions
is DML command.
INSERT INDEX EDIT CUT
OBDC stands for
Open DataBase Connectivity Open Data connection
Online Data Connection None of these above
is a special type of command.
Edit Query Delete Select
10) is a variable length datatype.
Char Varchar2 both a and b None of these
Page 1 of 2
SLR-T 10
11) To sort records we use
ORDER BY clause HAVING clause
GROUP clause None of these
12) LENGTH is type of function.
Numeric String Conversion Both a b
13) DBA stands for
Database Administrator Database Authority
Database Access None of these
14) A column of a relation is called as a
Domain Attribute Relation None of these
Q.2 Explain the advantages disadvantage of DBMS. 07
Explain the Codd's Rules. 07
Q.3 Write a PL/SQL code to print Sum of the digit from 1 to 10 number 07
Explain any DDL, DML DCL command with syntax and example. 07
Q.4 What is SQL Operator? Explain the types of Operator? 14
OR
What is mean by Normalization? Explain the type of Normalization.
Q.5 What is mean is Trigger? Explain types of Trigger in detail. 14
OR
What is Cursor? Explain the concept Types of Cursors?