Oracle 1z0-883 問題集

質問 1：
When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.
A. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.
B. The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The other integer types cannot.
C. Multiple BIT columns pack tightly into a row, using less space.
D. BIT (8) takes less space than eight TINYINT fields.
正解：C

質問 2：
A Mysql Server has been running an existing application successfully for six months.
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?
A. They all connect via the secure sha256_password algorithm without any configuration change.
B. They are not affected by this configuration change.
C. They will have to change their password the next time they login to the server.
D. They will have their passwords updated on start-up to sha256_password format.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which two are correct steps in taking a binary backup of MyISAM tables?
A. Make a copy of the .frm, .myd, and the .myi files.
B. Make a copy of the binary log and tablespace files.
C. Always stop the server prior to the backup.
D. Stop the server or lock the tables prior to the backup.
E. Stop the server or lock the databases prior to the backup.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?
A. Mysqlshow
B. Mysqlslow
C. Mysqldumpslow
D. Mysqldump
E. Mysqlaccess
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three are properties of the MyISAM storage engine?
A. HASH index support
B. Geospatial indexing
C. Table level locking only
D. FULLTEXT indexing for text matching
E. Table and page level locking support
F. Foreign key support
G. Transaction support
正解：B,C,D

質問 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 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 メンバーにのみ表示されます)

質問 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?
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

質問 9：
Which three methods will show the storage engine for the Country table?
A. SHOW ENGINE Country STATUS;
B. SHOW TABLE STATUS LIKE 'Country';
C. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Country';
D. SHOW CREATE TABLE Country;
E. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= 'Country';
正解：B,C,D