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

Get Premium 1Z0-909 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lashawnda

1 months ago

Wait, so does the AUTO_INCREMENT value automatically increment my salary too? Asking for a friend.

upvoted 0 times

Jesus

17 days ago

E) An AUTO_INCREMENT column must be indexed.

upvoted 0 times

...

Rosann

18 days ago

B) A table can have multiple AUTO_INCREMENT columns.

upvoted 0 times

...

Arthur

20 days ago

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

upvoted 0 times

...

Paola

2 months ago

C is tricky. I heard that the AUTO_INCREMENT value is reset to 1 after a server restart, not the largest value plus 1. But I could be wrong.

upvoted 0 times

Joesph

16 days ago

I'm pretty sure it's A and E that are true.

upvoted 0 times

...

Donette

17 days ago

I believe B and E are the correct statements.

upvoted 0 times

...

Lindsey

1 months ago

I think A and E are true about AUTO_INCREMENT.

upvoted 0 times

...

Jestine

2 months ago

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

upvoted 0 times

Tammy

4 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

...

Nana

11 days ago

E) An AUTO_INCREMENT column must be indexed.

upvoted 0 times

...

Darnell

17 days ago

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

upvoted 0 times

...

Nobuko

2 months ago

E) An AUTO_INCREMENT column must be indexed.

upvoted 0 times

...

Art

2 months ago

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

upvoted 0 times

...

Franklyn

2 months ago

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

upvoted 0 times

...

Tamera

2 months ago

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

upvoted 0 times

...

Martina

2 months ago

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

upvoted 0 times

...

Terina

2 months 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

Helga

1 months ago

That's right, A and E are the correct statements.

upvoted 0 times

...

Kaycee

1 months ago

And an AUTO_INCREMENT column must be indexed.

upvoted 0 times

...

Rozella

1 months ago

Yes, AUTO_INCREMENT values are not reused.

upvoted 0 times

...

Cordelia

2 months ago

I think A and E are correct.

upvoted 0 times

...

Chau

3 months ago

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

upvoted 0 times

...