B.C.A. (Semester IV) (CGPA) Examination Nov/Dec-2018
RDBMS WITH ORACLE
Time: 2½ Hours Max. Marks: 70
Instructions: Q.1 and Q.7 are compulsory.
Attempt any two questions from Q.2 to Q.4.
Attempt any one question from Q.5 and Q.6.
Q.1 Choose the correct alternatives: 14
Which of the following is an invalid attribute of an explicit cursor?
found %notfound.
%open %rowcount
A column defined as a primary key can have a NULL.
True False
It is possible to modify a datatype of a column when column contains a data.
true False
Which SQL statement is used to Modify data in a table?
select update
modify save
A procedure stored in the database
In compiled form As source code
Both a and b None of these
Delete index command is used to remove an index from the database.
True False
Which SQL statement is used to select all records from a table named
"Student" where the value of the column "FirstName" starts with
select from student where FirstName='S';
select from student where
select from student where FirstName like
select from student where FirstName like
is date function in SQL.
date system date
datetime sysdate
Which of the following is the concatenation operator?


10) Which of the following is not a DML statement?
insert update
delete create
11) Secondary key to represent relationship between tables.
True False
12) Which of the following provides a way to select multiple rows of data from the
database and then process each row individually?
Triggers Sequences
Cursors Process
Page 2 of 2
SLR-CH-2
13) An order by clause can be used in a sub-query.
True False
14) Which of the following is advantage of view?
To hide complexity of a query
To hide complexity of a calculations
To protect the data from other users
All of these
Q.2 What is a DDL statement? Explain in detail. 05
Define foreign key and give its advantages. 05
What is the use of Aggregate functions in Oracle? Give one example. 04
Q.3 What are sequences? Why it is used? Create a sequence. 05
What is view? Give the syntax for creating a view. 05
What do you mean by GROUP BY Clause? Give suitable example. 04
Q.4 Explain with example concept of trigger. 05
Give the syntax and example. 05
Delete alter
What is the difference between drop and truncate? Give its syntax. 04
Q.5 Describe the concept of PL /SQL function. 07
Write a cursor to display all books having price more than 500 in ascending
order of price.
07
Q.6 Write a package specification and body which contains following. 07
Procedure which accept a number and the calculate factorial of given
number.
A function which accept a number and return if it is odd or even.
List and explain various constraints used in Oracle. 07
Q.7 Write short note on 14
Parameterized cursor
Advantages of packages
Relation and attribute
Structure of PL/SQL