Oracle 1z0-883 問題集

質問 1：
Consider the following table:
CREATE TABLE 'game' (
'id' int (10) unsigned NOT NULL AUTO_INCREMENT,
'keyword' varchar (45) DEFAULT NULL,
'date' datetime NOT NULL,
PRIMARY KEY ('id' , 'date'),
UNIQUE KEY 'keyword_idx' ('keyword' , 'date')
) ENGINE=InnoDB DEFAULT CHARSET=latin1
PARTITION BY RANGE (TO_DAYS (date) ) (
PARTITION g201301 VALUES LESS THAN (TO_DAYS ('2013-01-01 00:00:00') ),
PARTITION g201302 VALUES LESS THAN (TO_DAYS ('2013-02-01 00:00:00') ),
PARTITION g201303 VALUES LESS THAN (TO_DAYS ('2013-03-01 00:00:00') ),
PARTITION g201304 VALUES LESS THAN (TO_DAYS ('2013-04-01 00:00:00') ),
PARTITION gMORES VALUES LESS THAN (MAXVALUE) );
Which method should used to add a new g201305 partition to the table?
A. ALTER TABLE games
SPLIT PARTITION (gMORES)
INTO
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );
B. ALTHER TABLE games
DROP PATITION gMORES,
ADD PARTITION
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );
C. ALTER TABLE games
REORGANIZE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );
D. ALTER TABLE games
ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') );
E. ALTER TABLE games
COALESCE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );
正解：D

質問 2：
When backing up a replication slave, which three should also be backed up in addition to data?
A. The relay index file
B. Mysql.slave_relay_log_info table
C. Mysql.slave_master_info table
D. The master.info and relay.info files
E. The relay log files
F. Mysql.slave_worker_info table
正解：B,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Consider the Mysql Enterprise Audit plugin.
You are checking user accounts and attempt the following query:
Mysql> SELECT user, host, plugin FROM mysql.users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
Which subset of event attributes would indicate this error in the audit.log file?
A. NAME="Query"
STATUS="1146"
SQLTEXT="select user,host from users"/>
B. NAME="Error"
STATUS="1146"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>
C. NAME="Query"
STATUS="1146"
SQLTEXT=" Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>
D. NAME="Error"
STATUS="1146"
SQLTEXT="select user,host from users"/>
E. NAME="Error"
STATUS="0"
SQLTEXT="Error 1146 (42S02): Table 'mysql.users' doesn't exist"/>
正解：A

質問 4：
You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
A. -- skip-buffer
B. -- single-transaction
C. -- quick
D. -- tab
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options:
Sync_binlog=1 Innodb_flush_log_at_trx_commit=1
Innodb_doublewrite=1
However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?
A. Placement of InnoDB log files and datadir on separate physical disks
B. Use of soft links for database directories on the same physical disk
C. Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D. Use of delay_key_write=ON for batch index update
E. Use of separate directories on the same physical disk for log files and data files
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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

質問 7：
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?
A. It shows the total size of the index row.
B. It shows how many columns in the index are examined.
C. It shows how many bytes will be used from each index row.
D. It shows the number of characters indexed in the key.
正解：C

質問 8：
You want to shutdown a running Mysql Server cleanly.
Which three commands that are valid on either Windows or Linux will achieve this?
A. Shell> mysqladmin -u root -p shutdown
B. Shell> /etc/init.d/mysql stop
C. Shell> net stop mysql
D. Shell> nmc mysql shutdown
E. Shell> service mysql safe_exit
F. Mysql> STOP PROCESS mysqld;
G. Shell> pkill -u mysql mysqld_safe
正解：A,B,C

質問 9：
You use-login-path to access a MySQL server on a Linux installation.
Which statement is true about the - login-path option that is created by using mysql_config_editor?
A. All system users have access to the MySQL server via-login path local.
B. When using - login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later.
C. __login-path allows you to provide login credentials without passing clear text passwords on the command line.
D. __login-path can be used only for MySQL servers running on a local machine.
正解：C