oooppp_在线真题试卷与模拟练习_oooppp

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

A developer accidentally dropped the InnoDB table Customers from the Company database. There is a datadir copy from two days ago in the dbbackup directory. Which set of steps would restore only the missing table?

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=/backup/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?

Which are three benefits of using mysqlbackup instead of mysqldump?

Examine this command,which executes successfully: ＄mysqlbackup --user=dba --password --port=3306-with-timestamp-only-knowfile-types-backup-dir=/exprot/backups backup Which statement is true?

Which two statements are true about MySQL Enterprise Backup?

You are backing up raw InnoDB files by using mysqlbackup. Which two groups of files will be backed up during a fullbackup?(Choose two.)

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 transactionsThese 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?

Which two are use cases of MySQL asynchronous replication?(Choose two.)

Which two are true about binary logs used in asynchronous replication?

Which three requirements must be enabled for group replication?

Which two statements are true about MySQL server multi-source replication?

You issue this command:SHOW SLAVE STATUS\G In the output,there is a value for Seconds_behind_master. How is this time calculated?

The replication for master and slave MySQL Servers is up and running.The disk space occupied by the binary log files ontinues to grow. Which two methods manage this issue?

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?

What does the slave I/O thread do?

You reconfigure and start a slave that was not replicating for several days.The configuration file and CHANGE MASTER command are correct.Examine the GTIDinformation from both master and slave

Master:

Gtids_executed：aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa：1-321,

Bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50,

Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100,

Bbbbbbbb-bbbb-bbbb-lblolo-bbbbbbbbbbbb:1-10,

Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Slave:

Gtids_executed:aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160,

Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Gtids_purged:

Aaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70,

Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Which statement is true?

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?

Examine the modified output: Mysql>SHOW SLAVE STATUS\G ∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗ 1.row ∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗∗ Slave_IO_Running:Yes Slave_SQL_Running:Yes Seconds_Behind_Master:1612 Seconds_Behind_Master value is steadily growing. What are two possible causes?(Choose two.)

You have an installation of MySQL 8 on Oracle Linux.Consider the outputs:

Mysql＞SHOW GLOBAL VARIABLEG

WHERE Variable_name m “tempdir”

OR Variable_name m “tem_table_size”

Variable_name Value

tem_table_size tepdir 16777216/tem

2 rown in set (0.01 nec)

Shell＞cd/var/lib/mysql

Shell＞1e-1丨grep temp

Drwxr-x---,2 mysql mysql 4096 Dec 11 14:05 finnodb_temp

Which statement is true about disk temporary tables for this installation?

1 2 3 4 5 6 10

更多题库