1z0-908 Practice Test practice questions, page 3 of 9, with answer review and explanations.
Question 11
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?
MySQL server was not started due to a problem while executing process 2732.
MySQL server continued to start up even though another process existed.
systemd found the mysqld service disabled and failed to start it.
systemd waited for 30 seconds before timing out and start up failed.
systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.
Question 12
Examine these entries from the general query log: All UPDATE statements reference existing rows. Which describes the outcome of the sequence of statements?
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.
Question 13
Examine this command, which executes successfully: $ mysqlrouter --bootstrap user@hostname:port --directory=directory_path Which activity is performed?
MySQL Router is configured based on the information in files in directory_path.
MySQL Router configures itself based on the information retrieved from the InnoDB cluster metadata server.
MySQL Router is restarted.
MySQL Router configures all the cluster nodes based on the information retrieved from the InnoDB cluster metadata server.
Question 14
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?
Roll back the transaction and start the transaction again in the same session.
Re-execute the failed statement in your transaction.
Change the default database and re-execute the failed statement in your transaction.
Close the connection, reconnect, and start the transaction again.
Question 15
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?