Question 1

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 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

You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)

Options :

A : Set binlog_format=MIXED with the –replicate-ignore-temp-table option.

B : Use the –replicate-do-db, –replicate-do-table, or –replicate-wild-do-table option with the value equal to OLD_INVENTORY.

C : Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D : Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

E : Use the –replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Answer: A,C

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

Your MySQL environment has asynchronous position based-replication with one master and one slave.The slave instance had a disk I/O problem, so it was stopped.You determined that the slave relay log files were corrupted and unusable, but no other files are damaged.You restart MySQL Server.How can replication be restored?

Options :

A : The slave relay logs should be deleted; then execute START SLAVE;

B : The relay logs from the master should be used to replace the corrupted relay logs.

C : The slave relay logs should be deleted; execute CHANGE MASTER to adjust the replication relay log file name, then issue start SLAVE;

D : The slave needs to be restored from backup.

Answer: B