Oracle
1Z0-883 · Question #23
1Z0-883 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-883 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Question
The `allplicationdb' is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored. You investigate and gather the following information: [mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0 Three tables are stored in the innoDB shared tablespace and the details are as follows: - The table data_current has 1,000,000 rows. - The table data_reports has 1,500,000 rows. - The table data_archive has 4,500,000 rows. Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ... You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition. Shell> mysqldump u root p applicationdb data_archive > /backup/data_archive.sql \Mysql> DROP TABLE data_archive; Which set of actions will allow you to free disk space back to the file system?
Options
- AExecute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the
- BSet the server to use its own tablespace, and then alter the table so that data is moved from the
- CTake a backup, stop the server, remove the data files, and restore the backup:
- DEnable compression on the table, causing InnoDB to release unused pages on disk to the file system:
Unlock 1Z0-883 to see the answer
You've previewed enough free 1Z0-883 questions. Unlock 1Z0-883 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.