Oracle 1z0-883 問題集

質問 1：
Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.
Which method would use mysqlbinlog for greater consistency?
A. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
B. shell> mysqlbinlog - restore bin.00010 bin.00011 bin.00012
C. shell> mysqlbinlog - include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql
D. shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql
正解：D

質問 2：
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?
A. Use the - replicate-do-db, -- replicate-do-table, or - replicate-wild-do-table option with the value equal to OLD_INVENTORY.
B. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
C. Use the - replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.
D. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
E. Set binlog_format=MIXED with the - replicate-ignore-temp-table option.
正解：C,E

質問 3：
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?
A. There is no dictionary file defined, so password validation cannot work as expected.
B. All of the MEDIUM password policy requirements have not been honored.
C. The password matches a substring Hover as a dictionary word.
D. The password is eight characters long, but needs to exceed validate_password_length to be valid.
E. The password does not match the validate_passoword_number_count requirement.
正解：B

質問 4：
You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' connot be loaded: plugin not enabled
What would you run to fix the issue?
A. The mysql_upgrade script
B. The mysql client with the - enable-cleartext-plugin option
C. The mysql_secure_installation script to update server security settings
D. The install plugin command for the mysql_cleartext_password plugin
E. The mysql client with the - ignore-password-hashing option
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two statements describe the behavior of the server's SQL mode?
A. The server's SQL mode, when globally set on a slave server, applies to events sent from the master.
B. The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command.
C. The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.
D. The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:
Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'.
Query: 'insert into mytable VALUES ('8' , 'George') '
Skip_Counter: 0
Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8
Auto _Position: 1
You execute a "SHOW CREATE TABLE mytable" on the slave:
CREATE TABLE 'mytable' (
'ID' int(11) NOT NULL DEFAULT '0',
'name' char(10) DEFAULT NULL,
PRIMARY KEY ('ID')
)
The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error.
Which statement should be used?
A. SET GTID_EXECUTED="38f32e23480a7-32a1-c323f78067fd37821 : 9";
B. SET GTID_NEXT="38f32e23480a7-32a1-c323f78067fd37821 : 9";
BEGIN; COMMIT;
SET GTID_NEXT="AUTOMATIC";
C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
D. SET GTID_NEXT="CONSISTENCY";
BEGIN; COMMIT;
SET GTID_NEXT=" AUTOMATIC';
E. SET GLOBAL enforce_gtid_consistency=ON
正解：C

質問 7：
Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?
A. Using the statement RESET PERFORMANCE CACHE;
B. Restarting Mysql
C. Using the statement FLUSH PERFORMANCE CACHE;
D. Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current;
E. Using TRUNCATE statements, for example, TRUNCATE TABLE performance_schema.events_waits_current;
F. Disabling and re-enabling all instruments
正解：E,F
解説: (Topexam メンバーにのみ表示されます)

質問 8：
User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?
A. INSERT INTO pets...
B. ALTER TABLE pets...
C. SELECT....FROM pets
D. UPDATE pets...
正解：C

質問 9：
Which two options describe how MySQL Server allocates memory?
A. Each connection may have its own per-thread memory allocations.
B. Thread memory is pre-allocated up to thread_cache_size for performance.
C. Each thread allocates memory from a global pool.
D. Global memory resources are allocated at server startup.
正解：A,D