B.C.A. (Semester III) (CGPA) Examination Oct/Nov-2017
DATABASE MANAGEMENT SYSTEM
Day Date: Tuesday, 14-11-2017 Max. Marks: 70
Time: 02:30 PM to 05:00 PM
Instructions: Q.1 and Q.7 are compulsory.
Attempt any two questions from Q. 3 and 4.
Attempt any one question from Q. 5 and 6.
All questions carry equal marks.
Q.1 Choose correct alternatives. 14
The process of managing simultaneous operations on the database without
having them interfere with one another is
Serializability Recoverability
Concurrency control Transaction management
A transaction completes its execution is said to be
Committed Aborted
Rolled back Failed
Which protocol ensures conflict Serializability?
Value based protocol Read based protocol
Timestamp based protocol Validation based protocol
A functional dependency between two or more non key attributes is called a

Partial functional dependency Partial nonkey dependency
Transitive dependency Non transitive dependency
DBMS periodically suspends all processing and synchronizes its files and
journals through the use of
Checkpoint facility Backup facility
Recovery manager Database change log
Disks and tapes are the example of
Volatile storage Non-volatile_storage
Stable storage None of above
Which Model describes entities, relationship and attributes?
E R Model Functional
Relational Network
Student address attribute is an example of derived attribute.
True False
A primary key is an attributes that uniquely identifies each row in a relation
True false
10) The file organization which allows us to read records that would satisfy the
join condition by using one block read is
Heap file Sequential file
Clustering file Hash file
Page 2 of 2
SLR-CD-8
11) An entity type whose existence depends on another entity type is called a
entity.
Strong Weak
Codependent Variant
12) Which of the following Relational Algebra operations require that both tables
involved have the exact same attributes?
Join, Projection, Restriction
Multiplication and Division
Union, Intersection, Difference
Difference, Multiplication, Intersection
13) Making a change to the conceptual schema of a database but not affecting
the existing external schemas is an example of
Physical data independence Concurrency Control
Logical data independence Functional dependency
14) The three level architectures are defines user view of the database.
The defines the physical view of the database. The
defines the logical schema of the database.
Which of the following set is suitable to fill the blanks in the above paragraph?
Conceptual Level ii) External Level iii) Internal Level
Conceptual Level ii) Internal Level iii) External Level
External Level ii) Conceptual Level iii) Internal Level
External Level ii) Internal Level iii) Conceptual Level
Q.2 What is transaction? Explain ACID property of transaction. 05
Define the following terms 05
Select
Projection
Union
Intersection
What is indexing? What are its advantages and disadvantages of indexed
files?
04
Q.3 Explain log based recovery. 05
What is DBMS? Explain Query processor of database system. 05
Write a note on shadow paging. 04
Q.4 Define the following terms 05
Schema
Domain
Cardinality
Shared lock
How many ways of recovery from concurrent transaction? Explain 05
Define Generalization and Specialization. 04
Q.5 Define Attribute. Explain the various types of attribute with example. 07
What is Functional Dependency? Explain different types of dependency 07
Q.6 What is Schedule? Explain any three types of schedules. 07
What is Normalization? Explain different normal forms with suitable example. 07
Q.7 Explain following terms in details (any two) 14
Types of Outer join
Role of DBA
Differentiate Network model and Hierarchical Model