Oracle Exam 1Z0-920 Topic 8 Question 27 Discussion

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

Question #: 27
Topic #: 8

You are using the innoDB engine and the innodb_f ile_per_table option is set.

You delete a significant number of rows of a large table named inventory and issue the command optimize table inventory.

What will happen to the inventory table?

AThe table will be optimized and replicated.

BThe table will be checked for errors and repaired.

CThe table storage space will be reduced.

DThe table statistics will be stored.

Show Suggested Answer

Suggested Answer: A

by Brandon at May 09, 2022, 04:43 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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