P.G.D.C.A. (Semester II) (CBCS) Examination Oct/Nov-2018
DBMS AND RDBMS USING ORACLE
Time: 2½ Hours Max. Marks: 70
Instructions: Q.No.1 and Q.No.7 are compulsory.
Attempt any two questions from Q.2, and 4.
Attempt any one question between QNo.5 and Q.No.6.
Figures to the right indicate full marks.
Q.1 Choose the single correct alternative: 07
Which is one of the RDBMS application software
Ms-Word MS-Access
Tally Ms-Power point
is a data type in Oracle.
Numeric Varchar 2
Both a and b None of these
The processed data is called
Raw fact and figures Metadata
Information None of these
Special type of command is called
Query Object
Database Authority None of these
SQL stands for
Simple Query language Structured Query Language
Sample Query Language None of these
A column of a relation is called as a
Domain Attribute
Relation None of these
To find conditional record which command is used.
ORDER BY clause WHERE clause
GROUP clause None of these
Answer one sentence 07
What is mean by Relation?
What is mean by constraints?
What is mean by Field?
Define function?
RDBMS stands for
Write down two SQL commands.
Long form of PL/SQL.
What is mean by Statement?
Q.2 What is DBMS? What are the advantages of DBMS? 05
Write down 5 SQL command with example. 05
Write short note Operator. 04
Q.3 Explain five functions of SQL with example. 05
Explain the different data types in Oracle. 05
Different between DBMS and RDBMS. 04
Page 2 of 2
SLR-CG-6
Q.4 Explain WHILE loop in PL/SQL with suitable example. 05
Explain the different roles of Data base Administrator. 05
Write down two Query 04
Create table employee Ename, Bdate, Salary)
To add into employee table 2 records.
Q.5 Explain the basic components DBMS. 07
What is mean by Cursor? Explain the types of Cursor. 07
Q.6 Explain the Historical development of Oracle. 07
Write down PI/SQL code to find largest three numbers. 07
Q.7 Write a short note on (any 14
SQL Clause
Types of Key
Concept of DBMS
Triggers
Codd's Rule