1Z0-908 Exam Questions

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

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 UPD...

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...

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

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

What does the binlog dump thread do?

Which two commands will display indexes on the parts table in the manufacturing schema? (Choose two.)

Your MySQL server is running on the Microsoft Windows platform. Which three local connection protocols are available to you? (Choose three.)

Which two statements are true about using MySQL Enterprise Monitor Query Analyzer? (Choose two.)

Which two are use cases of MySQL asynchronous replication? (Choose two.)

Examine this list of MySQL data directory binary logs: binlog.000001 binlog.000002 ..... binlog.000289 binlog.000300 binlog.000301 binlog.index Now examine this command, which exec...

Which step or set of steps can be used to rotate the error log?

Examine this command, which executes successfully: shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb Which two statements are true? (Choose two.)

Examine this query and output: Which two statements are true? (Choose two.)

Examine this command, which executes successfully: mysqlpump --user=root --password > full_backup.sql Which two databases will be excluded from this dump? (Choose two.)

Examine this MySQL client command to connect to a remote database: mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode= Which two --ssl-mode values will ensure that an...

You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?

Which two statements are true about using backups of the binary log? (Choose two.)

Consider this shell output and executed commands: [root@oel7 ~]# ps aux | grep mysqld mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid [root@oel7 ~]# kill -15 2...

You wish to protect your MySQL database against SQL injection attacks. Which method would fail to do this?

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...

Your MySQL installation is running low on space due to binary logs. You need to reduce your log space usage urgently. Which two sets of actions when completed will accomplish this?...

Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

Examine this statement, which executes successfully: You want to improve the performance of this query: Which change enables the query to succeed while accessing fewer rows?

Which three are characteristics of a newly created role? (Choose three.)

You have configured GTID-based asynchronous replication with one master and one slave. A user accidentally updated some data on the slave. To fix this, you stopped replication and...

Examine this statement and output: You must try to reduce query execution time. Which two queries should you focus on? (Choose two.)

Examine this query: What information does this query provide?

On examination, your MySQL installation datadir has become recursively world read/write/executable. What are two major concerns of running an installation with incorrect file privi...

User account baduser@hostname on your MySQL instance has been compromised. Which two commands stop any new connections using the compromised account? (Choose two.)

An existing asynchronous replication setup is running MySQL 8. Which two steps are a part of implementing GTID replication? (Choose two.)

Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

Examine this command and output: Which two statements are true? (Choose two.)

Which three statements are true about MySQL replication? (Choose three.)

Which two statements are true about the mysql_config_editor program? (Choose two.)