最新的Oracle 1z1-908免費考試真題

問題1

Consider this shell output and executed commands:
[root@oel7 ~]# ps aux | grep mysqld
mysql 2076 3.5 24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid
[root@oel7 ~]# kill -15 2076
Which statement is true about MySQL server shutdown?

A. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

B. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

C. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

D. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

正確答案: A

問題2

Examine this partial output for InnoDB Cluster status:

Which statement explains the state of the instance deployed on host2?

A. It has been removed from the cluster by using the command STOP GROUP_REPLICATION;

B. It can rejoin the cluster by using the command dba.rebootClusterFromCompleteOutage()

C. It has been expelled from the cluster because of a transaction error.

D. It can rejoin the cluster by using the command cluster.addInstance('<user>@host3:3377')

E. It can be recovered from a donor instance on host3 by cloning using the command cluster.rejoinInstance ('<user>@host3:3377')

正確答案: B

問題3

Examine this command, which executes successfull
mysqlbackup --defaults-file=/backups/server-my.cnf --backup-dir=/backups/full copy-back Which statement is true about the copy-back process?

A. It restores files from the backup directory to their original MySQL server locations.

B. The copy-back process is used to overwrite a new backup over an existing backup.

C. The copy-back process makes inconsistent backups.

D. It restores files from the data directory to their original MySQL server locations.

正確答案: A,B

問題4

Which two MySQL Shell commands are excluded from the InnoDB Cluster creation procedure? (Choose two.)

A. cluster.addInstance()

B. cluster.forceQuorumUsingPartitionOf()

C. dba.createCluster()

D. dba.checkInstanceConfiguration()

E. dba.configureInstance()

F. cluster.setPrimaryInstance()

G. dba.configureLocalInstance()

正確答案: B,F

問題5

Which three sets of item information are visible in the mysql system database? (Choose three.)

A. performance monitoring information

B. audit log events

C. time zone information and definitions

D. help topics

E. information about table structures

F. rollback segments

G. plugins

正確答案: D,F,G

問題6

Which two are contained in the InnoDB system tablespace (ibdata1) by default? (Chose two.)

A. doublewrite buffer

B. primary indexes

C. InnoDB Data Dictionary

D. user privileges

E. table data

F. change buffer

正確答案: A,C

問題7

Examine these entries from the general query log:

All UPDATE statements reference existing rows.
Which describes the outcome of the sequence of statements?

A. A deadlock occurs after innodb_lock_wait_timeout seconds.

B. Connection 24 experiences a lock wait timeout.

C. All statements execute without error.

D. A deadlock occurs immediately.

E. Connection 25 experiences a lock wait timeout.

正確答案: A

問題8

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 INDEX (Name);

B. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

C. ALTER TABLE world.city ADD SPATIAL INDEX (Population);

D. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

E. ALTER TABLE world.city ADD SPATIAL INDEX (Name);

F. ALTER TABLE world.city ADD INDEX (Population);

正確答案: F

最新的Oracle MySQL 8.0 Database Administrator - 1z1-908免費考試真題

聯系我們

站內鏈接

最新更新