5 years ago in JDBC

What MySQL property is used to create a surrogate key in MySQL?

A. UNIQUE
B. SEQUENCE
C. AUTO_INCREMENT
D. None of the above -- Surrogate keys are not implemented in MySQL.

[A] UNIQUE
[B] SEQUENCE
[C] AUTO_INCREMENT
[D] None of the above -- Surrogate keys are not implemented in MySQL.
Loading...
Next Question

Overall Stats

Attempted 612
Correct 145
Incorrect 169
Viewed 298

Answers

Guest
Guest
Shamsa hafeez
Shamsa hafeez - 1 week ago

Shamsa hafeez from Lahore, Pakistan is saying None of the above -- Surrogate keys are not implemented in MySQL. is correct answer

Sailaja
Sailaja - 2 weeks ago

Sailaja from Surat, India is saying None of the above -- Surrogate keys are not implemented in MySQL. is correct answer

Sagar Gawari
Sagar Gawari - 1 month ago

Sagar Gawari from Pune, India is saying AUTO_INCREMENT is correct answer

komal badhe
komal badhe - 1 month ago

komal badhe from Pune, India is saying AUTO_INCREMENT is correct answer

Zo Go
Zo Go - 1 month ago

Zo Go from Casablanca, Morocco is saying SEQUENCE is correct answer

Related Questions

Which type of Statement can execute parameterized queries?

  • [A] PreparedStatement
  • [B] ParameterizedStatement
  • [C] ParameterizedStatement and CallableStatement
  • [D] All kinds of Statements

Which of the following allows non repeatable read in JDBC Connection?

  • [A] TRANSACTION_READ_UNCOMMITTED
  • [B] TRANSACTION_READ_COMMITTED
  • [C] TRANSACTION_SERIALIZABLE
  • [D] TRANSACTION_REPEATABLE_READ

What happens if you call deleteRow() on a ResultSet object?

  • [A] The row you are positioned on is deleted from the ResultSet, but not from the database.
  • [B] The row you are positioned on is deleted from the ResultSet and from the database
  • [C] The result depends on whether the property synchronizeWithDataSource is set to true or false
  • [D] You will get a compile error: the method does not exist because you can not delete rows from a ResultSet

Which packages contain the JDBC classes?

  • [A] java.jdbc and javax.jdbc
  • [B] java.jdbc and java.jdbc.sql
  • [C] java.sql and javax.sql
  • [D] java.rdb and javax.rdb