logo

CuriousTab

CuriousTab

Discussion


Home Database ER Model and Business Rules See What Others Are Saying!
  • Question
  • A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • False 


  • More questions

    • 1. You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .

    • Options
    • A. user data.
    • B. metadata
    • C. A report
    • D. indexes
    • Discuss
    • 2. For what purposes are views used?

    • Options
    • A. To hide columns only
    • B. To hide rows only
    • C. To hide complicated SQL statements only
    • D. All of the above are uses for SQL views.
    • Discuss
    • 3. What MySQL property is used to create a surrogate key in MySQL?

    • Options
    • A. UNIQUE
    • B. SEQUENCE
    • C. AUTO_INCREMENT
    • D. None of the above -- Surrogate keys are not implemented in MySQL.
    • Discuss
    • 4. Concurrency control is important for which of the following reasons?

    • Options
    • A. To ensure data integrity when updates occur to the database in a multiuser environment
    • B. To ensure data integrity when updates occur to the database in a single-user environment
    • C. To ensure data integrity while reading data occurs to the database in a multiuser environment
    • D. To ensure data integrity while reading data occurs to the database in a single-user environment
    • Discuss
    • 5. User views are included as part of which schema?

    • Options
    • A. Internal
    • B. Conceptual
    • C. External
    • D. None of the above.
    • Discuss
    • 6. Which of the following is an ordered collection of elements of the same type?

    • Options
    • A. Set
    • B. Bag
    • C. List
    • D. Dictionary
    • Discuss
    • 7. The fact that the same operation may apply to two or more classes is called what?

    • Options
    • A. Inheritance
    • B. Polymorphism
    • C. Encapsulation
    • D. Multiple classification
    • Discuss
    • 8. The benefits of object-oriented modeling are which of the following?

    • Options
    • A. The ability to tackle more challenging problems
    • B. Reusability of analysis, design, and programming results
    • C. Improved communication between users, analysts, etc.
    • D. All of the above.
    • Discuss
    • 9. A heterogeneous distributed database is which of the following?

    • Options
    • A. The same DBMS is used at each location and data are not distributed across all nodes.
    • B. The same DBMS is used at each location and data are distributed across all nodes.
    • C. A different DBMS is used at each location and data are not distributed across all nodes.
    • D. A different DBMS is used at each location and data are distributed across all nodes.
    • Discuss
    • 10. Which SQL-92 standard SQL command can be used to change a table name?

    • Options
    • A. RENAME TABLE
    • B. CHANGE TABLE
    • C. ALTER TABLE
    • D. None of the above is correct.
    • Discuss


    Comments

    There are no comments.

Enter a new Comment