Oracle 1Z0-908 問題集

質問 1：
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?
A. The archive tables are backed up first, then the transaction tables and redo logs.
B. The redo logs are backed up first, then the transaction and archive tables.
C. The redo logs are backed up only if there are changes showing for the transactions tables.
D. The redo logs are not backed up at all.
E. The transaction tables are backed up first, then the archive tables and redo logs.
正解：C

質問 2：
Which two storage engines provide a view of the data consistent with the storage system at any moment?
(Choose two.)
A. InnoDB
B. MEMORY
C. MyISAM
D. ARCHIVE
E. NDB
正解：B,C

質問 3：
A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
A. ibdata1
B. undo_001
C. ib_buffer_pool
D. ibtmp1
E. ib_logfile0
F. mysql.ibd
正解：C,F

質問 4：
You have upgraded the MySQL binaries from 5.7.28 to 8.0.18 by using an in-place upgrade.
Examine the message sequence generated during the first start of MySQL 8.0.18:

Which step or set of steps will resolve the errors?
A. Remove the redo logs. Replace the MySQL binaries with the 5.7.28 binaries. Prepare the tables for upgrade. Upgrade to 8.0.18 again.
B. Execute: mysqlcheck --check-upgrade mysql columns_priv event proc proxies_priv tables_priv.
C. Execute: mysqlcheck --repair mysql columns_priv event proc proxies_priv tables_priv.
D. Go to the <datadir>/mysql directory and execute: myisamchk --update-state columns_priv event proc proxies_priv tables_priv.
E. Start mysqld again using the --upgrade=FORCE option.
正解：E

質問 5：
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. mysql> SHOW GLOBAL VARIABLES;
B. shell> mysql --print-defaults
C. shell> mysqladmin --debug
D. shell> mysqld --help --verbose
正解：C