QUESTION: 13

Which two methods accurately monitor the size of your total database size over time? (Choose two.)

monitoring the Innodb_rows_inserted status variable
monitoring the innodb_redo_log_size variable
monitoring the information_schema.TABLES table
monitoring datadir size in the operating system
monitoring cumulative Innodb_page_size increase
monitoring the performance_schema_hosts_size variable

Answer(s): C,F

QUESTION: 14

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

Which two conclusions can be made based on the output of the query? (Choose two.)

There are three indexes on the table.
There is a redundant index on the dept_no column.
The secondary indexes are optimized for unique key look-ups.
The values on the emp_no column must be unique.
The selectivity of the dept_no column is the best of the indexed columns.
There is a redundant index on the emp_no column.

Answer(s): C,F

Show Answer Next Question

QUESTION: 15

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

InnoDB never uses table_level locks.
InnoDB always protects auto-increment updates with a table-level lock
InnoDB does not use locks to enforce auto-increment uniqueness.
The auto-increment lock can be a table-level lock.
Some settings for innodb_autoinc_lock_mode can help reduce locking.

Answer(s): D,E

Show Answer Next Question

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? (Choose two.)

Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Answer(s): B,E

Show Answer Next Question

Free Oracle 1z0-888 Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16

1z0-888 Exam Discussions & Posts