Oracle Oracle Certifications 1Z0-908 Questions & Answers

• Question 91:

  Which step or set of steps can be used to rotate the error log?

  A. Execute SET GLOBAL log_error = `'.

  B. Execute SET GLOBAL max_error_count = .

  C. Execute SET GLOBAL expire_logs_days=0 to enforce a log rotation.

  D. Rename the error log file on disk, and then execute FLUSH ERROR LOGS.

  Correct Answer: D

  Reference: https://blog.pythian.com/mysql-log-rotation/

• Question 92:

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

  Correct Answer: C

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

• Question 93:

  You have configured MySQL Enterprise Monitor to monitor your MySQL server.

  Which four features are available? (Choose four.)

  A. starting and stopping the MySQL instance

  B. tracing import and export with mysqidump

  C. deploying the MySQL agent on supported target operating system

  D. creating e-mail alerts and SNMP traps for MySQL warnings

  E. monitoring the availability of the MySQL instance

  F. analyzing executed MySQL queries

  G. monitoring of NDB Cluster API nodes

  Correct Answer: BDEF

• Question 94:

  You made some table definition changes to a schema in your MySQL Server.

  Which two statements reflect how MySQL Server handles the table definition changes? (Choose two.)

  A. MySQL writes SDI to the binary log for distributed backups.

  B. MySQL keeps InnoDB metadata changes in .sdi files in datadir.

  C. The metadata is serialized in JSON format in Serialized Dictionary Information (SDI).

  D. MySQL Server stores a copy of the serialized data in the InnoDB user tablespace.

  E. MySQL implicitly executes FLUSH TABLES and stores a snapshot backup of the metadata.

  Correct Answer: CD

• Question 95:

  You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them. Your goal is to decrease the amount of data that is transferred between these two hosts.

  It is confirmed that the slave instance does not need to have data from the example database.

  Which replication filter contributes to your goal?

  A. on slave: --replicate-wild-ignore=example.%

  B. on slave: --replicate-ignore-db=example

  C. on master: --replicate-ignore-db=example

  D. on master: --binlog-ignore-db=example

  E. on slave: --binlog-ignore-db=example

  Correct Answer: C

• Question 96:

  Which two statements are true about MySQL server multi-source replication? (Choose two.)

  A. It is not compatible with auto-positioning.

  B. It needs to be re-instanced after a crash to maintain consistency.

  C. It uses only time-based replication conflict resolution.

  D. It relies on relay_log_recovery for resilient operations.

  E. It does not attempt to detect or resolve replication conflicts.

  F. It must use GTID replication.

  Correct Answer: CF

• Question 97:

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

  A. performance metrics

  B. InnoDB buffer pool LRU management data

  C. access control lists

  D. view definitions

  E. server runtime configuration

  F. server configuration rollback

  G. stored procedure definitions

  Correct Answer: ADE

• Question 98:

  Examine these commands and output:

  

  Which connection ID is holding the metadata lock?

  A. 20

  B. 24

  C. 21

  D. 25

  E. 22

  F. 6

  Correct Answer: D

• Question 99:

  Examine this command, which executes successfully:

  shell> mysqldump --master-data=2 --single-transaction --result-file=dump.sql mydb

  Which two statements are true? (Choose two.)

  A. It executes flush tables with read lock.

  B. It enforces consistent backups for all storage engines.

  C. The backup created is a consistent data dump.

  D. This option uses the READ COMMITTED transaction isolation mode.

  E. It is a cold backup.

  Correct Answer: AD

  Reference: https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_single- transaction

• Question 100:

  Which two statements are true about the binary log encryption feature? (Choose two.)

  A. It encrypts any connecting slaves connection thread.

  B. It can be set at run time.

  C. It requires a keyring plugin.

  D. When enabled it encrypts existing binary logs.

  E. It can be activated per session.

  Correct Answer: AE