Oracle Exam 1Z0-909 Topic 8 Question 46 Discussion

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

Question #: 46
Topic #: 8

[All 1Z0-909 Questions]

Which two statements are true about AUTO_INCREMENT?

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

BA table can have multiple AUTO_INCREMENT columns.

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

DThe decimal data type supports AUTO_INCREMENT.

EAn AUTO_INCREMENT column must be indexed.

Show Suggested Answer

Suggested Answer: A, B

by Naomi at Sep 08, 2024, 08:41 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

11 days ago

I'm pretty sure you can't have multiple AUTO_INCREMENT columns in a table. That would just be confusing!

upvoted 0 times

...

12 days ago

D is definitely not true. AUTO_INCREMENT only works with integer data types, not decimal.

upvoted 0 times

...

14 days ago

I believe statement E is also true because an AUTO_INCREMENT column must be indexed for it to work properly.

upvoted 0 times

...

15 days ago

I agree with Chau. Having multiple AUTO_INCREMENT columns in a table is possible.

upvoted 0 times

...

21 days ago

A and E seem to be the correct answers. AUTO_INCREMENT values are not reused, and the column must be indexed.

upvoted 0 times

...

27 days ago

I think statement B is true because I have seen tables with multiple AUTO_INCREMENT columns.

upvoted 0 times

...