mysql ocp考试

You plan to take daily full backups, which include the ndbinfo and sys (internal) 

databases.Which command will back up the databases in parallel?

mysqlbackup --user=dba --password --port=3306 --with-timestamp 

 --backup-dir=/export/backups backup-and-apply-log

Which statement is true?

Database test contains a table named city that has the InnoDB storage engine.（见下图） 

What is the content of the test folder in the data directory?

（含图）

Choose the best answer. 

Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@ 

hostname :port --directory=directory_path 

Which activity is performed?

You issue this command: SHOW SLAVE STATUS 

In the output, there is a value for seconds_behind_master. How is this time calculated?

Which command enables rule -based MySQL Auditing capabilities?

Consider this shell output and executed commands: root@oel7 ~# ps aux I grep 

mysqld mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid 

root@oel7 ~ # kill -15 2076 

Which statement is true about MySQL server shutdown?

 Binary log events for the 'mydb1' schema must be copied to a different schema name 'mydb2'. 

Which command will do this?

Choose the best answer.Examine these entries from the general query log:（见下图）All UPDATE 

statements reference existing rows. 

Which describes the outcome of the sequence of statements?

（含图）

 You reconfigure and start a slave that was not replicating for several days.The configuration file 

and CHANGE MASTER command are correct.Examine the GTID information from both master and 

slave:（见下图）Which statement is true?

（含图）

Examine this command, which executes successfully: 

mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back. 

Which statement is true about the copy-back process?

Choose the best answer. Your my.cnf file contains these settings:mysqld log_output=FILE 

slow_query_log long_query_time=2.01log_queries_not_using_indexes 

You want to log queries that looked at a minimum of 5000 records and either took longer than 5 

seconds to run or did not use indexes.

Which contains all the settings that you need to add to or modify the slow log configuration?

Choose the best answer.Consider this shell output and executed commands:root@oel7~ # ps aux 

grep mysqldmysql 2076 3.5 24.6 1386852 372572 2 Ssl 12:01 0:01 /usr/sbin/mysqldroot@oel7 ~# 

kill -15 2076 

Which statement is true about MySQL server shutdown?

backups. You use a mix of MyISAM and InnoDB storage engines for your data.Examine your backup 

requirements:·The MySQL system being backed up can never be unavailable or locked to the client 

applications.·The recovery from the backup must work on any system.·Only 1 hour of data can be 

lost on recovery of the backup. 

 Which option fulfills all backup requirements?

Which statement is true about InnoDB persistent index statistics?

Which step or set of steps can be used to rotate the error log?

You are using an existing server with a new configuration. MySQL Server fails to start. Examine 

this snapshot of the error log: 

190925 12:49:05 InnoDB:Initializing buffer pool, size = 3.0G 

190925 12:49:05 InnoDB:Completed initialization of buffer pool 

InnoDB:Error:log file ./ib_logfile0 is of different size 0 5242880 bytes 

InnoDB:than specified in the .cnf file 0 26214400 bytes! 

190925 12:49:05 ERROR Plugin 'InnoDB' init function returned error . 

190925 12:49:05 ERROR Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 

190925 12:49:05 ERROR Aborting 

190925 12:49:05 Note /usr/sbin/mysqld:Shutdown complete 

 Which action would allow the server to start?

Which characters are most commonly used in a SQL injection attack?

Examine these commands, which execute successfully on the ic1 host: 

mysqlsh> dba.createCluster( 'cluster1' , memberWeight:35) 

mysqlsh> var mycluster = dba.getCluster () 

mysqlsh> mycluster.addInstance ( 'ic@ic2' , memberWeight:25) 

mysqlsh> mycluster.addInstance( 'ic@ic3' , memberWeight:50) 

Now examine this configuration setting, which is the same on all nodes:group_replication_ 

consistency=BEFORE_ON_PRIMARY_FAILOVER 

Which statement is true if primary node ic1 fails?

You execute this command:shell>mysqlpump --exclude-databases=% --users 

Which statement is true?