Free 1z0-888 Exam Braindumps

You have just executed a manual backup by using this command:

mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup

The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

  1. Backup State = Compressed Backup Operation = copy-back
  2. Backup State = Raw Backup Operation = apply-log
  3. Backup State = Prepared Backup Operation = validate
  4. Backup State = Prepared Backup Operation = apply-log
  5. Backup State = Raw Backup Operation = backupdir-to-image

Answer(s): E



Where does MySQL Linux RPM install the mysqld binary?

  1. /usr/libexec/
  2. /usr/local/mysql/bin/
  3. /usr/sbin/
  4. /usr/bin/
  5. /opt/mysql/server/bin/

Answer(s): C


Reference:

https://dev.mysql.com/doc/refman/8.0/en/linux-installation-rpm.html



Which two methods will provide the total number of partitions on a table? (Choose two.)

  1. Query the INFORMATION_SCHEMPARTITIONS table
  2. Use the command: SHOW TABLE STATUS
  3. Query the performance_schema.objects_summary_global_by_type table
  4. Query the INFORMATION_SCHEMA.TABLES table for the partition_count
  5. Use the command: SHOW CREATE TABLE

Answer(s): A,B


Reference:

https://dev.mysql.com/doc/refman/5.7/en/partitions-table.html https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html



Which statement is correct about how InnoDB storage engine uses disk space?

  1. It stores data in .MYD files and its index and undo information in the common tablespace.
  2. It stores data in .MYD files, index information in .MYI files, and undo information in the common tablespace.
  3. It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.
  4. It stores its data, index and undo information in .MYD and .MYI files.
  5. It stores data, index and undo information in tablespace file(s).

Answer(s): E



Which statement is true about tablespaces?

  1. All tablespace files must be in the directory specified by the –-datadir option.
  2. General tablespaces can be configured to span multiple files.
  3. All tables must be in either the system tablespace or a general tablespace.
  4. The system tablespace can be configured to span multiple files.

Answer(s): C


Reference:

https://dev.mysql.com/doc/refman/8.0/en/general-tablespaces.html