B.C.A. (Semester III) (CGPA) Examination Mar/Apr-2018
DATABASE MANAGEMENT SYSTEM
Time: 2½ Hours
Max. Marks: 70
Instructions: Q.1 and Q.7 are compulsory. Attempt any two questions from Q.2 to Q.4. Attempt any one question from Q.5 and Q.6.
Q.1
Choose the correct alternatives:
14
In the rational model, cardinality is termed as
Number of tuples
Number of attributes
Number of tables
Number of constraints.
Cartesian product in relational algebra is
A Unary operator
A Binary operator
A Ternary operator
None of these
An entity set that does not have sufficient attributes to form a primary key is a
Strong entity set
Weak entity set
Simple entity set
Primary entity set
is used to represent the relationship between tables.
Primary key
Foreign Key
Check Key
Child Key
The advantage of DBMS is
Data independence
Centralized control of data
To avoid the data redundancy
All of these
is an example of sophisticated user.
Programmer
DBA
System Analyst
Web user
The full form of DDL is Dynamic Data Language.
True
False
Which of the following is not record data model?
Relational model
Network model
ER model
Hierarchical model
The advantage of view is to provide the data security.
True
False
10) Which database level is closest to the users?
External
Internal
Physical
Conceptual
11) What is ACID properties of Transaction?
Atomicity, Consistency, Isolation, Database
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistency, Inconsistency, Durability
Automatically, Concurrency, Isolation, Durability
Page 2 of 2
SLR-CV-3
12) Database locking concept is used to solve the problem of
Lost Update
Uncommitted Dependency
Inconsistent Data
All of these
13) The transaction wants to edit the data item is called as
Exclusive Mode
Shared Mode
Inclusive Mode
Unshared Mode
14) 2NF is based on the concept of
Semi functional dependency
Fully functional dependency
Transitive dependency
Multi valued dependency
Q.2
What is database? Explain architecture of DBMS.
05
What is concurrency control? Explain two phase locking protocol.
05
Explain referential integrity with suitable example.
04
Q.3
Explain the storage manager of DBMS.
05
What is deadlock? Explain the concept of deadlock.
05
Write note on Database Language.
04
Q.4
What is indexing? Explain sparse index with suitable example.
05
Explain different types of keys.
05
Write note on DBA.
04
Q.5
Describe the following relational algebra operations with example. Project ii) Select iii) Cartesian product
07
Discuss the concept conflict serializability.
07
Q.6
What is data model? Explain network and hierarchical model with example.
07
What is normalization? Explain 1st and 2nd normal form with example.
07
Q.7
Write a short notes (Any
14
Generalization Specialization
3 tier architecture it's advantages
Log based protocol