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. An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer.

    • Options
    • A. True
    • B. False
      • Discuss
    • 2. Oracle commands, column names, table names, view names and all other database elements are case sensitive.

    • Options
    • A. True
    • B. False
      • Discuss
    • 3. When you type Start FILENAME, the statement in your file will be executed automatically.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. If there is only one statement and no ambiguity about what is wanted, Oracle will treat the semicolon and slash as the same.

    • Options
    • A. True
    • B. False
      • Discuss
    • 5. All enterprise resource planning (ERP) systems are heavily dependent on databases to store the data required by the ERP applications.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. An object can have which of the following multiplicities?

    • Options
    • A. Zero
    • B. One
    • C. More than one
    • D. All of the above.
      • Discuss
    • 7. A supertype/subtype hierarchy is which of the following?

    • Options
    • A. Each subtype has only one attribute.
    • B. Each supertype has only one attribute.
    • C. Each subtype has only one supertype.
    • D. Each supertype has only one subtype.
      • Discuss
    • 8. What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?

    • Options
    • A. VARCHAR2
    • B. CHAR
    • C. LONG
    • D. NUMBER
      • Discuss
    • 9. A multidimensional database model is used most often in which of the following models?

    • Options
    • A. Data warehouse
    • B. Relational
    • C. Hierarchical
    • D. Network
      • Discuss
    • 10. Replication should be used when which of the following exist?

    • Options
    • A. When transmission speeds and capacity in a network prohibit frequent refreshing of large tables.
    • B. When using many nodes with different operating systems and DBMSs and database designs.
    • C. The application's data can be somewhat out-of-date.
    • D. All of the above.
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.