Master Of Computer Application II (Science)
Examination: Oct Nov 2016 Semester III (New CBCS)
SLR No. Day
Date Time Subject Name Paper
No. Seat No.
SLR U
19
Wednesday
23/11/2016
02:30 P.M
To
05:00 P.M
DBMS
C

Instructions: Question no. 1 2 are compulsory.
Attempt any three questions from Q. No. 3 to Q. No. 7.
Figures to the right indicate full marks.
Total Marks: 70
Q.1 Choose correct alternatives 10
In E-R diagram relationship is represented by
Ellipse Dashed ellipse
Rectangle Demand
A table joined with itself is called
Join Equi join
Outer join Self join
states that only valid data will be written to the database.
Atomicity Consistency
Isolation Durability
If the database modification occurs when the transaction is active, then the
transaction is said to use the technique
Deferred modification Late modification
Immediate modification Undo
Which of the following is not true about PL/SQL cursors?
A cursor is a view on a table
A cursor holds the rows (one or more) returned by sol statement
The set of rows cursor holds is referred as active data set.
None of the above
The method COUNT
Returns the last (largest) number in the collection that uses integer
subscript.
Return the number of element that a collection currently contains
Checks the maximum size of the collection
None of the above
The scheme uses the page table containing pointers to all the
pages. The page tables itself and all the updated pages are copied to a new
location.
Shadow copy Shadow paging
Update Log Records None of the above
Page 1 of 2
In SQL is used for pattern searching where patterns
consist of characters to be matched.
BETWEEN IN
GROUP LIKE
The relational data models are based on the collection of
Rows Columns
Tables None of the above
10) TCL stands for
Transaction control language
Transaction commit language
Transaction confirm language
None of the above
State whether following statements are true or false. 04
SQL is a case sensitive language.
A candidate key is minimal super key.
DML statements are not allowed in functions.
A foreign key is not necessary to be a primary key in parent table.
Q.2 Write a short note on following 08
Limitations of traditional file system.
Two phase locking protocol.
Answer the following 06
Explain client/server architecture.
Describe checkpoint.
Q.3 Answer the following:
Explain deferred database update and immediate database update in detail.
Explain life cycle of database development system.
08
06
Q.4 Answer the followings:
Explain steps in query processing in detail and advantages of optimization.
What is transaction? Explain ACID properties.
08
06
Q.5 Answer the followings
Explain 2NF and 4NF with example.
Explain generalization, specialization and aggregation in detail.
08
06
Q.6 Answer the following
What is conflict and view serializability? Explain in detail.
Explain fragmentation and replication technique in distributed database.
08
06
Q.7 Answer the following
Explain function dependency and its types with examples.
What is entity? Explain any 5 notations in entity relationship diagram with
example.