oracle 1z0-908 practice test

You have just installed MySQL on Oracle Linux and adjusted your /etc/my.cnf parameters to suit your
installation.
Examine the output:

What statement is true about the start attempt?

• A. MySQL server was not started due to a problem while executing process 2732.
• B. MySQL server continued to start up even though another process existed.
• C. systemd found the mysqld service disabled and failed to start it.
• D. systemd waited for 30 seconds before timing out and start up failed.
• E. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

Examine these entries from the general query log:

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

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

Examine this command, which executes successfully:
$ mysqlrouter --bootstrap user@hostname:port --directory=directory_path
Which activity is performed?

• A. MySQL Router is configured based on the information in files in directory_path.
• B. MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
• C. MySQL Router is restarted.
• D. MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.

You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO ‘user1’;
How can you proceed with your transaction with the least interruption?

• A. Roll back the transaction and start the transaction again in the same session.
• B. Re-execute the failed statement in your transaction.
• C. Change the default database and re-execute the failed statement in your transaction.
• D. Close the connection, reconnect, and start the transaction again.

Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY ‘P@ssw0rd’;
GRANT r_world_rd TO john;
Examine these statements issued by user John:

What is the reason for the error?

• A. The statement was blocked by MySQL Firewall.
• B. John has not activated the role.
• C. John needs to reconnect to the database.
• D. The DBA needs to execute FLUSH PRIVILEGES.

Binary log events for the ‘mydb1’ schema must be copied to a different schema name ‘mydb2’.
Which command will do this?

• A. mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql
• B. mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql
• C. mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql
• D. mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

• A. It reconfigures InnoDB Cluster if the cluster was stopped.
• B. It performs InnoDB Cluster instances rolling restart.
• C. It only starts all InnoDB Cluster instances.
• D. It is not mandatory that all instances are running and reachable before running the command.
• E. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
• F. It only stops and restarts all InnoDB Cluster instances.
• G. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

Which two statements are true about MySQL server multi-source replication? (Choose two.)

• A. It is not compatible with auto-positioning.
• B. It needs to be re-instanced after a crash to maintain consistency.
• C. It uses only time-based replication conflict resolution.
• D. It relies on relay_log_recovery for resilient operations.
• E. It does not attempt to detect or resolve replication conflicts.
• F. It must use GTID replication.

Which command enables rule-based MySQL Auditing capabilities?

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

Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

• A. Mark can grant the privileges assigned to the r_read@localhost role to another user.
• B. ADMIN OPTION causes the role to be activated by default.
• C. Mark can grant the r_read@localhost role to another user.
• D. Mark can revoke the r_read@localhost role from another role.
• E. ADMIN OPTION allows Mark to drop the role.
• F. Mark must connect from localhost to activate the r_read@localhost role.