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 on Bissoy. Bissoy App

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