mysqlocp认证考试题库_Mysql8.0OCP1Z0-908CN-total认证备考题库资源-CSDN文库

共2个文件

pdf：2个

mysql

1Z0-883

5星 · 超过95%的资源需积分: 34 48 浏览量 2017-10-09 14:51:52 上传评论 7 收藏 2.09MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

mysql5.6认证题库.zip （2个子文件）

mysql5.6认证题库2.pdf 1.19MB

mysql5.6认证题库1.pdf 1.28MB

资源由 www.eimhe.com 美河学习在线收集提供

声明：答案后有问号或是批准的地方都是目前还不太清楚的知识点，多数题目下面都附带了

参考链接，请仔细阅读理解。

1.考点参考

http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-failover.html#replication-gtids-failove

r-empty

A simple master-to-slave replication is currently being used. The following information is

extracted from the SHOW SLAVE STATUS output:

Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query. Default database: 'mydb'.

Query:

'insert into mytable VALUES ('8' , 'George') '

Skip_Counter: 0 Retrieved _Gtid_Set:

38f32e23480a7-32a1-c323f78067fd37821: 1-8

Auto _Position: 1

You execute a “SHOW CREATE TABLE mytable” on the slave:

CREATE TABLE ‘mytable’ (

‘ID’ int(11) NOT NULL DEFAULT ‘0’,

‘name’ char(10) DEFAULT NULL,

PRIMARY KEY (‘ID’) );

The table mytable on the slave contains the following:

…

You have issued a STOP SLAVE command. One or more statements are required before you can

issue a START SLAVE command to resolve the duplicate key error.

Which statement should be used?

A. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1

B. SET GTID_NEXT=”CONSISTENCY”; BEGIN; COMMIT; SET GTID_NEXT=” AUTOMATIC’;

C. SET GLOBAL enforce_gtid_consistency=ON

D. SET GTID_EXECUTED=”38f32e23480a7-32a1-c323f78067fd37821 : 9”;

E. SET GTID_NEXT=”38f32e23480a7-32a1-c323f78067fd37821 : 9”; BEGIN; COMMIT; SET

GTID_NEXT=”AUTOMATIC”;

Answer:E

2.考点参考

http://dev.mysql.com/doc/refman/5.6/en/routines-table.html

You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are

notified that users are getting the following error:

mysql> CALL film_in_stock (40, 2, @count);

ERROR 1449 (HY000): The user specified as a definer (‘bon’@’localhost’) does not exist

资源由 www.eimhe.com 美河学习在线收集提供

How would you identify all stored procedures that pose the same problem?

A. Execute SELECT * FROM mysql.routines WHERE DEFINER=’bob@localhost’;.

B. Execute SHOW ROUTINES WHERE DEFINER=’bob@localhost’.

C. Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES

WHERE DEFINER=’bob@localhost’;.

D. Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER=’bob’ and

HOST=’ localhost’;.

E. Examine the Mysql error log for other ERROR 1449 messages.

Answer: C

3.考点参考

http://dev.mysql.com/doc/refman/5.6/en/numeric-types.html

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one

of the integer datatypes.

A. BIT columns are written by InnoDB at the head of the row, meaning they are always the first to

be retrieved.

B. Multiple BIT columns pack tightly into a row, using less space.

C. BIT (8) takes less space than eight TINYINT fields.

D. The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The

other integertypes cannot.

Answer: C

4.考点参考

http://dba.stackexchange.com/questions/62941/mysql-master-master-replication-safe-to-delete-

rows-on-both-masters

ROW-based replication has stopped working. You investigate the error log file and find the

following entries:

2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table

test.t1;Can’t find record in ‘t1’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the

event’s master log 56_master-bin. 000003, end_log_pos 851,Error_code: 1032

2013-08-27 14:15:47 9056 [warning] Slave: Can’t find record in ‘t1’,Error_code: 1032

2013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the

problem, and restart the slave SQL thread with “SLAVE START”. We stopped at log ‘56_masterbin.

000003’ position684

Why did you receive this error?

A. The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

B. The table definition on the slave is different from the master.

C. Multi-threaded replication slaves can have temporary errors occurring for cross database

updates.

D. The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not

exist.

资源由 www.eimhe.com 美河学习在线收集提供

Answer: D

5.考点参考

http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

mysqldump was used to create a single schema backup;

Shell> mysqldump –u root –p sakila > sakila2013.sql

Which two commands will restore the sakila database without interfering with other running

database?

A. mysql> USE sakila; LOAD DATA INFILE ‘sakila2013.sql’;

B. Shell> mysql –u root –p sakila < sakila2013.sql

C. Shell> mysql import –u root –p sakila sakila2013.sql

D. Shell> mysql –u root -p –e ‘use sakila; source sakila2013.sql’

E. Shell> mysql –u root –p –silent < sakila2013.sql

Answer: BD

6.考点参考

http://dev.mysql.com/doc/refman/5.6/en/processlist-table.html

Which query would you use to find connections that are in the same state for longer than 180

seconds?

A. SHOW FULL PROCESSLIST WHERE Time > 180;

B. SELECT * FROM INFORMATION_SCHEMA.EVENTS SHERE STARTS < (DATE_SUB (NOW ( ),

INTERVAL 180 SECOND) );

C. SELECT * FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE STATE < (DATE_SUB

(NOW ( ), INTERVAL 180 SECOND) );

D. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE TIME > 180;

Answer: D

7.考点参考

http://dev.mysql.com/doc/refman/5.6/en/query-cache.html

A database exists as a read-intensive server that is operating with query_cache_type =

