logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ JDBC, Java Server Pages, and MySQL See What Others Are Saying!
  • Question

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

  • Correct Answer
  • AUTO_INCREMENT 

    • More questions

    • 1. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Locks placed by command are called ________ .

    • Options
    • A. implicit locks
    • B. explicit locks
    • C. exclusive locks
    • D. shared locks
      • Discuss
    • 3. Helping people keep track of things is the purpose of a(n) ________ .

    • Options
    • A. database
    • B. table
    • C. instance
    • D. relationship
      • Discuss
    • 4. Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. What type of join is needed when you wish to include rows that do not have matching values?

    • Options
    • A. Equi-join
    • B. Natural join
    • C. Outer join
    • D. All of the above.
      • Discuss
    • 6. A key is a group of one or more attributes that uniquely identifies a row.

    • Options
    • A. True
    • B. False
      • Discuss
    • 7. A transaction log shows before and after images of records that have been modified by transactions.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. When mapping a ternary relationship with an associative entity into a relation which of the following is true?

    • Options
    • A. One relation is created.
    • B. Two relations are created.
    • C. Three relations are created.
    • D. Four relations are created.
      • Discuss
    • 9. The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.

    • Options
    • A. True
    • B. False
      • Discuss
    • 10. A supertype is an entity type that shares common attributes or relationships distinct from other subgroupings.

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