Oracle 1Z0-908 Online Practice Questions and Exam Preparation

Oracle 1Z0-908 Online Questions & Answers

• Question 1:

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

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

• Question 2:

  Examine these statements, which execute successfully: TRUNCATE test; BEGIN;

  INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;

  SELECT id FROM test;

  Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)

  A. NDB
  B. ARCHIVE
  C. InnopB
  D. BLACKHOLE
  E. MEMORY
  F. MyISAM
  A. NDB
  D. BLACKHOLE
  F. MyISAM

  ---

  Explanation/Reference:

  Reference: https://dev.mysql.com/doc/refman/5.6/en/blackhole-storage-engine.html

• Question 3:

  Which three are characteristics of a newly created role? (Choose three.)

  A. It can be dropped using the DROP ROLE statement.
  B. It is stored in the mysql.role table.
  C. It is created as a locked account.
  D. It can be renamed using the RENAME ROLE statement.
  E. It can be granted to user accounts.
  F. It can be protected with a password.
  A. It can be dropped using the DROP ROLE statement.
  E. It can be granted to user accounts.
  F. It can be protected with a password.

  ---

  Explanation/Reference:

  https://dev.mysql.com/doc/refman/8.0/en/roles.html https://www.mysqltutorial.org/mysql-roles/

• Question 4:

  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.
  B. The instances listen on different IP addresses.

• Question 5:

  Which three actions are effective in capacity planning? (Choose three.)

  A. buying more RAM
  B. monitoring OS resources for patterns
  C. adding circular replication nodes for increased DML capability
  D. buying more CPU
  E. buying more disk
  F. basing expected growth on an average of the last 3 years
  G. consulting the application team about any future projects and use
  H. upgrading to the latest application version
  B. monitoring OS resources for patterns
  F. basing expected growth on an average of the last 3 years
  G. consulting the application team about any future projects and use

• Question 6:

  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.
  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.
  F. A small amount of committed transactions may be lost in case they were committed just before the disk failure.

• Question 7:

  Examine this statement, which executes successfully:

  

  You want to improve the performance of this query:

  

  Which change enables the query to succeed while accessing fewer rows?

  A. ALTER TABLE world.city ADD SPATIAL INDEX (Name);
  B. ALTER TABLE world.city ADD SPATIAL INDEX (Population);
  C. ALTER TABLE world.city ADD INDEX (Population);
  D. ALTER TABLE world.city ADD INDEX (Name);
  E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);
  F. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);
  C. ALTER TABLE world.city ADD INDEX (Population);

  ---

  Explanation/Reference:

  Reference: https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

• Question 8:

  Which statement is true about InnoDB persistent index statistics?

  A. Updating index statistics is an I/O expensive operation.
  B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage engine.
  C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created.
  D. Execution plans based on transient index statistics improve precision when innodb_stats_persistent_sample_pages is increased.
  E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed, at the cost of increased memory usage.
  A. Updating index statistics is an I/O expensive operation.

• Question 9:

  Which two are valid uses for binary logs on a MySQL instance? (Choose two.)

  A. recording the order in which queries are issued
  B. audit of all queries
  C. point-in-time recovery
  D. replication
  E. logging the duration and locks for all queries
  A. recording the order in which queries are issued
  C. point-in-time recovery

• Question 10:

  Examine Joe's account:

  CREATE USER 'joe'@'%' IDENTIFIED BY '*secret*'

  GRANT ALL PRIVILEGES ON *.* TO 'joe'@'%'

  All existing connections for joe are killed.

  Which two commands will stop joe establishing access to the MySQL instance? (Choose two.)

  A. ALTER USER 'joe'@'%' ACCOUNT LOCK
  B. ALTER USER 'joe'@'%' SET password='*invalid*'
  C. REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'
  D. ALTER USER 'joe'@'%' PASSWORD HISTORY 0
  E. ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE
  F. REVOKE USAGE ON *.* FROM 'joe'@'%'
  C. REVOKE ALL PRIVILEGES ON *.* FROM 'joe'@'%'
  E. ALTER USER 'joe'@'%' IDENTIFIED BY '*invalid*' PASSWORD EXPIRE

  ---

  Explanation/Reference: