最新的OCP認證 1z1-883考試題庫

問題1

Which two statements describe the behavior of the server's SQL mode?

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

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

C. The server's SQL mode, when globally set on a slave server, applies to events sent from the master.

D. The server's SQL mode determines whether the server should be read-only or should accept commands such as INSERT and UPDATE.

正確答案: A,B

說明：（僅 VCESoft 成員可見）

問題2

You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a RAW backup in this way?

A. The snapshot size will continue to grow as changes to the volume are made.

B. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.

C. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.

D. The system keeps a copy of changes in memory and can cause an out of memory event.

正確答案: B

問題3

A user executes the statement;
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?

A. It deletes all binary log files up to and including 'mysql-bin.010'.

B. It deletes all binary log files before 'mysql-bin.010'.

C. It deletes all binary log files, except 'mysql-in.010'.

D. It deletes all binary log files after 'mysql-bin.010'.

正確答案: B

說明：（僅 VCESoft 成員可見）

問題4

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?

A. Each extra column in the copy with more columns must not have a default value.

B. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns.

C. The slave database cannot have more columns than the master. Only the master database can have more columns.

D. Columns that are common to both versions of the table must be defined in the same order on the master and the slave.

E. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server.

正確答案: D,E

問題5

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 is configured with slave_parallel_workers = 4.

B. At most two schemas are being updated concurrently.

C. The slave cannot process the relay log fast enough to use all threads.

D. The server needs more cores to use all slave threads.

正確答案: B,C

說明：（僅 VCESoft 成員可見）

問題6

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;
SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3";
BEGIN;
COMMIT;
SET GTID_NEXT="AUTOMATIC";
START SLAVE

B. STOP SLAVE;
RESET SLAVE;
BEGIN;
SKIP NEXT GTID;
COMMIT;
START SLAVE;

C. STOP SLAVE;
BEGIN;
SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3";
COMMIT;
START SLAVE;

D. STOP SLAVE;
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
START SLAVE;

正確答案: D

說明：（僅 VCESoft 成員可見）

問題7

What is true regarding InnoDB locking?

A. InnoDB row locks may be escalated to page or table-level locks.

B. InnoDB uses row and table-level locks, but row locks are not escalates,

C. InnoDB uses row-level or table-level locks depending on the number of rows affected.

D. InnoDB locks only those rows that are updated.

E. InnoDB only uses row locks, not page or table-level locks,

正確答案: C

說明：（僅 VCESoft 成員可見）

問題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 blocked by a firewall or a similar security mechanism.

B. A connection as the user kate was successful.

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

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

E. A connection failed due to authentication being unsuccessful.

正確答案: D,E

說明：（僅 VCESoft 成員可見）

問題9

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?

A. Disconnecting idle localhost client sessions

B. Activating the MySQL Enterprise thread pool plugin

C. Relocating your data and log files to separate storage devices

D. Implementing storage engine data compression options

正確答案: A

問題10

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. -- single-transaction

B. -- tab

C. -- quick

D. -- skip-buffer

正確答案: C

說明：（僅 VCESoft 成員可見）

最新的Oracle MySQL 5.6 Database Administrator - 1z1-883免費考試真題

最新更新

站內鏈接

聯系我們