logo

CuriousTab

CuriousTab

Discussion


Home Database Data Models into Database Designs See What Others Are Saying!
  • Question
  • 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.

  • Correct Answer
  • They have meaning to the user. 


  • More questions

    • 1. A regular subquery can be processed:

    • Options
    • A. from the top down.
    • B. from the bottom up.
    • C. by nesting.
    • D. None of the above is correct.
    • Discuss
    • 2. Which of the following situation requires the use of ID-dependent entities?

    • Options
    • A. Association relationships only
    • B. Multivalued attributes only
    • C. Archetype/instance relationships only
    • D. All of the above use ID dependent entities
    • Discuss
    • 3. What is not an advantage of stored procedures?

    • Options
    • A. Greater security
    • B. SQL can be optimized
    • C. Code sharing
    • D. Increased network traffic
    • Discuss
    • 4. The SQL statement that queries or reads data from a table is ________ .

    • Options
    • A. SELECT
    • B. READ
    • C. QUERY
    • D. None of the above is correct.
    • Discuss
    • 5. A foreign key is which of the following?

    • Options
    • A. Any attribute
    • B. The same thing as a primary key
    • C. An attribute that serves as the primary key of another relation
    • D. An attribute that serves no purpose
    • Discuss
    • 6. Most operational databases can be used for many BI applications.

    • Options
    • A. True
    • B. False
    • Discuss
    • 7. Given the functional dependency R ? (S,T) , then it is also true that R ? S.

    • Options
    • A. True
    • B. False
    • Discuss
    • 8. Which is not true of a correlated subquery?

    • Options
    • A. EXISTS/NOT EXISTS is a form of a correlated subquery.
    • B. The processing of the SELECT statements is nested.
    • C. They can be used to verify functional dependencies.
    • D. They are very similar to a regular subquery.
    • Discuss
    • 9. One popular classification technique in Business Intelligence (BI) reporting is ________ .

    • Options
    • A. cluster analysis only
    • B. regression analysis only
    • C. RFM analysis only
    • D. both cluster analysis and regression analysis
    • Discuss
    • 10. The goal of database security is to ensure that only authorized users can perform authorized activities at authorized times.

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


    Comments

    There are no comments.

Enter a new Comment