站内搜索
1z0-883 问题列表
问题
多选题You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）AUse the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused filesBExecute the PURGE BINARY LOGE NOT USED commandCRemove all of the binary log files that have a modification date earlier than todayDEdit the .index file to remove the files you want to deleteEEnsure that none of the attached slaves are using any of the binary logs you want to delete
问题
多选题When backing up a replication slave, which three should also be backed up in addition to data?（）AThe master.info and relay.info filesBThe relay log filesCThe relay index fileDMysql.slave_master_info tableEMysql.slave_relay_log_info tableFMysql.slave_worker_info table
问题
多选题Which three data components are needed for point-in-time recovery?（）AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files
问题
单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）A
It exports tables with the most indexes first to assist with import speedsB
It ensures that unique indexes have no conflicts when the data is dumpedC
It orders by primary key to assist in speeding up importing to InnoDB tablesD
It must be specified so index data is dumped correctly when –on-create-info is used
问题
单选题You install a copy of Mysql 5.6.13 on a brand new Linux server by using RPM packages. The server starts successfully as verified by the following commands: $ pidof mysqld 3132 $tail – n2 /var/lib.mysql/hostname.err 2013-08-18 08:18:38 3132 [Note] /usr/sbin/mysqld:ready for connections. Version: '5.6.13-enterprise-commercial-advaced' socket:'/tmp/mysql.sock' port; 3306 Mysql Enterprise Server – Advanced Edition (Commercial) You attempt to log in as the root user with the following command: $mysql – u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Which statement is true about this scenario?（）A
The RPM installation script sets a default password of password for new installationsB
The local root user must log in with a blank password initially: mysql –u root –pC
New security measures mean that the mysql_secure_installation script must be run first on all new installationsD
The mysql_install_bd post-installation script used – random-password
问题
单选题Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）A
Re-install the audit pluginB
Execute the command FLUSH LOGSC
Execute the command SET GLOBAL audit_log_fiush= OND
Move or rename the existing audit.log file
问题
多选题Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?（）AMysql NDB ClusterBMysql ReplicationCDistributed Replicated Block Device (DRBD) and MysqlDWindows Cluster and MysqlESolaris Cluster and Mysql
问题
单选题You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?（）A
The snapshot size will continue to grow as changes to the volume are madeB
The snapshots take a significant amount of disk space as they are a duplicate copy of the dataC
The system can only support one snapshot per volume, and you need to remove it to be able to take your next backupD
The system keeps a copy of changes in memory and can cause an out of memory event
问题
单选题Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）A
12; only top-level statements and stored procedure events are loggedB
111; top-level statements and all lower-level statements are loggedC
3; only the top-level statements are loggedD
102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
问题
多选题Which three data components are needed for point-in-time recovery?（）AThe error logBThe backup logCThe general query logDBinary logsEThe data backupFConfiguration files
问题
单选题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 automaticallyB
By enabling the Error Log because not using indexes is an errorC
By enabling the Slow Query Log and using the – log-queries-not-using-indexes optionD
By enabling the Error Log and using the – log-queries-not-using-indexes option
问题
多选题Which two are true regarding MySQL binary and text backups?（）ABinary backups are usually faster than text backupsBBinary backups are usually slower than text backupsCText backups are human-readable while binary backups are notDBinary backups are not portable across different operating systems
问题
多选题Consider the MySQL Enterprise Audit plugin, You add the following lines to the my.cnf configuration tile: [mysqld] Plugin-load=audit_log.so Audit-log=FORCE_PLUS_PERMANENT You attempt to start up the MySQL service and notice that it fails to start. Which two statements would explain why the service did not start?（）AFORCE_PLUS_PERMANENT is not valid for the audit-log optionBThe audit_log.so library does not existCThe audit_log.so library is in a location that is different from that defined by the plugin_dir optionDThe audit plugin must be loaded dynamically by using the INSTALL PLUGIN commandEThe audit log file does not exist in which to write audit eventsFThe audit_log.so library is not an executable file
问题
单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A
MySQL ReplicationB
Distributed Replication Block DeviceC
Windows Server Failover ClusteringD
MySQL Cluster
问题
多选题Which three statements are true about memory buffer allocation by a MySQL Server?（）AGlobal buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freedBThread buffers are allocated when a client connects, and are freed when the client disconnectsCBuffers that are needed for certain operation are allocated when the operation starts, and freed when it endsDUser buffers are allocated at server startup and freed when the user is droppedEAll dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed