B.C.A. (Semester III) (CGPA) Examination, 2017
DATABASE MANAGEMENT SYSTEM
Day Date: Monday, 17-04-2017 Max. Marks: 70
Time: 02:30 PM to 05:00 PM
N.B. 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.
Q.1 Choose correct alternatives: 07
The level of data abstraction which describes how the data is
actually stored is
physical level conceptual level
storage level view level
The overall design of a database is called
Schema of the database Structure of the database
The screen of the database View of the database
Which of the following is not a proper state of transaction?
partially aborted partially committed
aborted committed
Rollback of transaction is normally used to
recover from transaction failure
update the transaction
retrieve old records
repeat a transaction
A view of database that appears to an application program is
known as
report structure
subschema schema
is an example of entity.
Student name Student
Student address Roll number
The advantage of normalization is
to avoid redundancy increase flexibility
Both a and b None of these
Page 1 of 2
SLR-U 13
Q.1 State whether True or False: 04
A relationship is an association among several entities.
A candidate key can be a subset of a super key.
A weak entity set has a primary key.
Aggregation operation is used to construct complex entities.
Q.1 Fill in the blanks: 03
The language used for data modification is known as
The primary key index does not allow data in a field.
The rule of 3NF is
Q.2 Write answer of the following questions (Any 14
State and explain different transaction properties.
What is data model? Explain the record based data model.
What is DBMS? Explain purpose of DBMS with suitable example.
Q.3 Write answer of the following questions (Any 14
Describe briefly Relational Algebra. Explain any two relational
algebra operators with example.
What is normalization? Explain 2NF with suitable example.
Explain specialization and aggregation in details.
Q.4 Write answer of the following questions (Any 14
Explain in detail deadlocks.
What is indexing? Explain various methods of indexing.
Explain timestamp based protocol.
Q.5 Explain architecture of DBMS. 07
Explain the different notations used in ER-diagram. 07
Q.6 Explain two-tier and three-tier architecture. 07
Write a short note on log based recovery method. 07
Q.7 Write short notes on (Any 14
Shadow paging
Schemas and instances
Serializability