B.C.A. (Semester III) (CBCS) Examination Oct/Nov-2017
DBMS WITH ORACLE
Day Date: Tuesday, 14-11-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 alternatives: 14
A transaction completes its execution is said to be
Aborted Loaded
Rolled Committed
used to input the entry and give the result in a variable in a
procedure.
Put and Get Get and Put
Out and In In and Out
The allows a general predicate over the relations being
joined.
ON Using
Set Where
The operation which is not considered a basic operation of relational algebra
is
Join Selection
Union Cross Product
is an additional filter that is applied to the result.
Select Group by
Having Order by
Which one of the following attribute can be taken as a primary key?
Name Street
ID Department
Update table statement is
DML DDL
DCL None of the above
To delete particular column in a relation the command used is
Update Table Truncate Column
Alter, Drop Delete Column
The unit of storage that can store one or more records in a hash file
organization are
Buckets Disk pages
Blocks Nodes
10) The Deadlock state can be changed back to stable state by using

Commit Rollback
Savepoint Deadlock
Page 2 of 2
SLR-SD-13
11) Tape storage is referred to as
Random-access Direct-access
Sequential-access All of the mentioned
12) Which of the following causes system to crash?
Bug in software Loss of volatile data
Hardware malfunction All of the mentioned.
13) Which prefixes are available to oracle triggers?
new only old only
Both new and old Neither new nor old
14) The is used to list the attributes desired in the result of a
query.
Where Select
Form Distinct
Q.2 Answer any seven from the following 14
What is attribute explain any two types?
What is tuple with example?
What is Trigger?
Explain any two relational algebraic operations?
What is view? Write its syntax?
What is the sub-query? Write its syntax?
Explain Order by Clause with syntax and example?
Write down any 4 String function in sql?
What is deadlock?
Q.3 Attempt any two of the followings:
What is DBMS? Explain advantages and disadvantages of DBMS?
Explain E.F.Codd rules in detail?
What is Index? Explain it with syntax and example.
10
Explain Structure of PL/SQL with suitable example. 04
Q.4 Attempt any two of the followings: 14
What is Transaction? Explain ACID properties of transaction?
Write DDL commands with proper syntax and example?
What is cursor? Explain cursor attributes with suitable example?
Q.5 Attempt any two of the followings: 14
What is procedure? Explain parameters of procedures with suitable program?
Write a note on exception handling in PL/SQL with proper syntax and suitable
example?
What is Join? Explain types of outer joins in detail with syntax and example?