Free 1z0-908 Exam Dumps

Question 16

Examine this list of MySQL data directory binary logs:
binlog.000001 binlog.000002
.....
binlog.000289
binlog.000300
binlog.000301
binlog.index
Now examine this command, which executes successfully:
mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql
Which two are true? (Choose two.)

A. All databases are backed up to the output file.
B. All non-active binary logs are removed from the master.
C. All binary logs are deleted from the master.
D. All binary logs are backed up and then deleted.
E. All databases, excluding master metadata, are backed up to the output file.
F. All details regarding deleted logs and master metadata are captured in the output file.

Correct Answer:CE

Question 17

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.

Correct Answer:AE

Question 18

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

Correct Answer:C

Question 19

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

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

Correct Answer:DE

Question 20

Examine this MySQL client command to connect to a remote database:
mysql -h remote.example.org -u root -p --protocol=TCP --ssl-mode=
Which two --ssl-mode values will ensure that an X.509-compliant certificate will be used to establish the SSL/TLS connection to MySQL?

A. VERIFY_IDENTITY
B. REQUIRED
C. DISABLED
D. PREFERRED
E. VERIFY_CA

Correct Answer:B