Question 1

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 2

Which three are properties of the MyISAM storage engine? (Choose three.)

Options :

A : Transaction support

B : FULLTEXT indexing for text matching

C : Table and page level locking support

D : Foreign key support

E : Geospatial indexing

F : HASH index support

G : Table level locking only

Answer: A,B

Question 3

You are considering using file-system snapshots to back up MySQL.

Which three statements are true? (Choose three.)

Options :

A : They take roughly twice as long as logical backups.

B : They allow direct copying of table rows with operating system copy commands.

C : They work best for transaction storage engines that can perform their own recovery when restored.

D : The backup window is almost zero from the perspective of the application.

E : They do not back up views, stored procedures, or configuration files.

F : There is a slight performance cost while the snapshot is active.

G : They do not use additional disk space.

Answer: A,C

Question 4

Which query would you use to find connections that are in the same state for longer than 100 seconds?

Options :

A : SHOW FULL PROCESSLIST WHEER Time > 100;

B : SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ), INTERVAL 100 SECOND) );

C : SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 100;

Answer: C

Question 5

Examine this command and output:

Which statement is true?

Options :

A : Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

B : Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

C : Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

D : Firewall_access_granted is the number of connections granted from whitelisted hosts.

Answer: C

Confidently Practice Online with Free 1Z0-908 Exam Cram

Buying Options: