P.G.D.C.A. (Semester II) Examination, 2017
DBMS AND RDBMS USING ORACLE
Day Date: Thursday, 04-05-2017 Max. Marks: 80
Time: 02.30 PM to 05.30 PM
Instructions: Q. No.1 and Q. No. 7 are compulsory.
Attempt any two questions from Q.2, 3 and 4.
Attempt any one questions between Q. No. 5 and Q. No.6.
Figures to the right indicate full marks.
Q.1 Choose the single correct alternative: 08
is meaning full data.
Data Information Field Record
is a data type in Oracle.
Text Varchar2 Both a and b None of these
Data is a
Raw fact and figures Metadata
Information only None of these
DDL stands for
Data Definition Language Data Direct Language
Data Deep Language None of these
SQL stands for
Simple Query Language Structured Query Language
Simple Query Language None of these
A column a relation is called as a
Domain Attribute Relation None of these
To sort records we use
ORDER BY clause HAVING clause
GROUP clause none of these
Select, Insert are command.
DMLs DDLs VDLs DCLs
Page 1 of 2
SLR-T 13
Answer one sentence: 08
What is mean by Data?
What is mean by Flowchart?
What is mean by Query?
Define Cursor?
How many types of Operator?
Write down two SQL commands.
Long form of PL/SQL.
What is mean by Oracle?
Q.2 Explain the concept of DBMS? 06
Explain the Historical Development of Oracle. 06
Write short note on Functional Dependencies. 04
Q.3 Explain the difference between DBMS and RDBMS. 06
Explain the different data types in Oracle. 06
Write short note on features of SQL. 04
Q.4 Difference between SQL and PL/SQL with example. 06
Explain the advantages of DBMS. 06
Write short note on Arithmetic function. 04
Q.5 Explain IF-Else, FOR loop, While loop with example. 08
What is mean by Cursor? Explain the types of Cursor. 08
Q.6 What is Normalization? Explain the types of Normalization. 08
Write down Pl/SQL code to find even Odd number. 08
Q.7 Write a short note on (any 16
Codd Rule
Data models
SQL function
Triggers
GRANT, REVOKE