logo

CuriousTab

CuriousTab

Discussion

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

  • The entity integrity rule states that:


  • Options
  • A. no primary key attribute may be null.
  • B. no primary key can be composite.
  • C. no primary key may be unique.
  • D. no primary key may be equal to a value in a foreign key.

  • Correct Answer
  • no primary key attribute may be null. 

    • More questions

    • 1. An ERD that has had the entities clustered will display more entities.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. A differential backup makes a copy of the entire database.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. Which is not true about surrogate keys?

    • Options
    • A. They are short.
    • B. They are fixed.
    • C. They have meaning to the user.
    • D. They are numeric.
      • Discuss
    • 4. OLAP uses measures, dimensions and associations.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. We use the SQL construct COUNT(*) to count the number of rows in a table.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. To obtain the structure of an Oracle table, the command to use is:

    • Options
    • A. STRUCTURE [TableName].
    • B. DESCRIBE [TableName].
    • C. DESCRIBE STRUCTURE [TableName].
    • D. DESC TABLE [TableName].
      • Discuss
    • 7. The delivery function of a report management system allows reports to be delivered via e-mail, via the Web, via XML Web services, via hand delivery and other delivery means.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. Stand-alone databases exhibit many of the same advantages common to file processing systems.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. A minimum cardinality is the minimum number of entity instances that may participate in a relationship instance.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. Resource locking is a process to prevent multiple applications from obtaining copies of the same record when the record is about to be changed.

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