1Z0-908 Online Practice Questions and Answers

Which two statements are true about MySQL Installer? (Choose two.)

A. It installs most Oracle MySQL products.

B. It performs product upgrades.

C. It provides only GUI-driven, interactive installations.

D. Manual download of separate product packages is required before installing them through MySQL Installer.

E. It provides a uniform installation wizard across multiple platforms.

A MySQL server is monitored using MySQL Enterprise Monitor's agentless installation. Which three features are available with this installation method? (Choose three.)

A. MySQL Replication monitoring

B. network-related information and network characteristics

C. MySQL Query Analysis data

D. CPU utilization

E. security-related advisor warnings

F. operating system memory utilization

G. disk usage and disk characteristics including disk advisors warnings

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

A. /usr/mysql

B. /usr/bin

C. /etc/my.cnf

D. /var/lib/mysql

E. /usr

You want to check the values of the sort_buffer_size session variables of all existing connections. Which performance_schema table can you query?

A. user_variables_by_thread

B. global_variables

C. variables_by_thread

D. session_variables

Which three settings control global buffers shared by all threads on a MySQL server? (Choose three.)

A. sort_buffer_size

B. key_buffer_size

C. table_open_cache

D. read_buffer_size

E. innodb_buffer_pool_size

F. tmp_table_size

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

Which three actions are effective in capacity planning? (Choose three.)

A. buying more RAM

B. monitoring OS resources for patterns

C. adding circular replication nodes for increased DML capability

D. buying more CPU

E. buying more disk

F. basing expected growth on an average of the last 3 years

G. consulting the application team about any future projects and use

H. upgrading to the latest application version

You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.

Which four options need to be specified to complete this task with a single command? (Choose four.)

A. --shared-memory-base-name=world

B. --protocol=UDP

C. --protocol=pipe

D. --password

E. --user=admin

F. --host=192.0.2.1

G. --socket=/tmp/mysql.sock

H. --port=3306

I. --database=world