logo

CuriousTab

CuriousTab

Discussion


Home Database Database Design Using Normalization See What Others Are Saying!
  • Question
  • Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?


  • Options
  • A. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
  • B. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
  • C. Three rows have the values Brown, NULL, and Blue in the same column.
  • D. One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

  • Correct Answer
  • Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row. 


  • More questions

    • 1. An abstraction is a generalization of something.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. SQL Server AFTER Triggers may be assigned views.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. 'dbo' stands for database object.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. SQL is a data sublanguage.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Which one of the following symbols is not used in an ERD?

    • Options
    • A. Rectangle
    • B. Oval
    • C. Diamond
    • D. Circle
    • Discuss
    • 6. Data in operational systems are typically fragmented and inconsistent.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. VBScript is similar to JavaScript.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. The source of the data is sometimes called the system of record.

    • Options
    • A. True
    • B. False
    • Discuss


    Comments

    There are no comments.

Enter a new Comment