1Z0-888 Real Exam Questions

One of your colleagues is trying to make a change using the mysql command-line client for his or her application session: mysql> SET SESSION max_connections = 200; Why does the command fail?

Which statement describes how the relay log works?

A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the reverts takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

You are asked to examine user accounts and find: ``` mysql> select user,host,plugin,authentication_string from user; +------------------+-----------------------------+-----------------------+-------------------------------------------+ | user | host | plugin | authentication_string | +------------------+-----------------------------+-----------------------+-------------------------------------------+ | root | localhost | mysql_native_password | *2470CCD6EDEF42FD1618B899005ADCA2EDD1E19 | | bob | % | mysql_native_password | | | | localhost | mysql_native_password | *2DCA2EC9D470CE42FD1618B899005ADCA215B899 | +------------------+-----------------------------+-----------------------+-------------------------------------------+ 10 rows in set (0.01 sec) ``` Which two statements will best secure this environment? (Choose two.)

The 'applicationdb' 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 this 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> ls -l /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdatal -rw-rw---- 1 mysql mysql 480M Aug 26 13:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 13:47 ib_logfile1 ... You attempt to free space from ibdatal by taking a mysqldump of the data_archive table and storing it on your backup partition. shell> mysqldump -u root -p applicationdb data_archive > /backup/data_archive.sql mysql> DROP TABLE data_archive; 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?