Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 41:

  Examine this command and output:

  

  Which statement is true?

  A. Firewall_cached_entries is the number of statements found in the query cache for users in DETECTING mode.

  B. Firewall_access_denied is the number of connection attempts from prohibited hosts that are denied.

  C. Firewall_access_suspicious is the number of statements logged as suspicious for users in DETECTING mode.

  D. Firewall_access_granted is the number of connections granted from whitelisted hosts.

  Correct Answer: C

• Question 42:

  You have an InnoDB Cluster configured with three servers.

  Examine this command, which executes successfully:

  mysqldump -uroot -p -d mydatabase > mydatabase_backup.sql

  Due to data loss, the cluster is initialized and a restore is attempted resulting in this error:

  ERROR 13176 (HY000) at line 23: Cannot update GTID_PURGED with the Group Replication plugin running

  Which two actions, either one of which, can fix this error and allow a successful restore of the cluster? (Choose two.)

  A. Stop all instances except the primary read/write master instance and run the restore.

  B. Remove the @@GLOBAL.gtid_purged statement from the dump file.

  C. Create the backup by using the --set-gtid-purged=OFF option.

  D. Remove the group replication plugin from each instance before restoring.

  E. Remove the @@GLOBAL.gtid_executed statement from the dump file.

  F. Restore using the --set-gtid-purged=OFF option.

  Correct Answer: BC

  Reference: https://scriptingmysql.wordpress.com/2013/07/18/mysql-creating-and-restoring- database-backups- with-mysqldump-and-mysql-enterprise-backup-part-1-of-2/

• Question 43:

  You want to dump all databases with names that start with "db".

  Which command will achieve this?

  A. mysqlpump --include-tables=db.% --result-file=all_db_backup.sql

  B. mysqlpump > all_db_backup.sql

  C. mysqlpump --include-databases=db --result-file=all_db_backup.sql

  D. mysqlpump --include-databases=db% --result-file=all_db_backup.sql

  Correct Answer: C

• Question 44:

  Which two statements are true about the mysql_config_editor program? (Choose two.)

  A. It manages the configuration of the MySQL Firewall feature.

  B. It manages the configuration of client programs.

  C. It can move datadir to a new location.

  D. It manages the configuration of user privileges for accessing the server.

  E. It will use [client] options by default unless you provide --login-path.

  F. It can be used to create and edit SSL certificates and log locations.

  G. It provides an interface to change my.cnf files.

  Correct Answer: BE

  Reference: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html

• Question 45:

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

  

  A. The root user had the largest number of modified rows for a SELECT statement.

  B. User bob had the largest total time waiting for locks.

  C. The root user had the largest single wait time.

  D. The app user had the highest total number of rows read from storage engines.

  E. User bob had a significantly higher ratio of SELECT + INSERT statements to QUIT than both app and root users.

  Correct Answer: DE

• Question 46:

  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.

  Correct Answer: AEF

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

• Question 47:

  Examine this statement, which executes successfully:

  

  Now examine this query:

  

  Which two statements can do this? (Choose two.)

  A. ALTER TABLE employees ADD INDEX (birth_date DESC);

  B. ALTER TABLE employees ADD INDEX ((MONTH(birth_date)));

  C. ALTER TABLE employees ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (MONTH(birth_date)) VIRTUAL NOT NULL, ADD INDEX (birth_month);

  D. ALTER TABLE employees ADD COLUMN birth_month tinyint unsigned GENERATED ALWAYS AS (birth_date- >>'$.month') VIRTUAL NOT NULL, ADD INDEX (birth_month);

  E. ALTER TABLE employees ADD INDEX ((CAST(birth_date->>'$.month' AS unsigned)));

  F. ALTER TABLE employees ADD INDEX (birth_date);

  Correct Answer: AD

• Question 48:

  Which four are types of information stored in the MySQL data dictionary? (Choose four.)

  A. performance metrics

  B. table definitions

  C. access control lists

  D. view definitions

  E. server runtime configuration

  F. server configuration rollback

  G. stored procedure definitions

  H. InnoDB buffer pool LRU management data

  Correct Answer: BDFG

• Question 49:

  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.

  Correct Answer: A

• Question 50:

  MySQL programs look for option files in standard locations.

  Which method will show the option files and the order in which they are read?

  A. shell> mysqladmin --debug

  B. shell> mysql --print-defaults

  C. shell> mysqld --help --verbose

  D. mysql> SHOW GLOBAL VARIABLES;

  Correct Answer: A