1Z1-888 試験問題を無料オンラインアクセス

You have installed MySQL on Oracle Linux 7 using the official RPM distribution, and SELinux is set to
"permissive".
Examine this extract of the my.cnf file:

You issue this command to start MySQL Server:
systemctl start mysqld@replica
On which port is the server listening?

• A.3304
• B.3303
• C.3301
• D.3302

You are investigating the performance of the server and see this information:
* events_waits_summary_global_by_event_namein the Performance Schema shows that the wait/synch/mutex/sql/LOCK_table_cacheevent is dominating other wait events.
* The Table_open_cache_overflowsstatus variable is 0.
Which action should be taken to remove the performance bottleneck described here?

• A.Decrease the value of table_open_cache instances.
• B.Decrease the value of table_definition_cache.
• C.Increase the value of table_definition_cache.
• D.Increase the value of table_open_cache_instances.
• E.Decrease the value of table_open_cache.
• F.Increase the value of table_open_cache.

The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a / backuppartition available on NFS where backups are stored.
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

• A.Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
  
• B.Take a backup, stop the server, remove the data files, and restore the backup:
  
• C.Execute OPTIMIZE TABLEso that the InnoDB engine frees unused pages on disk back to the file system:
  
• D.Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
  

You are installing MySQL Server 5.7 from a tarball package. You have already set up the correct PATH environment variable and configured your /etc/my.cnf file.
Which command will correctly prepare a data directory?

• A.service mysqld prepare-init
• B.mysqld_safe --user=mysql
• C.mysqld --initialize ...
• D.mysqld_safe --initialize ...
• E.mysql -u root -p < support-files/mysqldb.sql

You want to create the first configuration file for a new installation of MySQL.
- You will start mysqldmanually (not automate it to start when the host machine starts or execute as a service).
- You will stop mysqldusing mysqladmin.
- You will interact with mysqldby using only the command-line client mysql.
Which option identifies a maximal set of sections where you can put the "max_allowed_packet=16M" parameter without creating a problem?

• A.[mysql] and [mysqld]
• B.[mysqladmin]
• C.[mysql] and [mysqladmin]
• D.[mysqld] and [mysqladmin]
• E.[mysql] and [mysqld] and [mysqladmin]
• F.[mysqld]
• G.[mysql]