Oracle 1z0-883 問題集

質問 1：
Consider the Mysql Enterprise Audit plugin.
A CSV file called data.csv has 100 rows of data.
The stored procedure prepare_db ( ) has 10 auditable statements.
You run the following statements in the mydb database: Mysql> CALL prepare_db ( );
Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable;
Mysql> SHOW TABLES;
How many events are added to the audit log as a result of the preceding statements?
A. 3; only the top-level statements are logged.
B. 111; top-level statements and all lower-level statements are logged.
C. 12; only top-level statements and stored procedure events are logged.
D. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A general purpose MySQL instance is configured with the following options:
-- log-slow-queries -- long-query-time=,0001 -- log-slow-admin-queries -- general-log -- log-bin -- binlog-format=STATEMENT -- innodb-flush-log-at-trx-commit=1
Which three statements are true?
A. The Slow Query Log records more data than the General Query Log.
B. The binary Log records more data than the General Query Log.
C. The Slow Query Log records more data than the Binary Log.
D. The General Query Log records more data than the Slow Query Log.
E. The Binary Log records more data than the Slow Query Log.
F. The General Query Log records more data than the Binary Log.
正解：C,D,F

質問 3：
Consider the query:
Mysql> SET @run = 15;
Mysql> EXPLAIN SELECT objective, stage, COUNT (stage)
FROM iteminformation
WHERE run=@run AND objective='7.1'
GROUP BY objective,stage
ORDER BY stage;

The iteminformation table has the following indexes; Mysql> SHOW INDEXES FROM iteminformation:

This query is run several times in an application with different values in the WHERE clause in a growing data set.
What is the primary improvement that can be made for this scenario?
A. Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to use indexes.
B. Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.
C. Drop the run_2 index because it has caused a conflict in the choice of key for this query.
D. Add an index on the objective column so that is can be used in both the WHERE and GROUP BY operations.
E. Execute the run_2 index because it has caused a conflict in the choice of key for this query.
正解：C

質問 4：
Consider the following statement on a RANGE partitioned table:
ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?
A. All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
B. Only the first partition (p1) will be dropped as only one can be dropped at any time.
C. All data in pi and p3 partitions are removed and the table definition is changed.
D. A syntax error will result as you cannot specify more than one partition in the same statement.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
You are creating a new server with the same accounts as an existing server. You do this by importing a mysqldump file of the mysql database.
You test whether the import was successful by using the following commands:
Mysql> select user, host, password from mysql.user;

9 rows in set (0.00 sec)
Mysql> show grants for 'admin'@'%';
ERROR 1141 (42000): There is no such grant defined for user 'admin' on host '%'
Which command will fix this issue?
A. GRANT USAGE ON *.* TO 'admin'@'%';
B. FLUSH HOST CACHE;
C. CREATE USER 'admin' @'%';
D. FLUSH PRIVILEGES;
E. UPDATE mysql.user SET Create_user_priv = 'Y' WHERE user= 'admin';
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 NDB Cluster
C. Windows Cluster and Mysql
D. Solaris Cluster and Mysql
E. Mysql Replication
正解：A,B,E

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

質問 8：
Consider the Mysql Enterprise Audit plugin.
The following event detail is found in the audit log:
<AUDIT_RECORD
TIMESTAMP="2013-04-09t01:54:17"
NAME="Connect"
CONNECTION_ID="3"
STATUS="1045"
USER="kate"
PROXY_USER=""
HOST="localhost"
IP=""
DB=""/>
Which two points can be concluded from the given event?
A. A connection was attempted via socket rather than TCP.
B. A connection failed due to authentication being unsuccessful.
C. A connection was blocked by a firewall or a similar security mechanism.
D. A connection as the user kate was successful.
E. A connection failed because the proxy user privileges did not match the login user.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 9：
You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave.
Which command would you execute from a Mysql prompt?
A. STOP SLAVE;
RESET SLAVE;
BEGIN;
SKIP NEXT GTID;
COMMIT;
START SLAVE;
B. STOP SLAVE;
SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3";
BEGIN;
COMMIT;
SET GTID_NEXT="AUTOMATIC";
START SLAVE
C. STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
START SLAVE;
D. STOP SLAVE;
BEGIN;
SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3";
COMMIT;
START SLAVE;
正解：C
解説: (Topexam メンバーにのみ表示されます)