908-test1

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

随机练习 自定义设置练习量

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

choose the best answer.
Examine this output:
（含图）
Which change should optimize the number of buffer pool instances for this workload?

choose the best answer.
Examine this parameter setting: audit_log=FORCE_LOG_PERMANENT What effect does this have on auditing?

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?

choose the best answer.

You recently upgraded your MySQL installation to MySQL 8.0. Examine this client error:

ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded:

/usr/local/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

Which option will allow this client to connect to MySQL Server?

Choose the best answer.

Examine this partial output for InnoDB Cluster status:

（含图）

Which statement explains the state of the instance deployed on host2?

Choose the best answer.
Your MySQL environment has asynchronous position based-replication with one master and one slave.
The slave instance had a disk I/O problem, so it was stopped.
You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.
You restart MySQL Server.
How can replication be restored?

Choose the best answer.
Which statement is true about InnoDB persistent index statistics?

Choose the best answer.
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup --optimistic-busy-tables="^finance\. transactions-.*" backup Which optimization process best describes what happens with the redo logs?

choose the best answer.
Examine this snippet from the binary log file named binlog.000036:
（含图）
The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log. Which command will complete the recovery?

choose the best answer.
Four nodes are configured to use circular replication. Examine these configuration parameters for each each node: slave_parallel_type=DATABASE ; slave_parallel_workers=4
Slave_preserve_commit_order=0 Which statement is true?

choose the best answer.
MySQL is installed on a Linux server with this configuration:
[mysqld] user=mysql datadir=/data/mysql
Which method sets the default authentication to SHA-256 hashing for authenticating user account passwords?

choose the best answer.
Examine this command and output:
（含图）
Which statement is true?

Choose the best answer.
Examine these two reports taken 100 seconds apart:
（含图）
Your MySQL system normally supports 50-75 concurrent connections. Which configuration change will improve performance?

Choose the best answer.
MySQL Enterprise Monitor Query Analyzer is configured to monitor an instance. Which statement is true?

Examine this command, which executes successfully:

Mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup- dir=/export/backups backup-and-apply-log

Which statement is true?

choose the best answer
MySQL programs look for option files in standard locations.
Which method will show the option files and the order in which they are read?

choose the best answer
Examine this configuration:
-You have a corporate private network, which uses its own Certificate Authority(CA) using an industry-standard 2048-bit RSA key length.
-All MySQL Server and client certificates are signed using the central corporate CA.
-All clients are known, controlled, and exist only on the private LAN.
-The private net work uses its own private authoritative DNS.
-The private net work also uses other nominal enterprise services.
-An end-to-end encrypted connection for a MySQL client to MySQL server has been established on this LAN.
How does the MySQL Servers' self-signed certificate compare to one that would be signed by a known public, third party trusted Certificate Authority?

choose the best answer
What does the slave I/O thread do ?

choose the best answer
Examine this command, which executes successfully :
Mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-and-apply-log
Which statement is true?

choose the best answer
Examine the full path name of the backup image from MySQL Enterprise Backup with the --compress option:
/backup/full/mybackup/myimage.img
Mysqlbackup.cnf contains this data:
[mysqlbackup]
Backup-dir=/backup/full/myrestore
Backup-image=/back/full/mybackup/myimage.img
Uncompress
You must perform a database restore to a new machine..
Which command can provision the new database in datadir as /data/MEB?

更多题库