Online Access Free 1z1-908 Exam Questions

An existing asynchronous replication setup is running MySQL 8.
Which two steps are a part of implementing GTID replication? (Choose two.)

• A.On the slave, alter the MySQL master connection setting with:
  ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• B.Execute this on the slave to enable GTID:
  START SLAVE IO_THREAD WITH GTID;
• C.Execute this on the slave to enable GTID:
  RESET SLAVE; START SLAVE GTID_NEXT=AUTOMATIC;
• D.Enable GTID by executing this on the master and the slave:
  SET GLOBAL GTID_ENABLED=on;
• E.On the slave, alter the MySQL master connection setting with:
  CHANGE MASTER TO MASTER_AUTO_POSITION = 1;
• F.Restart MySQL (master and slave) with these options enabled:
  --gtid_mode=ON
  --log-bin
  --log-slave-updates
  --enforce-gtid-consistency

Examine this command and output:

Which statement is true?

• A.Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.
• B.Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.
• C.Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.
• D.Firewall_access_granted is the number of connections granted from whitelisted hosts.

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

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

You have semi-synchronous replication configured and working with one slave.
rpl_semi_sync_master_timeout has never been reached.
You find that the disk system on the master has failed and as a result, the data on the master is completely unrecoverable.
Which two statements are true? (Choose two.)

• A.No committed transactions are lost.
• B.The slave automatically identifies that the master is unreachable and performs any required actions so that applications can start using the slave as the new master.
• C.A small amount of committed transactions may be lost in case they were committed just before the disk failure.
• D.Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.
• E.As soon as the incident happens, application can read data from the slave and rely on it to return a full and current set of data.
• F.Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

Where is the default data directory located after installing MySQL using RPM on Oracle Linux 7?

• A./var/lib/mysql
• B./usr
• C./etc/my.cnf
• D./usr/bin
• E./usr/mysql