B.C.A (Semester III) (CBCS) Examination Nov/Dec-2018
DBMS WITH ORACLE
Time: 2½ Hours Max. Marks: 70
Instructions: All questions are compulsory.
Figures to the right indicate full marks.
Q.1 Choose and write correct answer from given alternatives:- 14
DCL stands for
Data Control Language Data Communication Language
Data Control Label Data Communication Label
Data about data is normally termed as
Data bank Metadata
Directory None of these
The number of columns associated with the table or relation is called as the

Cardinality Name
Degree Domain
Alter table command is of type.
DML DCL
DDL None of these
GRANT is a command.
DML DCL
DDL All of the above
Which of the following is an aggregate function in SQL?
Union Like
Group by Max
Rollback of transaction is normally used to
recover from transaction failure update the transaction
retrieve old records repeat a transaction
is the result of taking the union of several lower level entity sets to
produce higher level entity set.
Generalization Specialization
Aggregation Separation
A weak entity set is represented by


10) A table is in the Normal Form if all its non key fields are fully
dependent on the whole key.
First Second
Third Fourth
11) To display the server output the command must be given at the SQL
*PLUS prompt.
set serveroutput on; set output on;
set server on; set server-output on;
Page 2 of 2
SLR-SH-13
12) is implicitly invoked by ORACLE when Insert, Delete or Update
statement is issued against the associated table.
procedure function
trigger cursor
13) command is used to cancel database privileges from users.
grant rollback
revoke commit
14) The clause allows you to form groups based on the specified
condition.
Order by Group by
Having CEIL
Q.2 Answers to the following: (Any Four) 08
Define tuple Domain.
Explain DDL in short.
What is ACID property?
Explain commit.
Syntax e.g. of create table command.
Q.2 Write notes on (Any two) 06
Explain Generalization Specification in brief.
Explain view.
Explain Delete Drop table command.
Q.3 Answer any two of the following questions 08
Explain ERD.
Explain Deadlock in brief.
Explain Exception handling in brief.
Answer the following: (Any One) 06
Explain Joins in brief.
Explain Normalization in brief.
Q.4 Answer any two of the following questions 10
Explain Aggregate functions.
What is transaction? Explain states of transaction with transaction state
diagram.
Explain trigger.
Answer the following (Any One) 04
Define primary key foreign key with e.g.
Explain package in PL/SQL.
Q.5 Answer any two of the following questions 14
What is DBMS? Explain the advantages of DBMS.
Explain CODD's rules in brief.
Write a PL SQL block to print table of a given no.
(e.g. If I/P is 2 then output is 2