Oracle
1Z0-908 · Question #36
1Z0-908 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-908 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Advanced Features
Question
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.)
Exhibit
Options
- AExecuting SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE
- BExecuting ALTER TABLE transactions will enable you to free up disk space.
- CTruncating the sales and leads table will free up disk space.
- DTruncating the transactions table will free up the most disk space.
- EThe transactions table was created with innodb_file_per_table=OFF.
Unlock 1Z0-908 to see the answer
You've previewed enough free 1Z0-908 questions. Unlock 1Z0-908 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#InnoDB Compression#innodb_row_format#innodb_file_per_table#Disk Space Management