ocp-mysql8.0英文版1z0- 908(1)_在线真题试卷与模拟练习_ocp-mysql8.0英文版1z0- 908(1)_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Q1.Examine this command, which executes successfully: mysqlbackup --user=dba --password --port=3306 --with-timestamp --backup-dir=/export/backups backup-and-

master and slave: Master:

master. F)Replication will work.

Q4.You want to log only the changes made to the database objects and data on the MySQL system. Which log will

MIN_TIMER_WAIT:395922

Index_type:BTR(　　)

type backups taken before the upgrades.

Q21.You encountered an insufficient privilege error in the middle of(　　)long transaction. The database administrator is informed and immediately grants the required privilege: GRANT UPDATE ON world.city TO 'user1'; How can you proceed with your transaction with the least interruption? A)Roll back the transaction and start the transaction again in the same session. B)Change the default database and re-execute the failed statement in your transaction. C)Re-execute the failed statement in your transaction. D)Close the connection, reconnect, and start the transaction again. Answer:C Q22.An existing asynchronous replication setup is running MySQL 8. Which two steps are(　　)part of implementing GTID replication? A)On the slave, alter the MySQL master connection setting with: CHANGE MASTER TO MASTER_AUTO_POSITION = 1; B)Execute this on the slave to enable GTID: RESET SLAVE; START SLAVE GTID_NEXT = AUTOMATIC; C)Enable GTID by executing this on the master and the slave: SET GLOBAL GTID_ENABLED = on; D)Restart MySQL (master and slave) with these options enabled: --gtid_mode=ON --log-bin --log-slave-updates --enforce-gtid-consistency E)On the slave, alter the MySQL master connection setting with: ALTER channel CHANGE MASTER TO MASTER_AUTO_POSITION = 1; F)Execute this on the slave to enable GTID: START SLAVE IO_THREAD WITH GTID; Answer:AD Q23.You are using mysqlcheck for server maintenance. Which two statements are true? A)The mysqlcheck --optimize --all-databases command reclaims free space from table files. B)The mysqlcheck --analyze --all-databases command performs(　　)series of checks to spot eventual table

login credentials to connect to(　　)MySQL server running Microsoft Windows on remote host 192.0.2.1:3306 to

performance_schema table can you query? A)global_variables

Q38.Which two are true about binary logs used in asynchronous replication? A)They are pulled from the master to the slave. B)They are pushed from the master to the slave. C)They contain events that describe all queries run on the master. D)They contain events that describe only administrative commands run on the master. E)They contain events that describe database changes on the master. AnswernAE Q39. Which three actions will secure a MySQL server from network-based attacks?

12n49:05 InooDB; Completed Initializing of buffer poo InnoDB:Error:log file ./ib_logfiiel0 is of different size 0 5242880 bytes InnoDB than specified in the .cnf fiel 0 26214400 bytes 1 190925 12:49:05 [ERROR] Plugin ‘InnoDB’ init function returned error. 190925 12:49:05 [ERROR] Plugin ‘InnoDB’registation as(　　)STORAGE PNGINR failed 190925 12:49:05 [ERROR] Plugin ‘Aborting 190925 12:49:05 [ERROR] Plugin ‘/usr/sbin/mysqld:Shutdown complete Which action would allow the server to start? A)Remove ib_logfile0 and ib_logfile1 files from the file system. B)Execute mysqladmin flush-logs. C)First run mysqld --initialize to refresh the size of ib_logfile. D)Create(　　)new ib_logfile0 file of size 26214400. Answer:A Q64.User account baduser@hostname on your MySQL instance has been compromised. Which two commands stop any new connections using the compromised account? A)ALTER USER baduser@hostname ACCOUNT LOCK;

Q79.Which three actions are effective in capacity planning?

Q88.Which two MySQL Server accounts are locked by default? A)any new ROLE accounts B)any user created without(　　)password C)any internal system accounts D)any user created with(　　)username, but missing the host name E)any user set as DEFINER for stored programs Answer:AC Q89.After installing MySQL 8.0 on Oracle Linux 7, you initialize the data directory with the mysqld --initialize

[.......] “STATUS”:”ONLINE”, “version”;”8.0.18’ } } Which statement explains the state of the instance deployed on host2?

Q96.Which three methods display the complete table definition of an InnoDB table? A)PRPAIR TABLE table USE_FRM B)SHOW CREATE TABLE C)hexdump -v-c table.frm D)Mysqldump --no-data schema table E)SELECT _FROM table 1\G F)Query the Information Schema AnswernBDFn Q97.A scientific data gathering application uses(　　)MySQL instance back end for data management. There is(　　)high concurrency of transactions at thousands of transactions per second of volatile data.A restore from

Q100.Which three are types of information stored in the MySQL data dictionary?

Q102.You must run multiple instances of MySQL Server on a single host.Which three methods are supported?

Q103.Which statement enables all roles granted to all users automatically?

Which statement is true?