mysql ocp考试

Examine this list of MySQL data directory binary 

logs:binlog.000001binlog.000002.......binlog.000289 binlog.000300 binlog.000301 binlog.index Now examine this 

command, which executes successfully 

mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql 

Which two are true? 

You want to install and configure MySQL on Linux server with tarball binaries in the /app/mysql/directory, 

where the bin directory is found at 1 app/mysql/bin and the data directory at /app/data. 

Which two parameters are required to configure the MySQL instance?

A valid raw backup of the shop . customers MyISAM table was taken.You must restore the table.You 

begin with these steps: 

1. Confirm that secure_file_priv=' /var/ tmp' 

2. mysql>DROP TABLE shop. customers; 

3. shell>cp /backup/ customers.MY* /var/ lib/mysql/ shop/ 

Which two actions are required to complete the restore?

.You are investigating performance problems in a MySQL database; all data fits in memory. You 

determine that SELECT queries to one table is the main cause for poor response times. 

Which two have the biggest potential for eliminating the problem?

You have semi-synchronous replication configured and working with one slave. rpl_semi_sync_master_timeout has never been reached.You find that the disk system on the master has failed and 

as a result, the data on the master is completely unrecoverable. 

Which two statements are true?

You are considering using file-system snapshots to back up MySQL. 

Which three statements are true? 

Which two commands will display indexes on the parts table in the manufacturing schema? 

 What are two major concerns of running an installation with incorrect file privileges? 

Which three requirements must be enabled for group replication? 

You are attempting to start your mysqld. Examine this log output: 

2019-12-12T22:21:40:353800z 0 System DCY-010116 Server /mysql/bin/mysqld mysld 8.0.18-comnercial starting as process 29740 

2019-12-12T22:21:40:458802z 1 ERROR DCY-012592 InnoDB Operating system error number 2 in a file operation. 

2019-12-12T22:21:40:459259z 1 ERROR DCY-012593 InnoDB The error means the system cannot find the patj specified. 

2019-12-12T22:21:40:459423z 1 ERROR DCY-012594 InnoDBIf you are installing InnoDB,remember that must create directories yourself ,InnoDB does not create them. 

2019-12-12T22:21:40:459606z 1 ERROR DCY-012646 InnoDB File ./ibdatali ‘open’returned os error 71.Cannot continue operation. 

2019-12-12T22:21:40:459891z 1 ERROR DCY-012981 InnoDB Cannot continue operation. 

Which two things must you check? 

Which three requirements must be enabled for group replication? 

Choose two Which two statements are true about raw binary backups?

Which two methods can be used to determine whether a query uses the hash join algorithm? 

You have an InnoDB Cluster configured with three servers. Examine this command, which executes successfully: 

mysqldump -uroot -p -d mydatabase >mydatabase_backup.sql 

Due to data loss, the cluster is initialized and a restore is attempted resulting in this error: 

ERROR 13176 (HY000) at line 23:Cannot update GTID_PURGED with the Group Replication plugin running 

Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? 

Which three are types of InnoDB tablespaces? 

Examine this statement and output: 

mysql> SELECT ROW_NUMBER() OVER() AS QN,query, exec_count, avg_latency, lock_latency 

FROM sys.statement_analysis ORDER BY exec_count;（见下图）。 

You must try to reduce query execution time. 

Which two queries should you focus on?

（含图）

You are asked to review possible options for a new MySQL instance. It will be a large, busy 

reporting data warehousing instance.mysql innodb_data_file_path= 

Which two configurations would satisfy long-term storage demands?

An existing asynchronous replication setup is running MySQL 8. 

Which two steps are a part of implementing GTID replication? 

You plan to install MySQL Server by using the RPM download.

Which two statements are true? 

Which four connection methods can MySQL clients specify with the --protocol option when 

connecting to a MySQL server?