Physical Database Design MCQ

Test your knowledge with important Physical Database Design MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Physical Database Design MCQs at Bissoy

• It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
  ক

  True

  খ

  False
• 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.
  ক

  True

  খ

  False
• Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process.
  ক

  True

  খ

  False
• The three newest database architectures in use today are relational, multidimensional and hierarchical.
  ক

  True

  খ

  False
• An extent is a contiguous section of disk storage space.
  ক

  True

  খ

  False
• Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
  ক

  True

  খ

  False
• A pointer is a detailed coding scheme recognized by system software for representing organizational data.
  ক

  True

  খ

  False
• Some advantages of partitioning include: efficiency, security, and load balancing.
  ক

  True

  খ

  False
• A field represents each component of a composite attribute.
  ক

  True

  খ

  False
• When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
  ক

  True

  খ

  False
• A bitmap index is an index on columns from two or more tables that come from the same domain of values.
  ক

  True

  খ

  False
• The primary goal of physical database design is data processing efficiency.
  ক

  True

  খ

  False
• Hashing algorithm converts a primary key value into a record address.
  ক

  True

  খ

  False
• Denormalization and clustering can work well to minimize data access time for small records.
  ক

  True

  খ

  False
• Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
  ক

  True

  খ

  False
• A multidimensional database model is used most often in which of the following models?
  ক

  Data warehouse

  খ

  Relational

  গ

  Hierarchical

  ঘ

  Network
• Sequential retrieval on a primary key for sequential file storage has which of the following features?
  ক

  Very fast

  খ

  Moderately fast

  গ

  Slow

  ঘ

  Impractical
• A rule of thumb for choosing indexes for a relational database includes which of the following?
  ক

  Indexes are more useful on smaller tables.

  খ

  Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.

  গ

  Do not specify a unique index for the primary key of each table.

  ঘ

  Be careful indexing attributes that have null values.
• The fastest read/write time and most efficient data storage of any disk array type is:
  ক

  RAID-0

  খ

  RAID-1

  গ

  RAID-2

  ঘ

  RAID-3
• A secondary key is which of the following?
  ক

  Nonunique key

  খ

  Primary key

  গ

  Useful for denormalization decisions

  ঘ

  Determines the tablespace required
• What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
  ক

  VARCHAR2

  খ

  CHAR

  গ

  LONG

  ঘ

  NUMBER
• Which of the following is not a factor to consider when switching from small to large block size?
  ক

  The length of all of the fields in a table row

  খ

  The number of columns

  গ

  Block contention

  ঘ

  Random row access speed
• Which of the following are integrity controls that a DBMS may support?
  ক

  Assume a default value in a field unless a user enters a value for that field.

  খ

  Limit the set of permissible values that a field may assume.

  গ

  Limit the use of null values in some fields.

  ঘ

  All of the above.
• The blocking factor is:
  ক

  a group of fields stored in adjacent memory.

  খ

  the number of physical records per page.

  গ

  attributes grouped together by the same primary key.

  ঘ

  attributes grouped together by the same secondary key.
• If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
  ক

  All fields are stored in one relation.

  খ

  All fields are stored in two relations.

  গ

  All fields are stored in three relations.

  ঘ

  All fields are stored in four relations.
• What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
  ক

  VARCHAR2

  খ

  CHAR

  গ

  LONG

  ঘ

  NUMBER
• Selecting a data type involves which of the following?
  ক

  Maximize storage space

  খ

  Represent most values

  গ

  Improve data integrity

  ঘ

  All of the above.
• If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
  ক

  All fields are stored in one relation.

  খ

  All fields are stored in two relations.

  গ

  All fields are stored in three relations.

  ঘ

  All fields are stored in four relations.