MySQL 5.6高可用性选项及存储引擎监控问题分析

mysql;ocp

需积分: 9 26 浏览量更新于2024-07-18 收藏 6.99MB DOC 举报

身份认证购VIP最低享 7 折!

30元优惠券

资源详情

资源推荐

The safer , easier way to help you pass any IT exams.

A client connection is established with the username mike from the host db.example.com. However,

when trying to execute queries, it is found that the privileges are insufficient.

You investigate further by executing the command:

mysql> SELECT CURRENT_USER();

What is the name returned from the executed command?

A. ‘mike’ 0 ‘localhost’

B. ‘mike’ 0 ‘&’

C. ‘mike’ 0 ‘db.example.com’

D. ‘ ’ 0 ’db.example.com’

Answer:C

10.How does the InnoDB storage engine handle deadlocks when they are detected?

A. The affected transactions wait for inodb_lock_wait_timeout seconds, and then roll back.

B. The transaction isolation level determines which transaction is rolled back.

C. One of the affected transactions will be rolled back, the other is allowed to proceed.

D. Both the affected transactions will be rolled back.

E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

Answer:A

11.In a test database, you issue the SELECT ... INTO OUTFLLE statement to create a file with your t1

table data.

You then TRUNCATE this table to empty it.

mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;

mysql> TRUNCATE t1;

Which two methods will restore data to the t1 table?

A. mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;

B. $ mysqladmin -u root -p -h locathost test --restore /tmp/t1.sql

C. $ mysql -u root -p -h localhost test < /tmp/t1.sql

D. $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl

E. mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;

Answer:AD

12.You need to replicate a table from a master to a slave. The master and slave copies of the table will

have different numbers of columns.

6 / 31

The safer , easier way to help you pass any IT exams.

Which two conditions must be true?

A. Each extra column in the copy with more columns must not have a default value.

B. Columns that are common to both versions of the table must be defined in the same order on the

master and the slave.

C. The slave database cannot have more columns than the master. Only the master database can have

more columns.

D. Columns that are common to both versions of the table must come first in the table definition, before

any additional columns are defined on either server.

E. The master database cannot have more columns than the slave. Only the slave database can have

more columns.

Answer:BD

13.You want to upgrade the MySQL Server.

In which two cases would you not use a binary backup?

A. when you upgrade skipping a major version, for example, from 5.0 to 5.6

B. when you upgrade between major versions, for example from 5.5 to 5.6

C. when the Release Notes indicate either a data or index format between versions was changed

D. when the Release Notes indicate that functionality between versions was changed

E. when the Release Notes Indicate that syntax between versions was changed

Answer:AC

14.The MySQL user ‘adam’ currently has USAGE permissions to the database.

The football database is transactional and has non-stop updates from application users The ‘adam’ user

needs to be able to take consistent backups of the football database by using the -- single-transaction

option.

Which extra GRANT permissions are required for adam to take mysqldump backups?

A. The ‘adam’ user must also have SINGLE TRANSACTION global grant to take a consistent backup.

B. The ‘adam’ user must have the SUPER privilege in order to take data backups.

C. The ‘adam’ user must also have SELECT on the football database for backups to work.

D. The ‘adam’ user needs the PROCESS privilege to be able to take a consistent backup while other

users are connected.

Answer:B

15.Which statement true about the FLUSH LOGS command?

A. It requires the RELOAD, FILE, and DROP privileges.

B. It closes and reopens all log files.

C. It closes and sends binary log files to slave servers.

D. It flushes dirty pages in the buffer pool to the logs.

Answer:B

16.You need to dump the data from the master server and import it into a new slave server.

Which mysqldump option can be used when dumping data from the master server In order to include the

master server’s binary log information?

A. include-master-info

7 / 31

剩余30页未读，继续阅读

doireann

粉丝: 0
资源: 1

MySQL 5.6高可用性选项及存储引擎监控问题分析

MYSQL OCP题库（2018.4.2更新）

MySQL 1z0-883 题库demo

花5百购买的mysql ocp认证IZO-883 考试题库 准确率达到百分之八九十

MySQL OCP 1z0-883_112真题整理

修正版Oracle 1z0-883 Mysql OCP考试题库解析

1z0-888 MYSQL5.7 OCP

mysql5.6ocp 1z0-883.docx

MySQL OCP 1z0-883 真题解析与备考指南

MySQL OCP认证1Z0-883试题解析与定制设置检测

MySQL 5.6 OCP 1Z0-883：解决 Slave 错误与重置GTID策略

Oracle 1z0-888: MySQL 5.7 OCP认证考试指南

MySQL 8.0 OCP 1Z0-908 题库

mysql5.7ocp-1z0-888-19年5月最新题库.docx

最新ORACLE OCA&OCP 题库 1z0-007 1Z0-042 1Z0-043

MySQL OCP 8.0 1Z0-908题库

MySQL 5.7 OCP（1Z0-888）题库测试及答案.rar

MySQL 8.0 OCP 1Z0-908认证考试题库详解与答案

"MySQL 8.0 OCP 1Z0-908考试题库备份与恢复命令解析

mysql 8 ocp 1z0-908 题库

最新资源

花5百购买的mysql ocp认证IZO-883 考试题库准确率达到百分之八九十