Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 131:

  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. 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.

  D. Reads from the slave can return outdated data until the value of the rpi_semi_sync_master_timeout variable is reached.

  E. Reads from the slave can return outdated data for some time, until it applies all transactions from its relay log.

  F. A small amount of committed transactions may be lost in case they were committed just before the disk failure.

  Correct Answer: BF

• Question 132:

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

  A. SELECT user,passwd FROM members WHERE user = `?';INSERT INTO members(`user','passwd') VALUES (`[email protected]',`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 members WHERE email = `INSERT INTO members(`email','passwd') VALUES (`[email protected]', `secret');--`;

  F. SELECT user, phone FROM customers WHERE name = `\; DROP TABLE users; --`;

  Correct Answer: DE

• Question 133:

  Which command enables rule-based MySQL Auditing capabilities?

  A. shell> mysql < audit_log_filter_linux_install.sql

  B. shell> mysqld --initialize --log-raw=audit.log

  C. mysql> INSTALL PLUGIN audit_log;

  D. mysql> INSTALL COMPONENT audit_log;

  Correct Answer: A

  Reference: https://dev.mysql.com/doc/mysql-security-excerpt/5.7/en/audit-log-filtering.html

• Question 134:

  Examine this command and output:

  

  Which two statements are true? (Choose two.)

  A. The lock is at the metadata object level.

  B. The lock is a shared lock.

  C. The lock is an intentional lock.

  D. The lock is at the table object level.

  E. The lock is a row-level lock.

  F. The lock is an exclusive lock.

  Correct Answer: EF

• Question 135:

  You are using an existing server with a new configuration. MySQL Server fails to start.

  Examine this snapshot of the error log:

  

  Which action would allow the server to start?

  A. Remove ib_logfile0 and ib_logfile1 files from the file system.

  B. Execute mysqladmin flush-logs.

  C. First run mysqld --initialize to refresh the Size of ib_logfile.

  D. Create a new ib_logfile0 file of size 26214400.

  Correct Answer: C

• Question 136:

  Examine this command, which executes successfully:

  mysqlpump --user=root --password > full_backup.sql

  Which two databases will be excluded from this dump? (Choose two.)

  A. information_schema

  B. world

  C. employee

  D. sys

  E. mysql

  Correct Answer: AD

  Reference: https://mysqlserverteam.com/introducing-mysqlpump/

• Question 137:

  Examine this MySQL Shell command:

  dba.rebootClusterFromCompleteOutage()

  Which two statements are true? (Choose two.)

  A. It reconfigures InnoDB Cluster if the cluster was stopped.

  B. It performs InnoDB Cluster instances rolling restart.

  C. It only starts 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 only stops and restarts all InnoDB Cluster instances.

  G. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.

  Correct Answer: BD

• Question 138:

  Which two statements are true about MySQL Installer? (Choose two.)

  A. It installs most Oracle MySQL products.

  B. It performs product upgrades.

  C. It provides only GUI-driven, interactive installations.

  D. Manual download of separate product packages is required before installing them through MySQL Installer.

  E. It provides a uniform installation wizard across multiple platforms.

  Correct Answer: BC

• Question 139:

  Examine this command, which executes successfully: cluster.addInstance(`@:', {recoveryMethod: `clone'}) Which three statements are true? (Choose three.)

  A. The account used to perform this recovery needs the BACKUP_ADMIN privilege.

  B. A target instance must exist, then it will be provisioned with data from an instance already in the cluster and joined to the cluster.

  C. InnoDB tablespaces outside the datadir are able to be cloned.

  D. It is always slower than {recoveryMethod: `incremental'}.

  E. A new instance is installed, initialized, and provisioned with data from an instance already in the cluster and joined to the cluster.

  F. InnoDB redo logs must not rotate for the duration of the execution; otherwise, the recovery will fail.

  Correct Answer: ADF

• Question 140:

  Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

  A. dba.configureInstance()

  B. cluster.setPrimaryInstance()

  C. dba.configureLocalInstance()

  D. cluster.forceQuorumUsingPartitionOf()

  E. cluster.addInstance()

  F. dba.createCluster()

  G. dba.checkInstanceConfiguration()

  Correct Answer: BD

  Reference: https://docs.oracle.com/cd/E17952_01/mysql-shell-8.0-relnotes-en/news-8-0- 16.html