Oracle 1Z0-908 Online Practice Questions and Exam Preparation

Oracle 1Z0-908 Online Questions & Answers

• Question 1:

  Which condition is true about the use of the hash join algorithm?

  A. No index can be used for the join.
  B. The query must access no more than two tables.
  C. The smallest of the tables in the join must fit in memory as set by join_buffer_size.
  D. At least one of the tables in the join must have a hash index.
  B. The query must access no more than two tables.

• Question 2:

  Which three sets of item information are visible in the mysql system database? (Choose three.)

  A. help topics
  B. performance monitoring information
  C. plugins
  D. information about table structures
  E. audit log events
  F. rollback segments
  G. time zone information and definitions
  A. help topics
  C. plugins
  F. rollback segments

• Question 3:

  What is the correct syntax for using transparent data encryption with an existing InnoDB table?

  A. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';
  B. ALTER TABLE t1 ENCRYPTION='Y';
  C. ALTER TABLE t1 WITH ENCRYPTION USING MASTER KEY;
  D. ALTER TABLE t1 SET TDE = 'ON';
  A. ALTER TABLE t1 ADD ENCRYPTED_TABLESPACE = 'Y';

• Question 4:

  You want to log only the changes made to the database objects and data on the MySQL system.

  Which log will do this by default?

  A. general query log
  B. audit log
  C. slow query log
  D. binary log
  E. error log
  D. binary log

• Question 5:

  Consider this shell output and executed commands:

  [root@oel7 ~]# ps aux | grep mysqld

  mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid

  [root@oel7 ~]# kill -15 2076

  Which statement is true about MySQL server shutdown?

  A. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.
  B. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.
  C. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.
  D. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.
  C. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

• Question 6:

  Which two are characteristics of snapshot-based backups? (Choose two.)

  A. Snapshot-based backups greatly reduce time during which the database and applications are unavailable.
  B. There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.
  C. The frozen file system can be cloned to another virtual machine immediately into active service.
  D. A separate physical copy must be made before releasing the snapshot backup.
  E. Snapshot backups can be used only in virtual machines.
  D. A separate physical copy must be made before releasing the snapshot backup.
  E. Snapshot backups can be used only in virtual machines.

• Question 7:

  Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()

  Which two statements are true? (Choose two.)

  A. Group Replication will be dissolved and all metadata purged.
  B. Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.
  C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
  D. The command drops the mysql_innodb_cluster_metadata schema and re-creates it.
  E. The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.
  F. Connections driven by MySQL Router are not affected by the command.
  C. The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.
  F. Connections driven by MySQL Router are not affected by the command.

  ---

  explanation:

  Explanation/Reference:

• Question 8:

  Examine this output: Which change should optimize the number of buffer pool instances for this workload?

  

  A. Increase the number of buffer pool instances to 16.
  B. Increase the number of buffer pool instances to 32.
  C. Decrease the number of buffer pool instances to 1.
  D. Increase the number of buffer pool instances to 12.
  E. Decrease the number of buffer pool instances to 4.
  B. Increase the number of buffer pool instances to 32.

• Question 9:

  You have a MySQL client installed on your Linux workstation with a default installation. You have your admin login credentials to connect to a MySQL server running Microsoft Windows on remote host 192.0.2.1:3306. You wish to connect directly to the world database.

  Which four options need to be specified to complete this task with a single command? (Choose four.)

  A. --shared-memory-base-name=world
  B. --protocol=UDP
  C. --protocol=pipe
  D. --password
  E. --user=admin
  F. --host=192.0.2.1
  G. --socket=/tmp/mysql.sock
  H. --port=3306
  I. --database=world
  A. --shared-memory-base-name=world
  C. --protocol=pipe
  D. --password
  F. --host=192.0.2.1

• Question 10:

  Which two are true about binary logs used in asynchronous replication? (Choose two.)

  A. They are pushed from the master to the slave.
  B. They contain events that describe database changes on the master.
  C. They contain events that describe all queries run on the master.
  D. They contain events that describe only administrative commands run on the master.
  E. They are pulled from the master to the slave.
  A. They are pushed from the master to the slave.
  B. They contain events that describe database changes on the master.

  ---

  explanation:

  Explanation/Reference:

  Reference: https://www.oracle.com/technetwork/community/developer-day/mysql- replication-presentation- 485890.pdf (14)