최신Oracle MySQL 5.6 Database Administrator - 1z0-883무료샘플문제

A. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

B. Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

C. Set binlog_format=MIXED with the - replicate-ignore-temp-table option.

D. Use the - replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

E. Use the - replicate-do-db, -- replicate-do-table, or - replicate-wild-do-table option with the value equal to OLD_INVENTORY.

A. Execute the command FLUSH LOGS.

B. Move or rename the existing audit.log file.

C. Execute the command SET GLOBAL audit_log_fiush= ON.

D. Re-install the audit plugin.

A. It rejects invalid dates.

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

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

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

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

A. Convert the column to TEXT and add a fulltext index to the table.

B. Convert their column to BINARY.

C. Create multiple prefix indexes of differing lengths.

D. Redesign the table so that the most commonly searched for string patterns are in their own columns.

A. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay-bin.00004' , RELAY_LOG_POS = 1383;

B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

C. STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE;

D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

A. Allowing a client to kill other client connections

B. Allowing change of the server runtime configuration

C. Allowing a client to shut down the server

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

A. For tables with UNIQUE keys, statement-based replication must be used maintain integrity.

B. The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.

C. The applications have the SUPER privilege, which allows them to update rows.

D. The slave was created with mysqldump -u root -p - skip-lock-table-all-databases > /data/data.sql

E. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.

A. When uptime is critical

B. When application is a single point of failure

C. When data must be refactored

D. When application concurrency is static

E. When data loss is unacceptable

A. It flushes dirty pages in the buffer pool to the REDO logs.

B. It requires the RELOAD, FILE, and DROP privileges.

C. It closes and reopens all log files.

D. It closes and sends binary log files to slave servers.

A. SELECT ENGINE FROM INFORMATION_SCHEMA.ENGINES WHERE TABLE_NAME= 'Country';

B. SELECT ENGINE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME= 'Country';

C. SHOW CREATE TABLE Country;

D. SHOW ENGINE Country STATUS;

E. SHOW TABLE STATUS LIKE 'Country';