B.C.A (Semester III) (CBCS) Examination Mar/Apr-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
DBMS is a collection of that enables user to create and maintain a database.
Keys
Translators
Program
Language Activity
In a relational schema, each tuple is divided into fields called
Relations
Domains
Queries
All of the above
clause is an additional filter that is applied to the result.
Select
Group-by
Having
Order by
table store information about database or about the system.
SQL
Nested
System
None of these
DBMS helps achieve.
Data independence
Centralized control of data
Neither a nor b
Both a and b
is preferred method for enforcing data integrity.
Constraints
Storage Procedure
Triggers
Cursors
data type can store unstructured data.
RAW
CHAR
NUMERIC
VARCHAR
Which are the two ways in which entities can participate in a relationship?
Passive and active
Total and partial
Simple and Complex
All of the above
Which database level is closest to the users?
External
Internal
Physical
Conceptual
10) Which are the following are the properties of entities?
Groups
Table
Attributes
Switchboards
11) The database schema is written in
HLL
DML
DDL
DCL
12) is the process of organizing data into related tables.
Normalization
Generalization
Specialization
None of the above
Page 2 of 2
SLR-SR-14
13) A is used to define overall design of the database.
Schema
Application Program
Data Definition language
Code
14) Which of the following is not a binary operator in relational algebra?
Join
Semi-Join
Assignment
Project
Q.2
Answers to the following: [Any seven]
14
What do you mean by Entity type and Entity Set?
Define Aggregate functions. List function name.
Enlist the advantages of normalizing database.
Define database model.
What is DBMS?
What are cursors give different types of cursors?
What is a query?
Define Projection and Selection.
What is indexing and what are the different kinds of indexing?
Q.3

Answer any two of the following questions
10
Explain advantages and disadvantages of DBMS.
Explain the different attribute types with respect to E-R model.
Explain Hierarchical data model and Network data model.

Explain date function with suitable example.
04
Q.4
Answer the following. (Any
14
What is transaction? Explain ACID properties.
Define Join. Explain its type with suitable example.
Write notations used in ER-Model.
Q.5
Answer the following. (Any
14
Define Trigger, Create a trigger which allows user to perform DML operation on table only working day office hour.
Write a PL/SQL block which handles two user defined exceptions.
Explain cursor attributes with suitable example.