Sail E0 Webinar

MCQs

Total Questions : 46 | Page 5 of 5 pages
Question 41. . What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
  1.    VARCHAR2
  2.    CHAR
  3.    LONG
  4.    NUMBER
 Discuss Question
Answer: Option B. -> CHAR
Question 42. . A secondary key is which of the following?
  1.    Nonunique key
  2.    Primary key
  3.    Useful for denormalization decisions
  4.    Determines the tablespace required
 Discuss Question
Answer: Option A. -> Nonunique key
Question 43. . The fastest read/write time and most efficient data storage of any disk array type is:
  1.    RAID-0.
  2.    RAID-1.
  3.    RAID-2.
  4.    RAID-3.
 Discuss Question
Answer: Option A. -> RAID-0.
Question 44.  Which of the following is not a factor to consider when switching from small to large block size?
  1.    The length of all of the fields in a table row.
  2.    The number of columns
  3.    Block contention
  4.    Random row access speed
 Discuss Question
Answer: Option B. -> The number of columns
Question 45. . A multidimensional database model is used most often in which of the following models?
  1.    Data warehouse
  2.    Relational
  3.    Hierarchical
  4.    Network
 Discuss Question
Answer: Option A. -> Data warehouse
Question 46. . A multidimensional database model is used most often in which of the following models?
  1.    Data warehouse
  2.    Relational
  3.    Hierarchical
  4.    Network
 Discuss Question
Answer: Option A. -> Data warehouse

Latest Videos

Latest Test Papers