M.C.A. (Semester III) (CBCS) Examination Oct/Nov-2017
Science
DBMS
Day Date: Thursday, 23-11-2017 Max. Marks: 70
Time: 02.30 PM to 05.00 PM
Instructions: Question No.1 and 2 are compulsory.
Attempt any 3 questions from Q.NO. 3 to Q. No. 7
Figures to the right indicate full marks.
Q.1 Select most correct alternative: 10
Between is operator.
Range List
Comparison None of these
is a virtual table formed by subset of columns from one or
more tables.
View Trigger
Join Cursor
In 'immediate database modification technique', data modification
technique written by active transactions is called as
Uncommitted modifications Committed modifications
Both and None of these
In E-R diagram multivalved attributes are denoted by
Dim and Double Ellipse
Both and None of these
Do all or do none in transaction is known as
Atomicity Consistency
Isolation Durability
In select command clause is used for getting rows from a
query in specific order
SORT BY GROUP BY
ORDER BY HAVING
In the SQL cursor, which attribute is TRUE when a cursor has some
rows remained to fetch, and FALSE when a cursor has rows left to
fetch.
ROWCOUNT FOUND
NOTFOUND ISOPEN
The method COUNT
Returns the last (largest) number in the collection that uses integer
subscript.
Returns the number of element that a collection currently contains
Checks the maximum size of the collection
None of the above
Page 2 of 2
SLR-SM-26
Execution of transaction guarantees that consistency is
preserved.
Concurrent Serial
Both and None of these
10) ACID stands for
Atomicity, Consistency, Isolation, Durability
Atomicity, Consistent, Isolated, Durability
Atomicity, Consistent, Integrated, Durability
Atomicity, Consistent, Integration, Durability
State whether following statements are True or False: 04
A weak entity set to be meaningful must be associated with a strong
entity set.
Implicit cursors are refereed by name SQL.
In PL/SQL functions delete statement is allowed.
Every relation in 3NF is in BCNF too.
Q.2 Write short notes on 08
Fragmentation and replication technique in distributed database.
Database model
Answer the following: 06
Explain difference between standalone and distributed database.
What is fully functional dependency and partial dependency? Explain
with example.
Q.3 Answer the following:
Explain steps in query processing and advantages of query optimization. 08
Explain transition with ACID properties. 06
Q.4 Answer the following:
Explain BCNF and 4NF with example. 08
Explain two phase commit protocol. 06
Q.5 Answer the following:
What is log based recovery? Explain deferred and immediate database
update in detail.
08
Explain components of DBMS architecture. 06
Q.6 Answer the following:
Explain conflict and view serializability in detail. 08
What is functional dependency? Explain its types with example. 06
Q.7 Answer the following:
What are the steps in Database Development Life Cycle 08
What are nested tables? Explain with example. 06