logo

CuriousTab

CuriousTab

Discussion

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

  • When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 

    • More questions

    • 1. Whose role is it to determine the requirements and design for a database?

    • Options
    • A. Database analysts
    • B. Database administrators
    • C. Both A and B.
    • D. Neither A or B.
      • Discuss
    • 2. Derived data are detailed, current data intended to be the single, authoritative source for all decision support applications.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. SQL views can be used to hide:

    • Options
    • A. columns and rows only.
    • B. complicated SQL syntax only.
    • C. both of the above can be hidden by an SQL view.
    • D. None of the above is correct.
      • Discuss
    • 4. Some advantages of partitioning include: efficiency, security, and load balancing.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. Websites without a database attached to them have which of the following characteristics?

    • Options
    • A. The ability to generate data via SQL.
    • B. The inability to use a browser to display Web pages.
    • C. Static information using HTML or JavaScript.
    • D. The need to use TCP/IP as the network protocol.
      • Discuss
    • 6. The reserved word enum is used for which of the following?

    • Options
    • A. To define a range for an attribute.
    • B. To define a range for a class.
    • C. To define a range for a relationship.
    • D. All of the above.
      • Discuss
    • 7. The term Complete for a UML has the same meaning as which of the following for an EER diagram?

    • Options
    • A. Overlapping rule
    • B. Disjoint rule
    • C. Total specialization rule
    • D. Partial specialization rule
      • Discuss
    • 8. Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Although creating test databases is a critical and necessary job, there are few career opportunities in this area.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.

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