Oracle Exam 1Z0-888 Topic 5 Question 29 Discussion

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

Question #: 29
Topic #: 5

[All 1Z0-888 Questions]

Consider the CHECK TABLE command.

In which two situations should this command be used? (Choose two.)

Ato find out why a query takes a long time to execute on a given table

Bto make sure a table has no structural problems

Cto improve performance by updating index distributing statistics on InnoDB tables

Dto repair table structure problem

Eto make sure that no table indexes are corrupted

Show Suggested Answer

Suggested Answer: B, E

The CHECK TABLE statement performs an integrity check on table structure and contents. It works for MyISAM and InnoDB tables. For MyISAM tables, it also updates the index statistics. If the table is a view, CHECK TABLE verifies the view definition. If the output from CHECK TABLE indicates that a table has problems, the table should be repaired.

by Bette at May 05, 2022, 01:12 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

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