Database Management Systems Mid - I, February - 2012

1.A group of similar objects which maintain data is ________
  • Attributes
  • entity type
  • relation ship
  • None
Answer: B
2.The rectangle represents in E-R model is _________
  • Entity set
  • attribute
  • relation ship
  • entity type
Answer: A
3.Insertion , deletion and modification operators is ____________
  • Update operations
  • retrieve operations
  • physical operations
  • insert operations
Answer: A
4.The index file is used to describe the _________
  • Entity set
  • attribute
  • relation ship
  • indexes
Answer: D
5.The select statement is an ________________
  • Definitional statement
  • manipulation statement
  • retrieval statement
  • None
Answer: C
6.The tuples which do not contribute to the result of inner operation is known as____
  • Shipping
  • derivation tuples
  • dangling tuples
  • None
Answer: C
7.The member ship is not automatic is _________________
  • Personal member ship
  • manual member ship
  • automatic
  • None
Answer: B
8.The record of an update operation made on the database is _________
  • Insertion
  • update
  • audit trail
  • delete
Answer: C
9.The transaction addresses the datebase using another page table is__________
  • Shadow pagetable
  • current page table
  • physical table
  • None
Answer: B
10.Manipulating the value of lock is called _________
  • Locking
  • lock manager
  • lock
  • None
Answer: A
11.The set of possible values that a given attribute is called _____________
Answer: DOMAIN
12.A relation ship between two entities is ___________________________
Answer: BINARY RELATIONSHIP
13.The rotational delay is called __________________________
Answer: LATENCY TIME
14.In _____________________the queries are expressed as variables.
Answer: RELATINAL CALCULUS
15.The tuples with null values that did not exist in the original relation is known as ________________
Answer: SPURIOUS TUPLES
16.A relationship with in only one entity is ___________________________
Answer: UNARY RELATIONSHIP
17.The functions of the system as per specification and correct output is known as ________________
Answer: RELIABLE
18.The failures involving loss of nonvolatile information is ________________________
Answer: ARCHIVAL LOG
19.The portion of the database that still intact after a failure is ___________________
Answer: METERIALIZED DATABASE
20.The statement executed in order is called _________________________
Answer: SCHEDULE