Free Oracle 1z0-908 Practice Exam with Questions & Answers | Set: 3

help topics

performance monitoring information

plugins

information about table structures

audit log events

rollback segments

time zone information and definitions

total memory used across all connections associated with the user on connection number 10

total memory used by the first 10 connections

total memory used by thread number 10

total memory used across all connections associated with the user on thread number 10

total memory used by connection number 10

total memory used by the first 10 threads

The master is most probably too busy to transmit data and the slave needs to wait for more data.

One or more large tables do not have primary keys.

This value shows only I/O latency and is not indicative of the size of the transaction queue.

The master is producing a large volume of events in parallel but the slave is processing them serially.

The parallel slave threads are experiencing lock contention.

any user set as DEFINER for stored programs

any internal system accounts

any new ROLE accounts

any user created without a password

any user created with a username, but missing the host name

It will force the load of the audit plugin even in case of errors at server start.

It causes the audit log to be created if it does not exist.

It prevents the audit plugin from being removed from the running server.

It prevents the audit log from being removed or rotated.

No index can be used for the join.

The query must access no more than two tables.

The smallest of the tables in the join must fit in memory as set by join_buffer_size.

At least one of the tables in the join must have a hash index.

If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

Use SET GLOBAL binlog_expire_logs_seconds= and restart the server.

Set binlog_expire_logs_seconds in my.cnf.

Set binlog_expire_logs_seconds = 0 in my.cnf and restart the server.

Use SET PERSIST binlog_expire_logs_seconds=.

Use PURGE BINARY LOGS to .

Use SET GLOBAL binlog_expire_logs_seconds= and run the FLUSH BINARY LOGS

command.

TCP

SOCKET

PIPE

DIRECT

IPv6

FILE

IPv4

Connection 24 experiences a lock wait timeout.

Connection 25 experiences a lock wait timeout.

A deadlock occurs immediately.

All statements execute without error.

A deadlock occurs after innodb_lock_wait_timeout seconds.