logo

CuriousTab

CuriousTab

Discussion


Home Database Physical Database Design See What Others Are Saying!
  • Question
  • 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

  • Correct Answer
  • False 


  • More questions

    • 1. Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.

    • Options
    • A. True
    • B. False
    • Discuss
    • 2. Total specialization is represented by double lines between the supertype and subtype on an EER.

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?

    • Options
    • A. Null status
    • B. Data type
    • C. Default value
    • D. Data constraints
    • Discuss
    • 4. In 1:N relationships, which entity becomes the parent entity is arbitrary.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?

    • Options
    • A. Read committed
    • B. Read uncommitted
    • C. Repeatable read
    • D. Serializable
    • Discuss
    • 6. In a relation, the order of the rows matters.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. A transitive dependency is which of the following?

    • Options
    • A. A functional dependency between two or more key attributes.
    • B. A functional dependency between two or more nonkey attributes.
    • C. A relation that is in first normal form.
    • D. A relation that is in second normal form.
    • Discuss
    • 8. Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. A distributed database can use which of the following strategies?

    • Options
    • A. Totally centralized at one location and accessed by many sites
    • B. Partially or totally replicated across sites
    • C. Partitioned into segments at different sites
    • D. All of the above
    • Discuss
    • 10. There is one physical schema for each logical schema.

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


    Comments

    There are no comments.

Enter a new Comment