logo

CuriousTab

CuriousTab

Discussion


Home Database SQL for Database Construction Comments

  • Question
  • Views can be used to show the results of computed columns.


  • Options
  • A. True
  • B. False

  • Correct Answer
  • True 


  • SQL for Database Construction problems


    Search Results


    • 1. A view that contains a computed column can be easily updated.

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

    • Options
    • A. True
    • B. False
    • Discuss
    • 3. An entity class is a collection of entities and is described by the structure of the entities in that class.

    • Options
    • A. True
    • B. False
    • Discuss
    • 4. A subtype entity is a special case of another entity called a supertype entity.

    • Options
    • A. True
    • B. False
    • Discuss
    • 5. A recursive relationship is a relationship between an archetype and an instance of that archetype.

    • Options
    • A. True
    • B. False
    • Discuss
    • 6. Common types of SQL CHECK constraints include range checks and limiting columns values.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. The SQL DELETE statement is used to delete both the table structure and table data.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. SQL statements can be embedded in triggers, stored procedures, and program code.

    • Options
    • A. True
    • B. False
    • Discuss
    • 9. There are three SQL data modification operations: insert, modify and delete.

    • Options
    • A. True
    • B. False
    • Discuss
    • 10. If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

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


    Comments

    There are no comments.

Enter a new Comment