1z1-883問題集、Oracle実際の試験問題

質問 1

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_SCHEMPROCESSLIST WHERE HOST='192.168.1.15';

B. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=' 192.168.1.15';

C. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=' 192.168.1.15';

D. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=' 192.168.1.15';

正解: A

質問 2

You execute the following statement in a Microsoft Windows environment. There are no conflicts in the path name definitions.
C: \> mysqld - install Mysql56 - defaults - file = C : \my -opts.cnf
What is the expected outcome?

A. An error message is issued because - install is not a valid option for mysqld.

B. Mysql is installed as the Windows service name Mysql56, and uses c: \my-opts.cnf as the configuration file

C. A running Mysql 5.6 installation has its runtime configuration updated with the server variables set in c: \my-opts.cnf.

D. Mysqld acts as an MSI installer and installs the Mysql 5.6 version, with the c: \my-opts.cnf configuration file.

正解: B

質問 3

Consider typical High Availability (HA) solutions that do not use shared storage.
Which three HA solutions do not use shared storage?

A. Distributed Replicated Block Device (DRBD) and Mysql

B. Mysql Replication

C. Solaris Cluster and Mysql

D. Mysql NDB Cluster

E. Windows Cluster and Mysql

正解: A,B,D

質問 4

Which three are properties of the MyISAM storage engine?

A. Geospatial indexing

B. HASH index support

C. Transaction support

D. Table level locking only

E. Foreign key support

F. FULLTEXT indexing for text matching

G. Table and page level locking support

正解: A,D,F

質問 5

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
REORGANIZE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

B. ALTER TABLE games
ADD PARTITION g201350 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') );

C. ALTER TABLE games
SPLIT PARTITION (gMORES)
INTO
g201305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

D. ALTER TABLE games
COALESCE PARTITION (gMORES)
INTO
g01305 VALUES LESS THAN (TO_DAYS ('2013-05-01 00:00:00') ),
gMORES VALUES LESS THAN (MAXVALUE) );

E. 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) );

正解: B

質問 6

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> net stop mysql

B. Mysql> STOP PROCESS mysqld;

C. Shell> nmc mysql shutdown

D. Shell> service mysql safe_exit

E. Shell> mysqladmin -u root -p shutdown

F. Shell> pkill -u mysql mysqld_safe

G. Shell> /etc/init.d/mysql stop

正解: A,E,G

質問 7

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. Table_open_cache

D. Tmp_table_size

E. Max_heap_table_size

F. Table_open_cache_instancs

正解: D,E

質問 8

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 determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

C. The server's SQL mode can be changed at the session level with a SET SESSION sql_mode="new_value" command.

D. The server's SQL mode determines how the server should behave when performing data validation check and interpreting different forms of syntax.

正解: C,D

解説: (PassTest メンバーにのみ表示されます)

質問 9

You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?

A. The server was not started with the - enable--ssl-plugin option.

B. The mysqld binary was not compiled with SSL support.

C. The server's SSL certificate was invalid.

D. -- ssl is not a valid server option.

E. The --- ssl level was not specified.

正解: B

質問 10

Consider the MySQL Enterprise Audit plugin,
You add the following lines to the my.cnf configuration tile:
[mysqld]
Plugin-load=audit_log.so
Audit-log=FORCE_PLUS_PERMANENT
You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?

A. The audit_log.so library is not an executable file.

B. FORCE_PLUS_PERMANENT is not valid for the audit-log option.

C. The audit_log.so library does not exist.

D. The audit log file does not exist in which to write audit events.

E. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.

F. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.

正解: C,E

解説: (PassTest メンバーにのみ表示されます)

Oracle MySQL 5.6 Database Administrator - 1z1-883 模擬練習