mysql8 OCP 1Z0 |
您所在的位置：网站首页 › ocp题目 › mysql8 OCP 1Z0 |
mysql8 OCP 1Z0
|
前言
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 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 |
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】 （个人理解，不保证正确，恳请大拿指教）【本文地址】