Oracle Oracle Database 1Z0-908 Questions & Answers

• Question 1:

  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';

  Correct Answer: A

• 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

  Correct Answer: ACF

• Question 3:

  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.

  Correct Answer: B

• 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

  Correct Answer: D

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

  Correct Answer: C

• Question 6:

  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.

  Correct Answer: CF

• Question 7:

  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.

  Correct Answer: DE

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

  Correct Answer: B

• 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

  Correct Answer: ACDF

• Question 10:

  A user wants to connect without entering his or her username and password on the Linux command prompt.

  Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

  A. $HOME/.my.cnf file

  B. $MYSQL_HOME/my.cnf file

  C. DATADIR/mysqld-auto.cnf file

  D. $HOME/.mylogin.cnf file

  E. $HOME/.mysql/auth/login file

  F. /etc/my.cnf file

  G. $HOME/.mysqlrc file

  Correct Answer: BCF

  Reference: https://dev.mysql.com/doc/refman/8.0/en/option-files.html