Database Management Systems Mid - II, November - 2014

1.The unit of information read from or written to disk is a
  • Page
  • Length
  • Space
  • None
Answer: A
2._____ manager fetches the pages from disk if it is not already in memory
  • Disk Space
  • Buffer
  • Both
  • None
Answer: B
3.________ is the property of the transactions that describes either all or none of transactions are reflected properly in the data base.
  • Isolation
  • Durability
  • Atomicity
  • Consistency
Answer: C
4.A ________ is a direct graph where the vertices are the transactions.
  • B+ tree
  • B tree
  • Precedence graph
  • None
Answer: C
5.An index on a set of fields that includes the primary keys is called ________ index.
  • Primary
  • Secondary
  • Both
  • None
Answer: A
6.Storing the same information several times in a database is known as
  • Redundancy
  • Concurrency
  • Redesign
  • Arbitration
Answer: A
7.Forth normal form is a direct generalization of
  • 2NF
  • 4NF
  • 3NF
  • 5NF
Answer: B
8.A _______ is a unit of program execution that accesses and possibly updates various data items.
  • Schedule
  • Task
  • Transaction
  • Process
Answer: C
9.WAL expansion is
  • Write Again Logging
  • Well Again Logging
  • Write Ahead Logging
  • Wait ahead Logging
Answer: C
10.Hash indices are only ________ index structures.
  • Primary
  • Secondary
  • Ternary
  • Tree
Answer: B
11.________________ can help when we have to access a collection of records in multiple ways.
Answer: Indexing
12.The bucket to which a record belongs can be determined by applying a special function, called a ________________ to the search key.
Answer: Hash Function
13.________________ protocol requires that each transaction issue lock & unlock requests in 2 phases.
Answer: 2-Phase Locking
14.Space of disk is managed by the _________________.
Answer: Disk Space Manger
15.The ____________ component of a database system implements the support for atomicity & durability.
Answer: Recovery Management
16.The ______________ property enables us to enforce any constraint on the original relation by simply enforcing some constraints on each of the smaller relations.
Answer: Dependency Preservation
17.A transaction may release locks, but may not obtain any new locks in _________________ phase.
Answer: Shrinking
18.In multi version ________________ write operations may result in a lock wait or, possibly, in deadlock.
Answer: 2-Phase Locking
19.The _________________ technique allows database modifications to be output to the database while the transaction is still in the active state.
Answer: Immediate Modification
20.Extendable hashing technique is __________________ hashing.
Answer: Dynamic