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. XSLT processors are context-oriented; each statement is evaluated in the context of the match that has been made.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A bitmap index is an index on columns from two or more tables that come from the same domain of values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Indexes are created to enforce uniqueness on columns and to enable fast retrieval by column values.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. What is not true about XML?

    • Options
    • A. Web page display is the most important application of XML.
    • B. With XML, there is a clear separation between document structure, content and materialization.
    • C. XML is more powerful than HTML.
    • D. XML documents have two sections.
      • Discuss
    • 5. Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

    • Options
    • A. Lock level
    • B. Transaction isolation level
    • C. Cursor concurrency setting
    • D. Locking hints
      • Discuss
    • 6. ________ is a cover for utilizing OLE DB that is designed for use by almost any language.

    • Options
    • A. ODBC
    • B. ASP
    • C. JPCD
    • D. ADO
      • Discuss
    • 7. When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

    • Options
    • A. first step.
    • B. second step.
    • C. third step.
    • D. fourth step.
      • Discuss
    • 8. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?

    • Options
    • A. All fields are stored in one relation.
    • B. All fields are stored in two relations.
    • C. All fields are stored in three relations.
    • D. All fields are stored in four relations.
      • Discuss
    • 9. When building a database from an existing set of tables, we still need to consider normalization principles.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.

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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.