Oracle 1Z0-888 Quiz 8 Topic 1 Questions 36-40

Question: 1

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

q1_1Z0-888

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?

Ato allow the remaining events to be processed on the slave while not receiving new events from the master

Bto allow a backup to be created under reduced load

Cto allow for point-in-time recovery on the slave

Dto prevent schema changes from propagating to the slave before they are validated

Eto prevent any transaction experiencing a deadlock

Show Answer

Question: 2

Which two methods accurately monitor the size of your total database size over time?

Amonitoring the Innodb_rows_inserted status variable

Bmonitoring the innodb_redo_log_size variable

Cmonitoring the information_schemA.TABLES table

Dmonitoring datadir size in the operating system

Emonitoring cumulative Innodb_page_size increase

Fmonitoring the performance_schema_hosts_size variable

Show Answer

Question: 3

Consider the index information for the dept_emp table in the employee's schema:

q3_1Z0-888

Which two conclusions can be made based on the output of the query?

AThere are three indexes on the table.

BThere is a redundant index on the dept_no column.

CThe secondary indexes are optimized for unique key look-ups.

DThe values on the emp_no column must be unique.

EThe selectivity of the dept_no column is the best of the indexed columns.

FThere is a redundant index on the emp_no column.

Show Answer

Question: 4

Which two statements are true about InnoDB auto-increment locking?

AInnoDB never uses table_level locks.

BInnoDB always protects auto-increment updates with a table-level lock

CInnoDB does not use locks to enforce auto-increment uniqueness.

DThe auto-increment lock can be a table-level lock.

ESome settings for innodb_autoinc_lock_mode can help reduce locking.

Show Answer

Question: 5

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the

master server. This table is not to be replicated to the slave server.

Which two changes would ensure that the temporary table does not propagate to the slave?

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

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

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

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

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

Show Answer

Oracle 1Z0-888 Quiz:8 Topic:1 Questions:36-40