考試題量：85
通過分?jǐn)?shù)：62%
官方考試說明：https://education.oracle.com/產(chǎn)品目錄-ouexam-pexam_1z0-908/pexam_1Z0-908

Q1.Examine this command, which executes successfully:
mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup- dir=/export/backups backup-and-apply-log
Which statement is true?
A)The backup accesses the MySQL server files by using a pre-existing connection.
B)The database server is put into a read-only state for the duration of the backup. C)An offline backup of InnoDB tables is taken.
D)The backup can be impacted when DDL operations run during the backup.
Answer:D
參見《MySQL8.0 for Database Administrators studentGuide 2》243頁
While the non-InnoDB backup runs:
— Prior to version 8.0.16, the database cannot be modified
— As of version 8.0.16, only non-InnoDB tables cannot be modified and InnoDB tables allow DML operations but not DDL operations

Q2.You reconfigure and start a slave that was not replicating for several days.
The configuration file and CHANGE MASTER command are correct. Examine the GTID information from both master and slave:

Master: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-321, bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-50, Cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-100, bbbbbbbb-bbbb-bbbb-bbbbbbbbbbbb:1-10, cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237Slave: Gtids_executed: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-160, cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237Gtids_purged: aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-70, cccccccc-cccc-cccc-cccc-cccccccccccc:1234-1237

Which statement is true?
A)Replication will fail because the master does not have the required transaction with bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb GTIDs in its binary logs.
B)Replication will fail because the master has already purged transactions with cccccccc-cccc-cccc-cccc-cccccccccc GTIDs.
C)Replication will fail because of inconsistent numbers in cccccccc-cccc-cccc-cccc-cccccccccccc GTIDs.
D)Replication will fail because the slave has purged more aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa transactions than the master.
E)Replication will work.
Answer:A

Q3.Which two authentication plugins require the plain text client plugin for authentication to work?
A)Windows Native authentication B)PAM authentication
C)LDAP SASL authentication D)LDAP authentication E)SHA256 authentication F)MySQL Native Password
Answer:BD
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html

Q4.You want to log only the changes made to the database objects and data on the MySQL system. Which log will do this by default?
A)error log
B)slow query log
C) general query log
D)binary log
E)audit log
Answer:D

Q5.You have an installation of MySQL 8 on Oracle Linux. Consider the outputs:

Mysql>SHOW GLOBAL VARIABLES WHERE Varisble_name=’tmpdir‘ OR Variable_name =’ tmp_table_size; +------------------+-----------+ | Variable_name |Value | +------------------------+-----+ |tmp_tabe_size | 16777216| |tmpdir | /tmp | +-------------------+----------+ Shell>cd/var/lib/mysql Shell>ls -1|grep temp Drwxr-x---.2 mysql mysql 4096 Dec 11 14:05 #innodb_temp

Which statement is true about disk temporary tables for this installation? A)Temporary tables are created in tmpdir only if configured to use MyISAM。 B)Temporary tables are created in tmpdir only after they reach tmp_table_size. C)Temporary tables will use the InnoDB temporary tablespace located in datadir. D)Only internal temporary tables from the optimizer will be created in tmpdir.
E)Temporary tables will use the InnoDB temporary tablespace located in /tmp. Answer:C
超過tmp_table_size 和max_heap_table_size最小值的臨時(shí)表創(chuàng)建到磁盤上。 Tmpdir目錄下創(chuàng)建的是臨時(shí)文件，默認(rèn)是/tmp
InnoDB用戶創(chuàng)建的臨時(shí)表和磁盤上的內(nèi)部臨時(shí)表是在MySQL數(shù)據(jù)目錄中名為ibtmp1的臨 時(shí)表空間文件中創(chuàng)建的，是全局臨時(shí)表空間。#innodb_temp 目錄下是會(huì)話臨時(shí)表空間 參見官方文檔: 15.6.3.5 Temporary Tablespaces 在另外一個(gè)題庫里選兩個(gè)，就加上A。

Q6.Which two actions will secure a MySQL server from network-based attacks?
A)Use MySQL Router to proxy connections to the MySQL server.
B)Place the MySQL instance behind a firewall.
C)Use network file system (NFS) for storing data.
D)Change the listening port to 3307.
E)Allow connections from the application server only.
Answer:BE

關(guān)于作者

姚遠(yuǎn)：Oracle ACE（Oracle和MySQL數(shù)據(jù)庫方向 http://apex.oracle.com/pls/apex/aces/d/yuan.yao），華為云MVP，曾任IBM公司數(shù)據(jù)庫部門經(jīng)理。擁有包括Oracle 10g和12c OCM在內(nèi)的20多項(xiàng)數(shù)據(jù)庫相關(guān)技術(shù)認(rèn)證，數(shù)據(jù)庫類暢銷書《MySQL 8.0運(yùn)維與優(yōu)化》的作者。
需要更多OCP認(rèn)證考試資料的請加我的微信👇

總結(jié)

以上是生活随笔為你收集整理的MySQL 8.0 OCP 1Z0-908认证考试题库1的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。