Oracle MySQL 8.0 Database Administrator - 1z1-908 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

You are considering using file-system snapshots to back up MySQL.
Which three statements are true? (Choose three.)

A. They take roughly twice as long as logical backups. B. The backup window is almost zero from the perspective of the application. C. There is a slight performance cost while the snapshot is active. D. They allow direct copying of table rows with operating system copy commands. E. They do not use additional disk space. F. They work best for transaction storage engines that can perform their own recovery when restored. G. They do not back up views, stored procedures, or configuration files.

Discussion 0

Correct Answer: E,F,G Vote an answer

Question 2

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

A. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
'tom'@'%'; B. GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%'; C. GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%'; D. GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

Discussion 0

Correct Answer: A Vote an answer

Question 3

Which condition is true about the use of the hash join algorithm?

A. At least one of the tables in the join must have a hash index. B. The smallest of the tables in the join must fit in memory as set by join_buffer_size. C. No index can be used for the join. D. The query must access no more than two tables.

Discussion 0

Correct Answer: D Vote an answer

Question 4

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

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

Discussion 0

Correct Answer: A,B,E Vote an answer

Question 5

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?

A. audit log B. error log C. general query log D. slow query log E. binary log

Discussion 0

Correct Answer: E Vote an answer

Question 6

A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

A. /etc/my.cnf file B. $HOME/.mysql/auth/login file C. DATADIR/mysqld-auto.cnf file D. $MYSQL_HOME/my.cnf file E. $HOME/.mylogin.cnf file F. $HOME/.mysqlrc file G. $HOME/.my.cnf file

Discussion 0

Correct Answer: A,C,D Vote an answer

Question 7

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 COMPONENT audit_log; D. mysql> INSTALL PLUGIN audit_log;

Discussion 0

Correct Answer: A Vote an answer

Question 8

You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

A. A small amount of committed transactions may be lost in case they were committed just before the disk failure. B. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log. C. No committed transactions are lost. D. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached. E. The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master. F. As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.

Discussion 0

Correct Answer: A,E Vote an answer