Database Design Process MCQ

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

• Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
  ক

  Cross-tabs

  খ

  Snapshot

  গ

  Both Cross-tabs and Snapshot

  ঘ

  All of the mentioned
• Thus a _______ of course data gives the values of all attributes, such as title and department, of all courses at a particular point in time.
  ক

  Instance

  খ

  Snapshot

  গ

  Both Instance and Snapshot

  ঘ

  All of the mentioned
• Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
  ক

  Fourth NF

  খ

  BCNF

  গ

  Third NF

  ঘ

  Second NF
• In the schema (dept name, size) we have relations total inst 2007, total inst 2008. Which dependency have lead to this relation ?
  ক

  Dept name, year->size

  খ

  Year->size

  গ

  Dept name->size

  ঘ

  Size->year
• Designers use which of the following to tune the performance of systems to support time-critical operations?
  ক

  Denormalization

  খ

  Redundant optimization

  গ

  Optimization

  ঘ

  Realization
• What is the best way to represent the attributes in a large database?
  ক

  Relational-and

  খ

  Concatenation

  গ

  Dot representation

  ঘ

  All of the mentioned
• Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by
  ক

  Unique-role assumption

  খ

  Unique-key assignment

  গ

  Role intergral assignment

  ঘ

  None of the mentioned
• Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set.
  ক

  A many-to-many relationship set

  খ

  A multivalued attribute of an entity set

  গ

  A one-to-many relationship set

  ঘ

  All of the mentioned
• _____________ can help us detect poor E-R design.
  ক

  Database Design Process

  খ

  E-R Design Process

  গ

  Relational scheme

  ঘ

  Functional dependencies