Free Oracle 1Z0-908 Exam Dumps Questions & Answers

Examine these commands and output:

Which connection ID is holding the metadata lock?

• A.  6
• B.  22
• C.  25
• D.  20
• E.  24
• F.  21

You are using mysqlcheck for server maintenance.
Which two statements are true? (Choose two.)

• A.  The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.
• B.  The mysqlcheck --optimize --all-databases command reclaims free space from table files.
• C.  The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.
• D.  The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.
• E.  The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

• A.  A deadlock occurs immediately.
• B.  Connection 25 experiences a lock wait timeout.
• C.  All statements execute without error.
• D.  Connection 24 experiences a lock wait timeout.
• E.  A deadlock occurs after innodb_lock_wait_timeout seconds.

Which command enables rule-based MySQL Auditing capabilities?

• A.  mysql> INSTALL PLUGIN audit_log;
• B.  shell> mysql < audit_log_filter_linux_install.sql
• C.  mysql> INSTALL COMPONENT audit_log;
• D.  shell> mysqld --initialize --log-raw=audit.log

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

• A.  tmp_table_size
• B.  key_buffer_size
• C.  read_buffer_size
• D.  sort_buffer_size
• E.  table_open_cache
• F.  innodb_buffer_pool_size