Online 1Z0-908 Practice Test

Question 1

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 X.509-compliant certificate will be used to establish the

SSL/TLS connection to MySQL?

Options :

A : REQUIRED

B : VERIFY_CA

C : VERIFY_IDENTITY

D : PREFERRED

E : DISABLED

Answer: A

Question 2

You want to shutdown a running Mysql Server cleanly.

Which three commands that are valid on either Windows or Linux will achieve this?

Options :

A : Shell> pkill –u mysql mysqld_safe

B : Shell> service mysql safe_exit

C : Shell> /etc/init.d/mysql stop

D : Shell> mysqladmin –u root –p shutdown

E : Mysql> STOP PROCESS mysqld;

F : Shell> net stop mysql

G : Shell> nmc mysql shutdown

Answer: A,C,D

Question 3

Examine this statement, which executes successfully:

Other-Image-2d087695c-370a-4149-9dae-43fdb2993133

You want to improve the performance of this query:

Other-Image-4d087695c-370a-4149-9dae-43fdb2993133

Which change enables the query to succeed while accessing fewer rows?

Options :

A : ALTER TABLE world.city ADD SPATIAL INDEX (Name);

B : ALTER TABLE world.city ADD SPATIAL INDEX (Population);

C : ALTER TABLE world.city ADD INDEX (Population);

D : ALTER TABLE world.city ADD INDEX (Name);

E : ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

F : ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Answer: B

Question 4

On a master server that is using Statement-based replication a table of log data has become very large. You decide to delete 100,000 rows.

Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

Options :

A : Use the LIMIT clause to limit the deletion to 100,000 rows.

B : Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.

C :

Use the LIMIT clause in conjunction with the ORDER BY clause.

D : Use the data modification is non-deterministic, the query optimizer will resolve any potential issues.

Answer: B,C

Question 5

You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.

mysql> SHOW SLAVE STATUS\G

... Slave_IO_Running: YesSlave_SQL_Running: No

What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running? (Choose two.)

Options :

A : to allow the remaining events to be processed on the slave while not receiving new events from the master

B : to allow a backup to be created under reduced load

C : to allow for point-in-time recovery on the slave

D : to prevent schema changes from propagating to the slave before they are validated

E : to prevent any transaction experiencing a deadlock

Answer: B,C

EXPERTY DESIGNED 1Z0-908 PRACTICE TEST