M.C.A.(Computer Science) (Sem-III) (CBCS) Examination, 2017
Database Management System
Day Date: Tuesday, 25-04-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions Q.1 and Q.2 are compulsory
Attempt any Three Questions from Q.3 to Q.7
Figures to the right indicate full marks.
Q.1 Choose the correct alternatives
10
In E-R diagram, derived attributes are denoted by…….
Double ellipse Dotted ellipse
Ellipse None of these
ACID stands for
Atomicity, Consistency, Isolation, Durability.
Atomicity, Consistent, Isolated, Durability.
Atomicity, Consistent, Integrated, Durability.
Atomicity, Consistent, Integration, Durability.
…….. is the initial state of the transaction
Active Partially committed
F ailed Aborted
..... is the result of taking a subset of a higher level entity set
to form a lower-level entity set.
Generalization Specializaion
Both and None of these
...... Execution of transactions guarantees that consistency is
preserved.
Concurrent Serial
Both and None of these
In the SQL cursor, which attribute is TRUE when a cursor
has some rows remained to fetch, and FALSE when a cursor
has no rows left to fetch.
%ROWCOUNT %FOUND
%NOTFOUND %ISOPEN
The variable or expression passed from a calling subprogram
are
Formal parameters Actual parameters
Both and None of the above
Page 1 of 2
........Join returns every occurrence of each table with every
occurrences of other table.
Cross Join Equi join
Self join None of the above
In a select command ……. Clause is used for getting rows
from a query in specific order.
SORT BY GROUP BY
ORDER BY HAVING
10) A database schema is specified by a set of definitions that
are expressed using a…………
DDL DML
DCL None of the above
State whether following statements are true or false: 4
Transaction operations on database perform accessing and
updating of data.
Composite key is a combination of two or more attributes
used as primary key.
SQL is a case sensitive language.
In PL/SQL loop counter is automatically incremented by
1.
Q.2 Write short notes 8
States of transaction.
Strong and weak entity set
Answer the following: 6
Explain types of distributed database.
Explain users of DBMS.
Q.3 Answer the following
Construct an ERD for Hotel Management System 8
Explain multivalve dependency and 4NF with example. 6
Q.4 Answer the following
Explain steps in query processing and advantages of query
optimization in detail.
8
Explain varying array with example.
Q.5 Answer the following 14
What is two phasing locking two phase commit protocol?
What is shadow paging technique? Explain in detail.
Q.6 Answer the following 8
Explain INF and 3NF with example.
Explain generalization and specialization in detail.
Q.7 Answer the following 14
What is Relational algebra? Explain select, project, union,
intersect operations with example.
Explain database views with example.