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

質問 1

You want a record of all queries that are not using indexes.
How would you achieve this?

A. By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically

B. By enabling the Error Log and using the - log-queries-not-using-indexes option

C. By enabling the Slow Query Log and using the - log-queries-not-using-indexes option

D. By enabling the Error Log because not using indexes is an error

正解: C

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

質問 2

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 failed due to authentication being unsuccessful.

B. A connection was attempted via socket rather than TCP.

C. A connection was blocked by a firewall or a similar security mechanism.

D. A connection failed because the proxy user privileges did not match the login user.

E. A connection as the user kate was successful.

正解: A,B

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

質問 3

Which two events will cause a slave server to create a new relay log file?

A. Starting of the SQL thread

B. Execution of the FLUSH LOGS statement

C. Starting of the I/O thread

D. Execution of FULSH TABLES WITH READ LOCK

E. Reaching the slave_pendign _jobs_size_max limit

正解: B,C

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

質問 4

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup?

A. Running the server with - skip-networking specified

B. Disabling connections from named pipes or socket files (depending on the operating system of the server)

C. Limiting logins to originate from the application server or the server's subnet

D. Enabling and using SSL for connections to the Mysql database

E. Installing Mysql on the application server, and running the database and application on the same server

F. Starting the server with - bind- address=0.0.0.0 specified

正解: D,E

質問 5

Which two capabilities are granted with the SUPER privilege?

A. Allowing a client to shut down the server

B. Allowing change of the server runtime configuration

C. Allowing client accounts to take over the account of another user

D. Allowing a client to kill other client connections

正解: A,D

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

質問 6

Which three statements describe how the strict SQL mode provides added security?

A. It rejects statements that try to insert out-of-range values

B. It rejects dates with zero day or month values.

C. It rejects invalid dates.

D. It rejects queries that produce out-of-range values.

E. It limits the operations that the server can perform.

正解: A,B,E

質問 7

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. A syntax error will result as you cannot specify more than one partition in the same statement.

C. Only the first partition (p1) will be dropped as only one can be dropped at any time.

D. All data in pi and p3 partitions are removed and the table definition is changed.

正解: D

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

質問 8

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. Stop the server or lock the tables prior to the backup.

C. Always stop the server prior to the backup.

D. Stop the server or lock the databases prior to the backup.

E. Make a copy of the binary log and tablespace files.

正解: A,B

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

質問 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 server needs more cores to use all slave threads.

C. The slave is configured with slave_parallel_workers = 4.

D. At most two schemas are being updated concurrently.

正解: A,D

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

質問 10

An employee cannot access the company database. You check the connection variables:
Mysql> SHOW GLOBAL VARIABLES LIKE '%connect%';

8 rows in set (0.00 sec)
A look at the user privileges shows:
GRANT... TO 'bob'@'%, example.com' WITH MAX_USER_CONNECTIONS 0; GRANT... TO 'key'@'%, example.com' WITH MAX_USER_CONNECTIONS 1; GRANT... TO 'joe'@'%, example.com' WITH MAX_USER_CONNECTIONS 50; What is a valid explanation for why one of the users is unable to connect to the database?

A. Connect_timeout is too small to allow a connection to occur.

B. Bob has max_user_connections set to zero, which blocks all his connections

C. Kay is already connected elsewhere and attempting to log in again.

D. All users are blocked because max_user_connections is accumulated over the host account information.

E. Joe has exceeded the max_user_connections global limit.

正解: C

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