Oracle 1Z0-908 問題集

質問 1：
Which three are types of information stored in the MySQL data dictionary? (Choose three.)
A. access control lists
B. view definitions
C. server runtime configuration
D. performance metrics
E. server configuration rollback
F. stored procedure definitions
G. InnoDB buffer pool LRU management data
正解：B,C,D

質問 2：
Examine this command, which executes successfully:

Which statement is true?
A. Only files for MySQL or Its built-in storage engines are backed
B. Only InnoDB data and log files are backed up.
C. Only non-encrypted files are backed up.
D. The backup includes only data files and their metadata.
E. Only tables stored in their own tablespaces are backed up.
正解：B

質問 3：
Examine this MySQL Shell command:
dba.rebootClusterFromCompleteOutage()
Which two statements are true? (Choose two.)
A. It picks the minimum number of instances necessary to rebuild the quorum and reconfigures InnoDB Cluster.
B. It is not mandatory that all instances are running and reachable before running the command.
C. It performs InnoDB Cluster instances rolling restart.
D. It only stops and restarts all InnoDB Cluster instances.
E. It only starts all InnoDB Cluster instances.
F. It reconfigures InnoDB Cluster if the cluster was stopped.
G. It stops and restarts all InnoDB Cluster instances and initializes the metadata.
正解：B,C

質問 4：
Examine this command, which executes successfully:
mysqlpump --user=root --password > full_backup.sql
Which two databases will be excluded from this dump? (Choose two.)
A. mysql
B. world
C. information_schema
D. sys
E. employee
正解：C,D

質問 5：
Which two are true about binary logs used in asynchronous replication? (Choose two.)
A. They contain events that describe only administrative commands run on the master.
B. They contain events that describe database changes on the master.
C. They are pushed from the master to the slave.
D. They are pulled from the master to the slave.
E. They contain events that describe all queries run on the master.
正解：B,C