logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Distributed Databases See What Others Are Saying!
  • Question

  • Replication should be used when which of the following exist?


  • Options
  • A. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
  • B. When using many nodes with different operating systems and DBMSs and database designs.
  • C. The application's data can be somewhat out-of-date.
  • D. All of the above.

  • Correct Answer
  • The application's data can be somewhat out-of-date. 

    • More questions

    • 1. In a 1:1 relationship, the foreign key is placed in:

    • Options
    • A. either table without specifying parent and child tables.
    • B. the parent table.
    • C. the child table.
    • D. either the parent table or the child table.
      • Discuss
    • 2. Strategic Planning factors do not include which of the following?

    • Options
    • A. Organizational goals
    • B. Critical success factors
    • C. Information engineering
    • D. Problem areas
      • Discuss
    • 3. An intersection table is required to represent M:N relationships.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. A ternary relationship involves how many entities?

    • Options
    • A. 3 or less
    • B. 3
    • C. More than 3
    • D. 3 or more
      • Discuss
    • 5. A disaster recovery plan does not need to include the shipment of database backups to other sites.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. MySQL surrogate keys are given the property AUTO_INCREMENT.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. The reports generated by a reporting system are usually not delivered in which of the following media?

    • Options
    • A. Web portal
    • B. Commercial courier service
    • C. Digital dashboard
    • D. E-Mail
      • Discuss
    • 8. 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
    • 9. 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
    • 10. 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

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.