Examine this SQL statement:
mysql> GRANT r_read@localhost TO mark WITH ADMIN OPTION;
Which two are true? (Choose two.)

• A.Mark can grant the privileges assigned to the r_read@localhost role to another user.
• B.ADMIN OPTION causes the role to be activated by default.
• C.Mark can grant the r_read@localhost role to another user.
• D.Mark can revoke the r_read@localhost role from another role.
• E.ADMIN OPTION allows Mark to drop the role.
• F.Mark must connect from localhost to activate the r_read@localhost role.

Comment: *

Name: *

Email: *

Verification: *

Which two commands will display indexes on the partstable in the manufacturing schema? (Choose two.) \

• A.DESCRIBE manufacturing.parts;
• B.SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
  AND TABLE_NAME=’parts’;
• C.SHOW INDEXES FROM manufacturing.parts;
• D.SELECT * FROM information_schema.COLUMN_STATISTICS;
• E.EXPLAIN SELECT INDEXES FROM manufacturing.parts;

Comment: *

Name: *

Email: *

Verification: *

Which two storage engines provide a view of the data consistent with the storage system at any moment? (Choose two.)

• A.ARCHIVE
• B.MEMORY
• C.MyISAM
• D.NDB
• E.InnoDB

Comment: *

Name: *

Email: *

Verification: *

You have configured GTID-based asynchronous replication with one master and one slave.
A user accidentally updated some data on the slave.
To fix this, you stopped replication and successfully reverted the accidental changes. Examine the current GTID information:

You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of failover. Which set of actions would allow the slave to continue replicating without erroneous transactions?

• A.SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312,bbbbbbbb- bbbb-bbbb-bbbb-bbbbbbbbbbbb:1-9; SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• B.RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• C.RESET MASTER;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• D.RESET MASTER;
  SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167;
• E.RESET SLAVE;
  SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820;
  SET GLOBAL gtid_executed=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10300;

Comment: *

Name: *

Email: *

Verification: *

Which two queries are examples of successful SQL injection attacks? (Choose two.)

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

Comment: *

Name: *

Email: *

Verification: *