logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Database Design Using Normalization See What Others Are Saying!
  • Question

  • Needing to using more complicated SQL in database applications is a(n) ________ of normalization.


  • Options
  • A. advantage
  • B. disadvantage
  • C. either an advantage or disadvantage
  • D. neither an advantage nor disadvantage

  • Correct Answer
  • disadvantage 

    • More questions

    • 1. Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?

    • Options
    • A. Entity
    • B. Attribute
    • C. Identifier
    • D. Relationship
      • Discuss
    • 2. A phantom read occurs when a transaction rereads data it has previously read and finds modifications or deletions caused by a committed transaction.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. With XML:

    • Options
    • A. views are not limited to one multi-valued path only.
    • B. documents can automatically be generated from database data only.
    • C. database data can automatically be extracted from XML documents only.
    • D. With XML, all of the above are true.
      • Discuss
    • 4. Some of the columns of a relation are at different sites is which of the following?

    • Options
    • A. Data Replication
    • B. Horizontal Partitioning
    • C. Vertical Partitioning
    • D. Horizontal and Vertical Partitioning
      • Discuss
    • 5. Business Intelligence (BI) reporting systems are used to make sophisticated mathematical and statistical calculations in order to prepare reports based on the data.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. A traditional data administrator performs which of the following roles?

    • Options
    • A. Tune database performance
    • B. Establish backup and recovery procedures
    • C. Resolve data ownership issues
    • D. Protect the security of the database.
      • Discuss
    • 7. Hypertext Transfer Protocol (HTTP) is secure.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. A point of synchronization between the database and the transaction log is generally referred to as a stop point.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

    • Options
    • A. The multivalue, multicolumn problem
    • B. The inconsistent values problem
    • C. The missing values problem
    • D. The general-purpose remarks column problem
      • Discuss
    • 10. ODL supports the abstract keyword for classes and operations.

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