Exam 1z0-908 topic 1 question 75 discussion

Actual exam question from Oracle's 1z0-908

Question #: 75
Topic #: 1

Your MySQL server was upgraded from an earlier major version.
The sales database contains three tables, one of which is the transactions table, which has 4 million rows.
You are running low on disk space on the datadir partition and begin to investigate.
Examine these commands and output:

Which two statements are true? (Choose two.)

A. Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions will free up disk space.
B. Executing ALTER TABLE transactions will enable you to free up disk space.
C. Truncating the sales and leads table will free up disk space.
D. Truncating the transactions table will free up the most disk space.
E. The transactions table was created with innodb_file_per_table=OFF.

Show Suggested Answer

Suggested Answer: AE 🗳️

by Dhanushka at July 31, 2023, 3:23 p.m.

Comments

Submit Cancel

LrnsTgh

12 months ago

is it AE or CE? is it crazy to truncate sales data?

upvoted 1 times

...

marklv

1 year, 4 months ago

If was E was true, the individual tables, wouldn't exist, and empty database on disk would, it is wrong.

upvoted 1 times

marklv

1 year, 4 months ago

A and C. compresion will most likely work. truncate will work because truncate now drops and adds the table.

upvoted 1 times

marklv

1 year, 3 months ago

It is C and E. the transactions table doesn't have its own data file, so it uses the general tablespace. truncate won't free up space. Is was created when the variable was OFF. Ignore my other comments.

upvoted 1 times

...

Dhanushka

1 year, 5 months ago

Selected Answer: CE

Row compress may not shrink down ibdata file

upvoted 2 times

avrely

5 months, 2 weeks ago

shrinking of system tablespace is not supported at all

upvoted 1 times

...