2023年6月26日发(作者：)

mysql8OCP1Z0-908题库（持续更新）前⾔第1题1、Choose the best e these statements and output:mysql> GRANT PROXY ON accounting@localhost TO ’ ‘@’%’ ;mysql> SELECT USER(), CURRENT_USER(), @@proxy_user;Which statement is true?A) The user failed to define a username and the connecting username defaulted to ’ ‘@’%’.B) The user is authorized as the rsmith@localhost user.C) The user is authenticated as the anonymous proxy user ’ ‘@’%’.D) The user is logged in with --user=accounting as an option.E) The user is authorized as the accounting@localhost user.参考答案 ：【 C】 （个⼈理解，不保证正确，恳请⼤拿指教）第2题Which tow are use cased of My SQL asynchronous replication？（choose two.) A. You can scale reads by adding multiple slaves. B. You can scale writes by creating a replicated mesh. C. My SQL Enterprise Backup will automatically back up from an available slave. D. It guarantees near real-time replication between a master and slave. E. It allows backup to be done on the slave without impacting the master正确答案：【 A,E】第3题An existing asynchronous replication setup is running My SQL tow steps are a part of implementing GTIDreplication?(Choose tow.) A. On the slave,alter the My SQL master connection setting with:ALTER CHANNEL MASTER TOMATER_AUTO_POSITON=1; B. Enable GTID by executing this on the master and the slave:SET GLOBAL GTID_ENABLED=on; C. Execute this on the slave to enable GTID: START SLAVE IO_THREAD WITH GTID; D. On the slave,alter the My SQL master connection setting with:CHANGE MASTER TO MASTER_AUTO_POSTION=1; E. Restart My SQL(master and slave) with these options enabled:–gtid_mod=on–log-bin–log-slave-updates–enforce-gtid-consistency F. Execute this on the slave to enable GTID:RESET SLAVE;START SLAVE GTID_NEXT=AUTOMATIC正确答案： 【D,E】第4题Where is the default data directory located after installing My SQL using RPM on Oracle LInux? A. /etc/ B. /usr/mysql C. /usr D. /var/lib/mysql E. /usr/bin正确答案： 【E】第5题You plan to take daily full backups,which include the ndbinfo and sys(internal) command will back up thedatabases in parallel? A. mysqlpump --all-databases > full-backup-$(date+%Y%m%d).sql B. mysqlpump --include-databases=% > full-backup-$(date+%Y%m$d).sql C. mysqldump --all-databases > full_backup-$(date+%Y%m%d).sql D. mysqldump --single-transaction > full-backup-$(date+%Y%m%d).sql正确答案： 【C】第6题t is a non-empty InnoDB e these statements,which are executed in one sessioin:BEGIN:SELECT * FROM t FOR UPDATE;Which is true? A. mysqlcheck --analyze --all-database will execute normally on all tables and return a report. B. If OPTIMIZE LOCAL TABLE t;is invoked from another session ,it executes normally and returns the status. C. If OPTIMIZE TABLE; it will create a table lock on t and force a transaction rollback; D. If ANALYZE TABLE ; is invoked from the same session,it hangs until the transaction is committed or rolled back.正确答案：【 B】第7题You want to log only the changes made to the database objects and data on the My SQL log will do this bydefault A. binary log B. general query log C. slow query log D. error log E. audit log正确答案： 【A】第8题Which three are characteristics of a newly created role?(choose three.) is created as a locked account. B. It can be granted to user accounts. can be dropped using the DROP ROLE statement. can be protected with a password can be renamed using the RENAME ROLE statement. is stored in the table.正确答案： 【B,C,D】第9题Which four are types of information stored in the My SQL data dictionary?(Choose four.) A. access control lists. B. server configuration rollback. C. view definitions. D. server runtime configuration E. InnoDB buffer pool LRU management data F. table definitions G. performance metrics procedure definitions.正确答案： 【B,C,F,H】第10题Which statement is true about MySQL Enterprise Transparent Data Encryption (TDE)? A. Lost tablespace encryption keys can be regenerated only if the master database key is known orpresent in the Key Vault specification. B. Both MyISAM and InnoDB tables can be encrypted by setting the keyring_engine = ALL variable in the MySQLconfiguration file. C. TDE can encrypt InnoDB and MyISAM tables only when the tables are stored in the SYSTEMtablespace. D. MySQL TDE uses an appropriate keyring plugin to store the keys in a centralized location.正确答案： 【A】第11题You execute this command:shell> mysqlpump --exclude-databases=% --usersWhich statement is true? A. It creates a logical backup of all MySQL user accounts. B. It creates a logical backup of all metadata, but contains no table data. C. It returns an error because the mysqldump command should have been used. D. It creates a logical backup of only the users database.正确答案：【B】第12题Which two statements are true about InnoDB data-at-rest encryption? (Choose two.) A. It decrypts data for use in memory. B. It supports only non-blob datatypes. C. It supports all indexes transparently. D. It enforces encryption from disk to memory and over network transmission. E. It does not support the transportable tablespaces feature.正确答案: 【A,C】第13题You have a MySQL system with 500 GB of data that needs frequent use a mix of MyISAM and InnoDB storage engines for your data. Examine your backup requirement:The MySQL system being backed up can never be unavailable or locked to the client recovery from the backup must work on any 1 hour of data can be lost on recovery of the option fulfills all backup requirements? A. Use the Clone Plugin to copy the data to another MySQL system. B. Take a physical backup of the MySQL system. C. Take your backup from a slave of the MySQL system. D. Take a logical backup of the MySQL system.正确答案: 【D】第14题You have configured GTID-based asynchronous replication with one master and one slave.A user accidentally updated somedata on the fix this,you stopped replication and successfully reverted the accidental e the current GTID information:You must fix GTID sets on the slave to avoid replicating unwanted transactions in case of set of actions would allow the slave to continue replicating without erroneous transactions? A. RESET MASTER: SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167 B. SET GLOBAL gid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-9; RESET SLAVE; SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-3820 RESET MASTER; SET GLOBAL gtid_purged-aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-2312 RESET SLAVE; SET GLOBAL gtid_purged=aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1-10167正确答案：【D】第15题Which tow are features of MySQL Enterprise Firewall?(Choose tow.) ing incoming SQL statement to facilitate the creation of a whitelist of permitted commands; blocking of potential threats by confguring preapproved whitelists. modifying SQL statement dynamically with substitutions; automatic locking of user accounts who break your firewall provides stateless firewall access to TCP/3306正确答案：【B,C】第16题You wish to protect your MySQL database against SQL injection method would fail to do this? A. installing and configuring the Connection Control plugin B. avoiding concatenation of SQL statements and user-supplied values in an application C. using stored procedures for any database access D. using PREPARED STATEMENTS正确答案：【C】第17题Examine the modified outputSeconds_Behind_Master value is steadilky are tow possible causes ?(Choose tow.) A. The master is most probably too busy to transmit data and the slave needs to wait for more data. B. One or more large tables do not have primary keys. C. This value shows only I/O latency and is not indicative of the size of the transaction queue. D. The master is producing a large volume of events in parallel but the slave is processing them serially. E. The parallel slave threads are experiencing lock contention.正确答案：【C,D】第18题Which statement is true about InnoDB persistent index statistics? A. Updating index statistics is an I/O expensive operation. B. Index statistics are calculated from pages buffered in the buffer pool for tables with InnoDB storage ennine. C. Setting innodb_stats_auto_recalc=ON causes statistics to be updated automatically when a new index is created D. Execution plans based on transient index statistics improve precision when innodb_stas_persistent_sample_pages isincreased E. Increasing innodb_stats_persistent_sample_pages determines higher pages scanning speed,at the cost of increasedmemory usage. F Tables are scanned and index statistics recalculated when an instance is restarted.正确答案：【D】第19题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 ADD SPATIAL INDEX(NAME); B. ALTER TABLE ADD SPATIAL INDEX (Population); C. ALTER TABLE ADD INDEX(Population); D. ALTER TABLE ADD INDEX(Name); E. ALTER TABLER ADD FULLTEXT INDEX(Name); F. ALTER TABLE ADD FULLTEXT INDEX (Population);正确答案：【B】第20题The data in this instance is transient;no backup or replication will be reuqired . It is currently under performing.- The database size is static and including indexes is 19G- Total system memory is 32GAfter profiling the system,yoiu highlight these MySQL status and global variables;The OS metrics indicate that disk is a variables retain their default three chnges will provide the most benefit to the instance(Choose three.) _flush_log_at_trx_commit=1 _pool_size=24G _log_file_size=1G _binlog=0 _doublewrite=0 F. max_connections=10000 G. innodb_undo_directory=/dev/shm正确答案：【A,C,F】第21题Consider this shell output and executed commands:[root@oel7~] # ps aux|grep mysqldmysql 2076 3.5.24.6 1386852 372572 ? Ssl 12:01 0:01 /usr/sbin/mysqid[root@oel7~]#kill -15 2076Which statement is true about MySQL server shutdown? A. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld. B. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk. C. kill -15 carries out a normal shutdown process,such as mysqladmin shutdown. D. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the killcommand.正确答案：【C】第22题You must configure the MySQL command-line client to provide the highest level of trust and security when connection to aremote MySQL value of --ssl-mode will do this? A. PREFERRED B. VERIFY_CA C. REQUIRED D. VERIFY_IDENTITY正确答案：【C】