Oracle MySQL 8.0 Database Developer 1z0-909 Question # 17 Topic 2 Discussion

Oracle MySQL 8.0 Database Developer 1z0-909 Question # 17 Topic 2 Discussion

1z0-909 Exam Topic 2 Question 17 Discussion:
Question #: 17
Topic #: 2

Which two statements are true about AUTO_INCREMENT?


A.

AUTO_INCREMENT values allocated to a transaction that is rolled back are not reused.


B.

A table can have multiple AUTO_INCREMENT columns.


C.

A server restart always resets the AUTO_INCREMENT value to largest value in the AUTO_INCREMENT column plus 1.


D.

The decimal data type supports AUTO_INCREMENT.


E.

An AUTO_INCREMENT column must be indexed.


Get Premium 1z0-909 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.