Online 1Z0-908 Practice Test

Question 1

Which two methods will provide the total number of partitions on a table? (Choose two.)

Options :

A : Query the INFORMATION_SCHEMA.PARTITIONS table

B : Use the command: SHOW TABLE STATUS

C : Query the performance_schema.objects_summary_global_by_type table

D : Query the INFORMATION_SCHEMA.TABLES table for the partition_count

E : Use the command: SHOW CREATE TABLE

Answer: A

Question 2

When the backup is taken, there are no errors.

Why are triggers missing from the backup?

Options :

A : The FILE privilege is required to back up the TRG files stored in the database directory.

B : The PROCESS privilege will allow the user access to process items such as triggers and functions.

C : The ALL privilege is required to back up triggers because triggers have a wide variety of abilities.

D : The TRIGGER privilege Is required to create, execute, and show triggers in a database.

Answer: D

Question 3

Your MySQL server was upgraded from an earlier major version.

The sales database contains three tables, one of which is the transactions table, which has 4 million rows.

You are running low on disk space on the datadir partition and begin to investigate.

Examine these commands and output:

Other-Image-5400dea42-15fa-4b95-aaab-09ec510a61e4

Which two statements are true? (Choose two.)

Options :

A :

Executing SET GLOBAL innodb_row_format=COMPRESSED and then ALTER TABLE transactions

will free up disk space.

B : Executing ALTER TABLE transactions will enable you to free up disk space.

C : Truncating the sales and leads table will free up disk space.

D : Truncating the transactions table will free up the most disk space.

E : The transactions table was created with innodb_file_per_table=OFF.

Answer: A

Question 4

How can we start MySQL when it was installed using RPM in Oracle Enterprise Linux 7?

Options :

A : mysqld_safe --user=mysql &

B : systemctl start mysqld

C : service start mysql

D : mysqladmin -u root start

Answer: B

Question 5

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.

Which method would use mysqlbinlog for greater consistency?

Options :

A : shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

B : shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

C : shell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012

D : shell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

Answer: B

EXPERTY DESIGNED 1Z0-908 PRACTICE TEST