DEMAND.The database is refreshed periodically, but the resultset size of the queries does not

fluctuate.Note the following details about this environment:

-A web application uses a limited set of queries.

-The Query Cache hit rate is high.

-All resultsets fit into the Query Cache.

-All queries are configured to use the Query Cache successfully.

The response times for queries have recently started to increase. The cause for this has correctly

been identified as the increase in the number of concurrent users accessing the web service.

Based solely on the information provided, what is the most likely cause for this slowdown at the

资源由 www.eimhe.com 美河学习在线收集提供

databaselevel?

A. The Query Cache is pruning queries due to an increased number of requests.

B.Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead

due to additional memory block lookups.

C. Mutex contention on the Query Cache is forcing the queries to take longer due to its

single-threaded nature.

D. The average resultset of a query is increasing due to an increase in the number of users

requiring SQLstatement execution.

Answer: C

8.考点参考

http://dev.mysql.com/doc/refman/5.6/en/innodb-auto-increment-configurable.html

Which two statements are true about InnoDB auto-increment locking?

A. The auto-increment lock can be a table-level lock.

B. InnoDB never uses table-level locks.

C. Some settings for innodb_autoinc_lock_mode can help reduce locking.

D. InnoDB always protects auto-increment updates with a table-level lock.

E. InnoDB does not use locks to enforce auto-increment uniqueness.

Answer: AC

9.考点参考

http://dev.mysql.com/doc/refman/5.6/en/audit-log-plugin-restrictions.html

Consider the MySQL Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The

stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in

the mydb database:

mysql> CALL prepare_db ( );

mysql> LOAD DATA INFILE ‘/tmp/data.csv’ INTO TABLE mytable;

mysql> SHOW TABLES;

How many events are added to the audit log as a result of the preceding statements?

A. 102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event.

B. 3; only the top-level statements are logged.

C. 111; top-level statements and all lower-level statements are logged.

D. 12; only top-level statements and stored procedure events are logged.

Answer: B

10.考点参考

http://dev.mysql.com/doc/refman/5.6/en/mysql.html

What are four capabilities of the mysql client program?

A. Creating and dropping databases

资源由 www.eimhe.com 美河学习在线收集提供

B. Creating, dropping, and modifying tables and indexes

C. Shutting down the server by using the SHUT DOWN command

D. Creating and administering users

E. Displaying replication status information

F. Initiating a binary backup of the database by using the START BACKUP command

Answer: ABDE

11.考点参考

Consider the query:

mysql> SET @run = 15;

mysql> EXPLAIN SELECT objective, stage, COUNT (stage)FROM iteminformationWHERE run=@run

AND objective=’7.1’GROUP BY objective,stageORDER BY stage;

The iteminformation table has the following indexes:

mysql> SHOW INDEXES FROM iteminformation;

…(这里少输出内容)

This query is run several times in an application with different values in the WHERE clause in a

growing data set.

What is the primary improvement that can be made for this scenario?

A. Execute the run_2 index because it has caused a conflict in the choice of key for this query.

B. Drop the run_2 index because it has caused a conflict in the choice of key for this query.

C. Do not pass a user variable in the WHERE clause because it limits the ability of the optimizer to

useindexes.

D. Add an index on the objective column so that is can be used in both the WHERE and GROUP BY

operations.

E. Add a composite index on (run,objective,stage) to allow the query to fully utilize an index.

Answer: E

13.考点参考

http://dev.mysql.com/doc/refman/5.6/en/audit-log-file.html

Consider the MySQL Enterprise Audit plugin.

Which statement is true when you identify a connection event that has used external

authentication?

A. The attribute “STATUS” is set to the string EXTERNAL_AUTH.

B. The attribute “PRIV_USER” contains the username.

C. The event type that is given in the attribute “NAME” is EXTERNAL_AUTH.

D. There is no differentiation between native and external authentication events.

E. External authentication is managed through external auditing logs.

F. The “PROXY_USER” user shows a username if ext1ernal authentication is used.

Answer: F

评论收藏

内容反馈

rwangnqian

2018-01-28

多谢楼主分享！
randy_ma

2017-11-22

挺好的材料，先学习着
qq_39486435

2018-06-15

henhao很棒
nobo2018

2018-08-21

虽然都是老题目，还是感谢！
hxinshenc

2018-08-09

挺好的题库,只是不知道是哪一年的

Moon_魔宽

粉丝: 28
资源: 13

mysql ocp认证考试题库

最新资源

mysql ocp认证考试题库

MySQL8.0认证 ocp(175题)

最新mysql ocp 认证 1Z0-883 题库

mysql ocp题库总结

MySQL OCP5.7考试题目大全.docx

mysql ocp题库完整版.pdf

MYSQL OCP题库（2018.4.2更新）

数据库期末考试试题及答案

MySQL数据库考试试题及答案

mysql5.7-ocp-888-题库与解析

OCP认证考试题

ocp考试题库

ocp认证 考试新题库

ocp考试证书题库

ocp认证考试

mysql ocp真题

MySQL 5.7-OCP-题库最终版

MySQL ocp 1z0-883最准确题库

OCP考试资料

MySQL 5.6 OCP考试模拟题 解析

数据库期末考试试卷（含答案）

OCP考试流程

mysql ocp 实战整理题库，高命中率.docx

mysql面试题

强烈推荐MySQL面试题和答案（仅供参考）

ocp考试题库.zip

mysql 8.0 ocp 题库

ocp认证052最新题库

ocp考试047题库

MySQL OCP 5.6 5.7题库标准答案

最新资源

ocp认证考试新题库

MySQL 5.6 OCP考试模拟题解析