Database Management Systems Mid - II, April - 2012

1.In__________ the records are stored in ascending or descending primary key order.
  • Serial file
  • sequential file
  • a & b
  • None
Answer: B
2.The only one stored list for every attribute value is known as _______
  • Multi list file
  • inverted index file
  • sequential file
  • None
Answer: A
3.The component of the system assumes a state that is not desirable is _________
  • Fault
  • failures
  • errors
  • None
Answer: C
4.The assignment and management of memory blocks is ______________
  • Virtual memory
  • buffer management
  • memory management
  • None
Answer: B
5.The coordination of the simultaneous execution of transactions in multi user database is
  • ACID property
  • concurrency control
  • transaction control
  • none
Answer: B
6.Shared lock is used for _________
  • Read data
  • write data
  • a & b
  • none
Answer: A
7.The two transaction wait indefinitely for each other to unlock data __________
  • Shared lock
  • dead lock
  • exclusive lock
  • a & b
Answer: B
8.The correction from the failures is known as ____________
  • Recovery
  • abort
  • commit
  • none
Answer: A
9._____ key not allows null and duplicate values.
  • Unique key
  • foreign key
  • primary key
  • none
Answer: C
10.The process of compiling information on an object is __________
  • Generalization
  • aggregation
  • super type
  • none
Answer: B
11.___________ never contain any other node beyond this node.
Answer: LEAF NODE
12.The system does not function according to its specifications and fails is known as ____________
Answer: FAILURE
13.A ____________ is a program unit whose execution may change the contain of a data base.
Answer: TRANSACTION
14.The schedule for the concurrent execution of the transaction is ________________
Answer: SERIALIZABILITY
15.The attribute not part of any candidate key is ________________________
Answer: NON PRIME ATTRIBUTE / NON PRIME
16.The values in the domain of each attribute of relation are atomic is known as _______________
Answer: FIRST NORMAL FORM
17.The storage medium used in disk is a __________________
Answer: DISK PACK
18.The relationship in E-R model form between________________
Answer: ENTITIES ONLY
19.The non-key attributes must be fully dependent on the _________________________________
Answer: PRIMARY KEY / KEY ATTRIBUTE
20.The _________________________________ of memory blocks is buffer management .
Answer: ASSIGNMENT AND MANAGEMENT