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 inconsistent values 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 rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column. 

    • More questions

    • 1. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

    • Options
    • A. Two
    • B. Three
    • C. Four
    • D. Six
      • Discuss
    • 2. With JSP, the coding is done in Java and only in Java.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Indexes may be created or dropped at any time.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Another name for multimedia data is unstructured data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The data model produced from the reverse engineering process is a true logical model.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Oracle will let you define Notepad as your default editor, and whenever you type NOTEPAD, SQL*Plus will invoke Notepad.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. The left-leaning slash tells Oracle to execute whatever statement is in the buffer.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Failure to control confidentiality may lead to loss of competitiveness.

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