Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 111:

  Examine this statement and output: Which two SQL statements can jsmith execute? (Choose two.)

  

  A. UPDATE world.country SET Name='all';

  B. UPDATE world.country SET Name='one' LIMIT 1;

  C. UPDATE world.country SET Name='new' WHERE Name='old';

  D. UPDATE world.country SET Name=CONCAT('New ',Name);

  E. UPDATE world.country SET Name='first' ORDER BY Name LIMIT

  Correct Answer: AC

• Question 112:

  Examine these InnoDB Cluster parameter settings:

  

  Now examine the partial status:

  

  A permanent network failure isolates host3.

  Which two statements are true? (Choose two.)

  A. The instance deployed on host2 is elected as the new primary instance.

  B. The instance deployed on host3 is expelled from the cluster and must be rejoined using cluster.addInstance ('host3:3377')

  C. The instance deployed on host3 will automatically rejoin the cluster when connectivity is re-established.

  D. Failure of the instance deployed on host1 provokes an outage.

  E. The issuing command cluster.switchToMuitiPrimaryMode() will fail to enable multi- primary mode.

  F. The primary instance can be specified by using the command cluster.setPrimaryInstance(:).

  Correct Answer: CF

• Question 113:

  Your my.cnf file contains these settings:

  

  You want to log queries that looked at a minimum of 5000 records and either took longer than 5 seconds to run or did not use indexes.

  Which contains all the settings that you need to add to or modify the slow log configuration?

  A. min_examined_row_limit=5000

  B. long_query_time=5 log_throttle_queries_not_using_indexes=5

  C. log_throttle_queries_not_using_indexes=5 min_examined_ row_limit=5000

  D. long_query_time=5

  E. long_query_time=5 min_examined_row_limit=5000

  F. log_throttle_queries_not_using_indexes=5

  G. long_query_time=5 log_throttle_queries_not_using_indexes=5 min_examined_row_limit=5000

  Correct Answer: C

• Question 114:

  Examine this command, which executes successfully:

  

  Which statement is true?

  A. Only files for MySQL or Its built-in storage engines are backed

  B. Only non-encrypted files are backed up.

  C. The backup includes only data files and their metadata.

  D. Only InnoDB data and log files are backed up.

  E. Only tables stored in their own tablespaces are backed up.

  Correct Answer: D

• Question 115:

  You are upgrading a MySQL instance to the latest 8.0 version. Examine this output:

  

  You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?

  A. It defines all innodb tablespace options relative to a starting parent directory.

  B. It is not necessary because innodb_data_home_dir is already defined.

  C. It allows scanning of other locations to discover more innodb tablespaces.

  D. It moves all innodb tablespaces to the /innodb_extras directory to enable a new innodb_data_home_dir to be defined.

  E. It adds more temporary workspace in addition to the innodb_tmpdir location.

  Correct Answer: C

  Explanation: https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files- offline.html

• Question 116:

  How can mysql_multi be configured to allow MySQL instances to use the same port number?

  A. The instances use different user accounts unique to each instance.

  B. The instances listen on different IP addresses.

  C. The instances use different socket names.

  D. The instances have appropriate net masks set.

  Correct Answer: B

• Question 117:

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

  A. MyISAM

  B. NDB

  C. MEMORY

  D. ARCHIVE

  E. InnoDB

  Correct Answer: AC

  Reference:https://zetcode.com/mysql/storageengines/

• Question 118:

  Examine these statements, which execute successfully:

  CREATE ROLE r_world_rd;

  GRANT SELECT ON world.* TO r_world_rd;

  CREATE USER john IDENTIFIED BY `P@ssw0rd';

  GRANT r_world_rd TO john;

  Examine these statements issued by user John:

  

  What is the reason for the error?

  A. The statement was blocked by MySQL Firewall.

  B. John has not activated the role.

  C. John needs to reconnect to the database.

  D. The DBA needs to execute FLUSH PRIVILEGES.

  Correct Answer: B

• Question 119:

  Examine this command, which executes successfull mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

  A. The copy-back process is used to overwrite a new backup over an existing backup.

  B. It restores files from the data directory to their original MySQL server locations.

  C. It restores files from the backup directory to their original MySQL server locations.

  D. The copy-back process makes inconsistent backups.

  Correct Answer: AC

  Reference: https://dev.mysql.com/doc/mysql-enterprise- backup/3.11/en/restore.restore.html

• Question 120:

  You reconfigure and start a slave that was not replicating for several days.

  The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

  

  Which statement is true?

  A. Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa- aaaaaaaaaaaa transactions than the master.

  B. Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb- bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.

  C. Replication will fail because the master has already purged transactions with cccccccc- cccc-cccc- cccc-cccccccccccc GTIDs.

  D. Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc- cccccccccccc GTIDs.

  E. Replication will work.

  Correct Answer: A

  Reference: https://bugs.mysql.com/bug.php?id=86643