Sail E0 Webinar

MCQs

Total Questions : 30 | Page 3 of 3 pages
Question 21. Some advantages of partitioning include: efficiency, security, and load balancing.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 22. A pointer is a detailed coding scheme recognized by system software for representing organizational data.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 23. Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
  1.    True
  2.    False
 Discuss Question
Answer: Option B. -> False
Question 24. A field represents each component of a composite attribute.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 25. When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
  1.    True
  2.    False
 Discuss Question
Answer: Option A. -> True
Question 26. In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 27. Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 28. The three newest database architectures in use today are relational, multidimensional and hierarchical.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False
Question 29. An extent is a contiguous section of disk storage space.
  1.    False
  2.    True
 Discuss Question
Answer: Option B. -> True
Question 30. It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
  1.    False
  2.    True
 Discuss Question
Answer: Option A. -> False

Latest Videos

Latest Test Papers