默认题库 - 1z0-883

多选题

What are three facts about backups with mysqldump?（）

A. Can back up a remote database server
B. Allow a consistent backup to be taken
C. Are always faster to restore than binary backups
D. Are able to back up specific items within a database
E. Create automatically compressed backups
F. Will lock all storage engines for duration of backu

查看答案

单选题

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）

A. MySQL Replication
B. Distributed Replication Block Device
C. Windows Server Failover Clustering
D. MySQL Cluster

查看答案

单选题

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）

A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
D. STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

查看答案

单选题

You want a record of all queries that are not using indexes. How would you achieve this?（）

A. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
By enabling the Error Log because not using indexes is an error
C. By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D. By enabling the Error Log and using the – log-queries-not-using-indexes optio

查看答案

单选题

Which hardware storage option, when set up with redundant disks, offers the least stability,availability, and reliability for Mysql data?（）

A. RAID 5
B. iSCSI
C. SAN (Storage Area Network)
D. NFS (Networked File System)

查看答案

多选题

The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）

A primary key must exist for creation of a clustered index
B. A clustered index allows fulltext searching within InnoDB
C. The first unique index is always used as a clustered index and not a primary key
D. A clustered index provides direct access to a page containing row data
E. If no indexes exist, a hidden clustered index is generated based on row IDs
F. A primary key is used as a clustered index
G. A clustered index is a grouping of indexes from different tables into a global index for faster searching

查看答案

多选题

What are three actions performed by the mysql_secure_installation tool?（）

A. It prompts you to set the root user account password
B. It checks whether file permissions are appropriate within datadir
C. It asks to remove the test database, which is generated at installation time
D. It can delete any anonymous accounts
E. It verifies that all users are configuration with the longer password hash

查看答案

单选题

Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）

A. Start the server with the – innodb_recover_options option set to FORCE
B. Start the server with the – innodb_force_recovery option set to a non-zero value
C. Start the server as usual, and then execute the REPAIR TABLE command
D. Start the server as usual, and then execute the CHECK TABLE command

查看答案

多选题

Consider the events_% tables in performance Schema. Which two methods will clear or reset the collected events in the tables?（）

A. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B. Using the statement RESET PERFORMANCE CACHE
C. Using the statement FLUSH PERFORMANCE CACHE
D. Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E. Disabling and re-enabling all instruments
F. Restarting Mysql

查看答案

单选题

You are investigating the performance of the server and see the following information: Events_waits_summary_global_by_event_name in the performance schema shows that the wait/synch/mutex/sql/LOCK_table_cache event is dominating other wait events. The table_open_cache_overflows status variable is 0. Which action should be taken to remove the performance bottleneck described here?（）

A. Increase the value of table_definition_cache
B. Increase the value of table_open_cache_instances
C. Decrease the value of table_open_cache_instances
D. Increase the value of table_open_cache
E. Decrease the value of table_definition_cache
F. Decrease the value of table_open_cache

查看答案