310-814 SUN Sun Certified MySQL Associate
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
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?
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