Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 51:

  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'@'%'

  Correct Answer: CE

• Question 52:

  Examine this list of MySQL data directory binary logs:

  binlog.000001 binlog.000002

  .....

  binlog.000289

  binlog.000300

  binlog.000301

  binlog.index

  Now examine this command, which executes successfully:

  mysqldump --delete-master-logs --all-databases > /backup/db_backup.sql

  Which two are true? (Choose two.)

  A. All databases are backed up to the output file.

  B. All non-active binary logs are removed from the master.

  C. All binary logs are deleted from the master.

  D. All binary logs are backed up and then deleted.

  E. All databases, excluding master metadata, are backed up to the output file.

  F. All details regarding deleted logs and master metadata are captured in the output file.

  Correct Answer: CE

• Question 53:

  Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)?

  A. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.

  B. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQL configuration file.

  C. Lost tablespace encryption keys can be regenerated only if the master database key is known or present in the Key Vault specification.

  D. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEM tablespace.

  Correct Answer: C

  Reference: https://www.mysql.com/products/enterprise/tde.html

• Question 54:

  Which three are types of InnoDB tablespaces? (Choose three.)

  A. redo tablespaces

  B. encryption tablespaces

  C. schema tablespaces

  D. data tablespaces

  E. undo tablespaces

  F. temporary table tablespaces

  Correct Answer: BDF

• Question 55:

  You must configure the MySQL command-line client to provide the highest level of trust and security when connecting to a remote MySQL Server. Which value of --ssl-mode will do this?

  A. PREFERRED

  B. VERIFY_CA

  C. REQUIRED

  D. VERIFY_IDENTITY

  Correct Answer: C

  Reference: https://techdocs.broadcom.com/us/en/ca-enterprise-software/layer7-api- management/api- gateway/10-0/install-configure-upgrade/enable-ssl-connections-for- mysql.html

• Question 56:

  You are asked to review possible options for a new MySQL instance. It will be a large, busy reporting data warehousing instance.

  [mysql]

  innodb_data_file_path=

  Which two configurations would satisfy long-term storage demands? (Choose two.)

  A. ibdatal:12M;ibdata2:12M;ibdata3:12M

  B. ibdatal:12M:autoextend;ibdata2:12M:autoextend

  C. ibdatal:12M:autoextend

  D. ibdatal:12M;ibdata2:12M:autoextend

  E. ibdatal:12M

  F. ibdatal:12M;/tmp/ibdata2:12M:autoextend

  Correct Answer: AE

• Question 57:

  Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

  A. TCP

  B. SOCKET

  C. PIPE

  D. DIRECT

  E. IPv6

  F. FILE

  G. IPv4

  H. MEMORY

  Correct Answer: ABCH

  Reference: https://dev.mysql.com/doc/refman/8.0/en/connection-options.html

• Question 58:

  The mysqld instance has the connection control plugin enabled with these settings: connection_control_min_connection_delay=1000 connection_control_max_connection_delay=2000

  The minimum and maximum delays need to be increased to 3000 and 5000, respectively.

  A command is executed:

  mysql> SET GLOBAL connection_control_min_connection_delay=3000;

  What is the result?

  A. The minimum value increases to 3000 and the maximum value increases to 4000.

  B. Only the minimum connection value is increased to 3000.

  C. The minimum connection value is changed to 2000.

  D. An error is returned.

  Correct Answer: B

• Question 59:

  Examine this query and output: Which two statements are true? (Choose two.)

  

  A. The country table is accessed as the first table, and then joined to the city table.

  B. It takes more than 8 milliseconds to sort the rows.

  C. The optimizer estimates that 51 rows in the country table have Continent = `Asia'.

  D. 35 rows from the city table are included in the result.

  E. The query returns exactly 125 rows.

  Correct Answer: CD

• Question 60:

  t is a non-empty InnoDB table.

  Examine these statements, which are executed in one session:

  BEGIN;

  SELECT * FROM t FOR UPDATE;

  Which is true?

  A. If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

  B. If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

  C. mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.

  D. If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

  Correct Answer: B