Exam 1z0-908 topic 1 question 48 discussion

Actual exam question from Oracle's 1z0-908

Question #: 48
Topic #: 1

t is a non-empty InnoDB table.
Examine these statements, which are executed in one session:
BEGIN;
SELECT * FROM t FOR UPDATE;
Which is true?

A. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.
B. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.
C. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.
D. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

Show Suggested Answer

Suggested Answer: C 🗳️

by marklv at Sept. 2, 2023, 1:24 a.m.

Submit Cancel

1 year ago

Selected Answer: C

The right answer is C

upvoted 1 times

...

1 year, 1 month ago

Selected Answer: C

C is right

upvoted 2 times

...

1 year, 5 months ago

B is not right. D is. It locks until the first connection is done.

upvoted 2 times

6 months, 3 weeks ago

Sorry, if same session, D will not lock. D isn't right either

upvoted 1 times

...