adplus-dvertising
frame-decoration

Question

Which of the following is the recovery management technique in DDBMS ?

a.

2PC (Two Phase Commit)

b.

Backup

c.

Immediate update

d.

All of the above

Answer: (d).All of the above

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which of the following is the recovery management technique in DDBMS ?

Similar Questions

Discover Related MCQs

Q. Which of the following is the process by which a user’s privileges ascertained ?

Q. The basic variants of time-stampbased method of concurrency control are

Q. A transaction can include following basic database access operations :

Q. Consider a hash table of size m = 10000 and the hash function h(k) = ∟m(kA mod 1)'┘ for A = (√5–1)/2. The location to the key k = 123456 is

Q. The dependency preservation decomposition is a property to decompose database schema D, in which each functional dependency X->Y specified in F,

Q. Which of the following is an optimistic concurrency control method?

Q. Which of the following is the process by which a user’s access to physical data in the application is limited, based on his privileges?

Q. Linear probing suffers from a problem known as

Q. An entity instance is a single occurrence of an …………..

Q. Generalization is ………… process.

Q. Match the following:

Set-I
I. 2 NF
II. 3 NF
III. 4 NF
IV. 5 NF

Set-II
(a) transitive dependencies eliminated
(b) multivalued attribute removed
(c) contain no partial functional dependencies
(d) contains no join dependency

Codes :
    I    II   III   IV

Q. Which data management language component enabled the DBA to define the schema components?

Q. The PROJECT Command will create new table that has

Q. A chained hash table has an array size of 100. What is the maximum number of entries that can be placed in the table?

Q. The E-R model is expressed in term of

I. Entities
II. The relationship among entities.
III. The attributes of the entities.
IV. Functional relationship.

Q. Specialization is …………… process.

Q. Match the following :

List-I
(1) Determinants
(2) Candidate key
(3) Non-redundancy
(4) Functional dependency

List-II
(a) No attribute can be added
(b) Uniquely identified a row
(c) A constraint between two attribute
(d) Group of attributes on the left hand side of arrow of function dependency.

Q. A function that has no partial functional dependencies is in ……………. form.

Q. Which of the following statement is wrong?

I. 2-phase locking protocol suffer from dead lock.
II. Time stamp protocol suffer from more aborts.
III. A block hole in a DFD is a data store with only inbound flows.
IV. Multivalued dependency among attribute is checked at 3 NF level.
V. An entity-relationship diagram is a tool to represent event model.

Q. The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called