Free Oracle 1z1-908 Exam Dumps Questions & Answers

Which four are types of information stored in the MySQL data dictionary? (Choose four.)

• A.  table definitions
• B.  access control lists
• C.  InnoDB buffer pool LRU management data
• D.  server runtime configuration
• E.  server configuration rollback
• F.  view definitions
• G.  performance metrics
• H.  stored procedure definitions

You issue this command:
SHOW SLAVE STATUS -
In the output, there is a value for Seconds_behind_master.
How is this time calculated?

• A.  It is the time between the most recent transaction written to the relay logs and the time it was committed on the master.
• B.  It is the time between the most recent transaction applied by a SQL thread and the time it was committed on the master.
• C.  It is the time between the I/O thread receiving details of the master's last transaction and the time it was written to the relay log on the slave.
• D.  It is the time between the I/O thread receiving details of the master's last transaction and the time it was applied by the SQL thread.

You are backing up raw InnoDB files by using mysqlbackup.
Which two groups of files will be backed up during a full backup? (Choose two.)

• A.  *.ibd files
• B.  *.sdi files
• C.  ibbackup files
• D.  ib_logfile* files
• E.  *.CSM files

The mysqld instance has the connection control plugin enabled with these settings:
connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000 The minimum and maximum delays need to be increased to 3000 and 5000, respectively.
A command is executed:
mysql> SET GLOBAL connection_control_min_connection_delay=3000;
What is the result?

• A.  An error is returned.
• B.  The minimum connection value is changed to 2000.
• C.  The minimum value increases to 3000 and the maximum value increases to 4000.
• D.  Only the minimum connection value is increased to 3000.

How can mysql_multi be configured to allow MySQL instances to use the same port number?

• A.  The instances listen on different IP addresses.
• B.  The instances use different user accounts unique to each instance.
• C.  The instances use different socket names.
• D.  The instances have appropriate net masks set.