Oracle Exam 1Z0-883 Topic 5 Question 3 Discussion

Actual exam question for Oracle's 1Z0-883 exam

Question #: 3
Topic #: 5

Which two statements are true about InnoDB auto-increment locking?

AThe auto-increment lock can be a table-level lock.

BInnoDB never uses table-level locks.

CSome settings for innodb_autoinc_lock_mode can help reduce locking.

DInnoDB always protects auto-increment updates with a table-level lock.

EInnoDB does not use locks to enforce auto-increment uniqueness.

Show Suggested Answer

Suggested Answer: A

http://dev.mysql.com/doc/refman/5.6/en/innodb-auto-increment-configurable.html

by Penney at May 05, 2022, 07:17 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!