Oracle 1z0-883 問題集

質問 1：
What are three actions performed by the mysql_secure_installation tool?
A. It prompts you to set the root user account password.
B. It asks to remove the test database, which is generated at installation time.
C. It checks whether file permissions are appropriate within datadir.
D. It verifies that all users are configuration with the longer password hash.
E. It can delete any anonymous accounts.
正解：A,B,E
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which three statements are true about memory buffer allocation by a MySQL Server?
A. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed.
B. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed.
C. User buffers are allocated at server startup and freed when the user is dropped.
D. Thread buffers are allocated when a client connects, and are freed when the client disconnects.
E. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends.
正解：B,D,E

質問 3：
Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication.
Which two statements are correct?
A. Both technologies use the TCP/IP stack as their primary transmission medium.
B. DRBD uses shared-disk technology.
C. Both technologies guarantee an identical copy of data on the secondary node.
D. Only MySQL can maintain a time-delayed copy of data on the secondary node.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
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?
A. Table_definition_cache
B. Max_tmp_tables
C. Max_heap_table_size
D. Table_open_cache
E. Table_open_cache_instancs
F. Tmp_table_size
正解：C,F

質問 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?
A. --reset-grant-tables, to start the server with only the mysql database accessible
B. --old-passwords, to start Mysql to use the old password format while running without the grant tables
C. --read-only,to set all data to read-only except for super users
D. --skip-networking, to prohibit access from remote locations
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
In a test database, you issue the SELECT ... INTO OUTFILE statement to create a file with your t1 table data.
You then TRUNCATE this table to empty it.
Mysql> SELECT * INTO OUTFILE '/tmp/t1.sql' from t1;
mysql> TRUNCATE t1;
Which two methods will restore data to the t1 table?
A. Mysql> INSERT INTO t1 VALUES FROM '/tmp/t1.sql';
B. $ mysqlimport - u root - p - h localhost test /tmp/t1.sql
C. $ mysql - u root - p - h localhost test < /tmp/t1.sql
D. Mysql> LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1;
E. $ mysqladmin - u root - p - h localhost test - restore /tmp/t1.sql
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You have a login-path named "adamlocal" that was created by using the mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command:
$ mysql_config_editor print -login-path=adamlocal
What is the expected output of this command?
A. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
B. The command prints all parameter for the login-path. The password is replaced with stars.
C. The command prints all parameters for the login-path. The password is shown only when you provide the -password option.
D. The command prints all parameters for the login-path. The password is printed in plain text.
正解：B

質問 8：
You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries.
Which statement will accomplish this?
A. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';
B. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';
C. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';
D. SELECT * FROM INFORMATION_SCHEMPROCESSLIST WHERE HOST='192.168.1.15';
正解：D

質問 9：
You are using the performance Schema to investigate replication on a slave:
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;

Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?
A. The slave cannot process the relay log fast enough to use all threads.
B. The slave is configured with slave_parallel_workers = 4.
C. The server needs more cores to use all slave threads.
D. At most two schemas are being updated concurrently.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)