mysql8 OCP 1Z0-908题库（持续更新）

前言

OCP考试准备中，网上找到的竟然都只有题目，没有答案……崩溃，老铁门对于OCP考试来说，只有题目没有答案等于0呀
欢迎大家收藏转载，请附上链接https://blog.csdn.net/wyp_810618/article/details/124651379，谢谢

第1题

1、Choose the best answer.
Examine 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 8.Which tow steps are a part of implementing GTID replication?(Choose tow.)

• A. On the slave,alter the My SQL master connection setting with:ALTER CHANNEL MASTER TO MATER_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/my.cnf
• 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) databases.Which command will back up the databases in parallel?

• A. mysqlpump --all-databases > full-backup-$(date+%Y%m%d).sql
• B. mysqlpump --include-databases=% > full-backup-$(date+%Y%m$d).sql