Question 1

On examination, your MySQL installation datadir has become recursively world read/write/executable.

What are two major concerns of running an installation with incorrect file privileges? (Choose two.)

Options :

A : Users could overwrite configuration files.

B : Data files could be deleted.

C : SQL injections could be used to insert bad data into the database.

D : MySQL binaries could be damaged, deleted, or altered.

E : Extra startup time would be required for the MySQL server to reset the privileges.

Answer: A,B

Question 2

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 3

Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

Options :

A : recording the order in which queries are issued

B : audit of all queries

C : point-in-time recovery

D : replication

E : logging the duration and locks for all queries

Answer: A,C

Question 4

A MySQL replication master is set up by using global reansaction identifiers(GTIDs). You execute this statement:

mysql> CREATE TABLE datatarget SELECT * FROM datasource;

ERROR 1786 (HY000): CREATE TABLE ... SELECT is forbidden when @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.

Why is this statment forbiden?

Options :

A : GTIDs have detected thar a slave is inconsistent and therefore, disallow upadtes until the problem is resolved.

B : The datasource table is using an older InnoDB tablespace format, which is not compatible with GTIDs.

C : The datasource table is using the MyISAM engine, which is not compatible with GTIDs.

D : The statement cannot be logged in a transactionally safe manner.

Answer: D

Question 5

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

Higher Test Marks with Free Online 1Z0-908 Exam Practice