Database - Database Design Using Normalization

Database - Database Design Using Normalization
11. When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
  • first step.
  • second step.
  • third step.
  • fourth step.
Show Answer
12. Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
  • Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
  • Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
  • Three rows have the values Brown, NULL, and Blue in the same column.
  • One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Show Answer
13. When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
  • first step.
  • second step.
  • third step.
  • fourth step.
Show Answer
14. If a table has been normalized so that all determinants are candidate keys, then that table is in:
  • 1NF.
  • 2NF
  • 3NF.
  • BCNF.
Show Answer
15. Read-only databases are ________ updated.
  • always
  • commonly
  • seldom
  • never
Show Answer
16. Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
  • advantage
  • disadvantage
  • either an advantage or disadvantage
  • neither an advantage nor disadvantage
Show Answer
17. When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
  • first step.
  • second step.
  • third step.
  • fourth step.
Show Answer
18. Normalization ________ data duplication.
  • eliminates
  • reduces
  • increases
  • maximizes
Show Answer
19. Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
  • Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
  • Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
  • Three rows have the values Brown, NULL, and Blue in the same column.
  • One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column
Show Answer
20. A BI reporting system does not ________ .
  • create meaningful information
  • deliver information to users on a timely basis
  • use statistical procedures to predict future events
  • use disparate data sources
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test