Time Left - 15:00 mins

Mission ISRO 2017 Day-22: Database Quiz -1

Attempt now to get your rank among 821 students!

Question 1

A physical DFD specifies

Question 2

Consider the following Relationship Entity Diagram(ERP)

Which of the following possible relations will not hold if the above ERD is mapped into a relation model?

Question 3

Let x, y, z, a, b, c be the attributes of an entity set E. If {x}, {x, y}, {a, b}, {a, b, c}, {x, y, z} are superkeys then which of the following are the candidate keys?

Question 4

In functional dependency, Armstrong’s inference rules refers to

Question 5

If D₁,D₂,….D_n are domains in a relational model, then the relation is a table, which is a subset of

Question 6

Trigger is

Question 7

Armstrong’s inference rule doesn’t determine

Question 8

A locked Databases file can be

Question 9

Purpose of ‘Foreign Key’ in a table is to ensure

Question 10

A view of a database that appears to an application program is known as

Question 11

Which of the following is correct with respect to two phase commit protocol?

Question 12

Which of the following is the highest isolation in transaction management?

Question 13

Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and, then apply a 5% interest
i. T1 start
ii. T1 B old = 12000 new = 10000
iii. T1 M old = 0 new = 2000
iv. T1 commit
v. T2 start
vi. T2 B old = 10000 new = 10500
vii. T2 commit
Suppose the database system crashed just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?

Question 14

Which of the following scenarios may lead to an irrecoverable error in a Databases system?

Question 15

Which of the following contains complete record of all activity that affected the contents of a Databases during a certain period of time?

821 attempts
2 upvotes
20 comments

Tags :

GATE & PSU CS Databases

Jul 2GATE & PSU CS