Examine this query and output:

Which two statements are true? (Choose two.)

• A.The query returns exactly 125 rows.
• B.35 rows from the city table are included in the result.
• C.The optimizer estimates that 51 rows in the countrytable have Continent = ‘Asia’.
• D.The countrytable is accessed as the first table, and then joined to the city table.
• E.It takes more than 8 milliseconds to sort the rows.

Comment: *

Name: *

Email: *

Verification: *

Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)

• A.It performs InnoDB Cluster instances rolling restart.
• B.It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
• C.It only stops and restarts all InnoDB Cluster instances.
• D.It is not mandatory that all instances are running and reachable before running the command.
• E.It stops and restarts all InnoDB Cluster instances and initializes the metadata.
• F.It reconfigures InnoDB Cluster if the cluster was stopped.
• G.It only starts all InnoDB Cluster instances.

Comment: *

Name: *

Email: *

Verification: *

The data in this instance is transient; no backup or replication will be required. It is currently under performing.
* The database size is static and including indexes is 19G.
* Total system memory is 32G.
After profiling the system, you highlight these MySQL status and global variables:

The OS metrics indicate that disk is a bottleneck. Other variables retain their default values.
Which three changes will provide the most benefit to the instance? (Choose three.)

• A.innodb_undo_directory=/dev/shm
• B.innodb_log_file_size=1G
• C.max_connections=10000
• D.buffer_pool_size=24G
• E.sync_binlog=0
• F.innodb_doublewrite=0
• G.innodb_flush_log_at_trx_commit=1

Comment: *

Name: *

Email: *

Verification: *

Examine this command and output:

Which two options will improve the security of the MySQL instance? (Choose two.)

• A.Change the parent directory owner and group to mysql.
• B.Remove the world read/execute privilege from the accountingdirectory.
• C.Remove world read privileges from the server-cert.pemcertificate file.
• D.Change the group ownership of the mysqldirectory to the mysqluser group.
• E.Remove world read privileges from the public_key.pemfile.
• F.Remove group read/write privileges from the private_key.pemfile.

Comment: *

Name: *

Email: *

Verification: *

Which two queries are examples of successful SQL injection attacks? (Choose two.) SELECT user,passwd FROM members

• A.SELECT email,passwd FROM members
• B.SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
• C.WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES
  (‘[email protected]’,‘secret’);--‘;
• D.SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
• E.SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;
• F.WHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES
  (‘[email protected]’, ‘secret’);--‘;
  SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;

Comment: *

Name: *

Email: *

Verification: *