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

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

Comment: *

Name: *

Email: *

Verification: *

An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses:
host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage()
Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377'’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

• A.The instance deployed on host3must be rebuilt with a backup from the primary instance.
• B.It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
• C.The active session instance is invalid and must be re-created by using the command shell.connect (‘host3:3377’).
• D.The cluster is running and there is at least one ONLINEinstance.
• E.The instance deployed on host3must be synchronized from a donor deployed on host1by using the command cluster.addInstance(‘host1:3377’).

Comment: *

Name: *

Email: *

Verification: *

Examine this statement:
mysql> DROP ROLE r_role1, r_role2;
Which two are true? (Choose two.)

• A.Existing connections can continue to use the roles' privileges until they reconnect.
• B.You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.
• C.You must revoke all privileges from r_role1 and r_role2 before dropping the roles.
• D.It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.
• E.It fails if at least one of the roles does not exist.
• F.It fails if any of the roles is specified in the mandatory_roles variable.

Comment: *

Name: *

Email: *

Verification: *

Examine these commands and output:

Which connection ID is holding the metadata lock?

• A.24
• B.22
• C.21
• D.20
• E.25
• F.6

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *