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 D1,D2,….Dn 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?
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 CSDatabasesJul 2GATE & PSU CS