Sun-Certified-MySQL-Associate-(310-814).pdf - SUN 310-814 Sun Certified MySQL Associate http\/killexams.com\/exam-detail\/310-814 QUESTION 227 Which of the

Sun-Certified-MySQL-Associate-(310-814).pdf - SUN 310-814...

This preview shows page 1 - 4 out of 7 pages.

310-814 SUN Sun Certified MySQL Associate
Image of page 1
QUESTION: 227 Which of the following functions is used to determine whether a value is odd or even? A. TRIM B. MOD C. ROUND D. TRUNC Answer: B QUESTION: 228 Which of the following CANNOT be committed? A. GRANT B. CURRENT LOCK TIMEOUT C. ALTER D. LOCK TABLE Answer: B QUESTION: 229 Which of the following comprises a unit of work performed within a database management system? A. Atomicity B. Consistency C. Database transaction D. Isolation Answer: C QUESTION: 230 Which of the following options executes when BEGIN TRANS operator is called? 86
Image of page 2
A. Consistency B. Isolation C. Atomicity D. Transaction Answer: D QUESTION: 231 Which of the following is an operation that returns the database to some previous state? A. Return B. Begin transaction C. Rollback D. Commit Answer: C QUESTION: 232 Which of the following is based on the ACID properties? A. Database transaction B. Database security C. Database authentication D. Database concurrency control Answer: A QUESTION: 233 Which of the following statements is used to insert, update, or delete bulk data?
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 7 pages?

  • Fall '20
  • Database transaction, following functions, A. Atomicity, a. SAVEPOINT

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture