ocp-mysql8.0英文版1z0- 908

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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?

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: Master: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaa:1-321, bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbb:1-50, Cccccccc-cccc-cccc-cccc-cccccccccc:1234-1237 Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaa:1-100, bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbb:1-10, cccccccc-cccc-cccc-cccc-cccccccccc:1234-1237 Slave: Gtids_executed: aaaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaa:1-160, cccccccccc-cccc-cccc-cccc-cccccccccc:1234-1237 Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaa:1-70, cccccccccc-cccc-cccc-cccc-cccccccccc:1234-1237 Which statement is true?

You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?

You have an installation of MySQL 8 on Oracle Linux. Consider the outputs: Mysql> SHOW GLOBAL VARIABLES WHERE Variable_name='tmpdir' OR Variable_name='tmp_table_size'; +--------------+-----------+ | Variable_name | Value | +--------------+-----------+ | tmp_table_size | 16777216 | | tmpdir | /tmp | +--------------+-----------+ Shell>cd /var/lib/mysql Shell>ls -1|grep temp Drwxr-x--- 2 mysql mysql 4096 Dec 11 14:05 innodb_temp Which statement is true about disk temporary tables for this installation?

Examine the command, which execute successfully: shell> mysqld --initialize-insecure Which statement is true?

Examine this command: shell> mysqldump --no-create-info --all-databases --result-file=dump.sql Which statement is true?

The mysqld instance has the connection control plugin enabled with these settings: Connection_control_min_connection_delay=1000 Connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively. A command is executed: Mysql> SET GLOBAL connection_control_min_connection_delay=3000; What is the result?

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?

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?

There has been an accidental deletion of data in one of your MySQL databases. You determine that all entries in the binary log file after position 1797 must be replayed. Examine this partial command: mysqlbinlog binlog.000008 --start-position=1798 Which operation will complete the command?

You are using the InnoDB engine and the innodb_file_per_table option is set. You delete a significant number of rows of a large table named FACTORY.INVENTORY. Which command will reorganize the physical storage of table data and associated index data for the INVENTORY table, in order to reduce storage space and improve I/O efficiency?

You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor. Using Query Analyzer, where do you begin to look for problem queries?

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/mystore 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?

You encountered an insufficient privilege error in the middle of a long transaction. The database administrator is informed and immediately grants the required privilege: GRANT UPDATE ON world.city TO 'user1'; How can you proceed with your transaction with the least interruption?

You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

Your my.cnf file contains these settings: [mysqld] log_output=FILE slow_query_log long_query_time=2.01 log_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?

What is the correct syntax for using transparent data encryption with an existing InnoDB table?

Examine these statements and output: Mysql> GRANT PROXY ON accounting@localhost TO ' ' '@' '%'; Mysql> SELECT USER(),CURRENT_USER(),@@PROXY_USER; +--------------+---------------+------------------+ |USER() |CURRENT_USER() |@@proxy_user| +--------------+---------------+------------------+ |jsmith@localhost|accounting@localhost|' ' '@' '%| +--------------+---------------+------------------+ Which statement is true?

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

You want to dump all databases with names that start with "db". Which command will achieve this?