最新的Oracle MySQL 5.6 Database Administrator - 1z0-883免費考試真題
問題1
You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;
9 rows in set (0.00 sec)
Mysql> show grants for 'admin'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'admin' on host '%'
Which command will fix this issue?
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;
9 rows in set (0.00 sec)
Mysql> show grants for 'admin'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'admin' on host '%'
Which command will fix this issue?
正確答案: E
說明：（僅 VCESoft 成員可見）
問題2
Consider typical High Availability (HA) solutions that do not use shared storage.
Which three HA solutions do not use shared storage?
Which three HA solutions do not use shared storage?
正確答案: A,D,E
問題3
You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?
Which two variables would likely fix this issue?
正確答案: E,F
問題4
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?
Which two changes would ensure that the temporary table does not propagate to the slave?
正確答案: B,D
問題5
You have forgotten the root user account password. You decide to reset the password and execute the following:
Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start - skip-grant tables
Which additional argument makes this operation safer?
Shell> /etc/init.d/mysql stop Shell> /etc/init.d/mysql start - skip-grant tables
Which additional argument makes this operation safer?
正確答案: C
說明：（僅 VCESoft 成員可見）
問題6
What are three facts about backups with mysqldump?
正確答案: A,D,F
問題7
Which three are properties of the MyISAM storage engine?
正確答案: A,E,F
問題8
The validate_password plugin is loaded and displays the following settings in global variables: Mysql> SHOW VARIABLES LIKE 'validate_password%';
When attempting to set your password, you get the following error:
Mysql> SET PASSWORD = PASSWORD ('Hoverl@%');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
What is the cause of the error?
When attempting to set your password, you get the following error:
Mysql> SET PASSWORD = PASSWORD ('Hoverl@%');
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
What is the cause of the error?
正確答案: E
問題9
Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?
Mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?
正確答案: A
問題10
Which two statements are true regarding partitioning in Mysql?
正確答案: C,D
