第1页 / 共61页
第2页 / 共61页
第3页 / 共61页
第4页 / 共61页
第5页 / 共61页
第6页 / 共61页
第7页 / 共61页
第8页 / 共61页
mysql ocp题库完整版.pdf
The safer , easier way to help you pass any IT exams.
Exam : 1Z0-883
Title :
MySQL 5.6 Database
Administrator
Version : V9.02
1 / 61
The safer , easier way to help you pass any IT exams.
1.Consider a total and sustained failure of the disk on which the MySQL data directory resides.
Which three High Availability scenarios are resilient to this case?
A. active/passive Distributed Replicated Block Device (DRBD.
B. standard master-slave replication
C. MYSQL service for Windows Cluster
D. MySQL NDB Cluster
E. Oracle Solaris Cluster
Answer:ABD
2.You want to start monitoring statistics on the distribution of storage engines that are being used and the
average sizes of tables in the various databases.
Some details are as follows:
- The MySQL instance has 400 databases.
- Each database on an average consists of 25-50 tables.
You use the query:
Why is this query slow to execute?
A. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.
B. Collecting information requires various disk-level operations and is time consuming.
C. Aggregating details from various storage engine caches for the final output is time consuming.
D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables,
thereby causing contention.
Answer:B
3.A database exists as a read-intensive server that is operating with query_cache_type = DEMAND.
The dataset 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 database
level?
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.
2 / 61
The safer , easier way to help you pass any IT exams.
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 SQL
statement execution.
Answer:C
4.The following commands are available In the Linux binary distributions of MySQL:
- znysqld
- inysqld_safe
- mysql.server
What is the correct description of each of these commands?
A. mysqid is the server.
mysqld_safe is a shell script that Invokes mysqld.
mysql.server is a wrapper for mysqld_safe.
B. mysqid is a shell script that starts mysql.server.
mysqld_safe causes the server to start up in data recovery mode.
mysql.server is the server.
C. mysgld is the server.
mysqld_safe causes the server to start up In data recovery mode.
tnysql.server is a wrapper for mysqld_safe.
D. mysqid, mysqid_safe, and mysql.server reside in different locations but are all symlinked to the same
script.
Answer:A
5.Consider the MySQL Enterprise Audit plugin.
The following event detail is found in the audit log:
Which two points can be concluded from the given event?
A. A connection was blocked by a firewall or a similar security mechanism.
B. A connection was attempted via socket rather than TCP.
C. A connection failed because the proxy user privileges did not match the login user.
D. A connection as the user kite was successful.
E. A connection failed due to authentication being unsuccessful.
Answer:BE
6.Which two statements are true about a table cache in MySQL?
3 / 61
The safer , easier way to help you pass any IT exams.
A. A global table cache is used for all open tables.
B. A separate table cache is used for data in each open table.
C. A table cache is used to cache frequently used table Indexes.
D. A table cache is used to cache the status of individual tables
E. A table cache is used to cache open table file descriptors.
Answer:DE
7.You are investigating the performance of a query, which selects data from an InnoDB table.
Consider the following Performance Schema diagnostics output for the query:
Which statement is true about the output?
A. The query did not find its table in the table definition cache.
B. The event with event_id = 8945 is a child of the event with event_id = 8944.
C. The query read data from the data file rather than directly from the buffer pool.
D. The time the query took is the sum of all timer_wait values.
Answer:A
8.A MySQL instance is running on a dedicated server. Developers access the server from the same
network subnet. Users access the database through an application that is running on a separate server in
a DMZ.
Which two will optimize the security of this setup?
A. disabling connections from named pipes or socket files (depending on the operating system of the
server)
B. running the server with --skip--networking specified
C. limiting logins to originate from the application server or the server’s subnet
D. starting the server with --bind-address=0.0.0.0 specified
4 / 61
The safer , easier way to help you pass any IT exams.
E. Installing MySQL on the application server, and running the database and application on the same
server
F. enabling and using SSL for connections to the MySQL database
Answer:BF
9.Given the result of the following query:
A client connection is established with the username mike from the host db.example.com. However, when
trying to execute queries, it is found that the privileges are insufficient.
You investigate further by executing the command:
mysql> SELECT CURRENT_USER();
What is the name returned from the executed command?
A. ‘mike’ 0 ‘localhost’
B. ‘mike’ 0 ‘&’
C. ‘mike’ 0 ‘db.example.com’
D. ‘ ’ 0 ’db.example.com’
Answer:C
10.How does the InnoDB storage engine handle deadlocks when they are detected?
A. The affected transactions wait for inodb_lock_wait_timeout seconds, and then roll back.
B. The transaction isolation level determines which transaction is rolled back.
C. One of the affected transactions will be rolled back, the other is allowed to proceed.
D. Both the affected transactions will be rolled back.
E. The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.
Answer:A
11.In a test database, you issue the SELECT ... INTO OUTFLLE statement to create a file with your t1
table data.
You then TRUNCATE this table to empty it.
mysql> SELECT * INTO OUTFILE ‘/tmp/t1.sql’ from t1;
mysql> TRUNCATE t1;
Which two methods will restore data to the t1 table?
A. mysql> LOAD DATA INFILE ‘/tmp/t1.sql’ INTO TABLE t1;
B. $ mysqladmin -u root -p -h locathost test --restore /tmp/t1.sql
C. $ mysql -u root -p -h localhost test < /tmp/t1.sql
5 / 61
The safer , easier way to help you pass any IT exams.
D. $ mysqlimport -u root -p -h localhost test /tmp/t1.sgl
E. mysql> INSERT INTO t1 VALUES FRON ‘tmp/t1.sql’;
Answer:AD
12.You need to replicate a table from a master to a slave. The master and slave copies of the table will
have different numbers of columns.
Which two conditions must be true?
A. Each extra column in the copy with more columns must not have a default value.
B. Columns that are common to both versions of the table must be defined in the same order on the
master and the slave.
C. The slave database cannot have more columns than the master. Only the master database can have
more columns.
D. Columns that are common to both versions of the table must come first in the table definition, before
any additional columns are defined on either server.
E. The master database cannot have more columns than the slave. Only the slave database can have
more columns.
Answer:BD
13.You want to upgrade the MySQL Server.
In which two cases would you not use a binary backup?
A. when you upgrade skipping a major version, for example, from 5.0 to 5.6
B. when you upgrade between major versions, for example from 5.5 to 5.6
C. when the Release Notes indicate either a data or index format between versions was changed
D. when the Release Notes indicate that functionality between versions was changed
E. when the Release Notes Indicate that syntax between versions was changed
Answer:AC
14.The MySQL user ‘adam’ currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users The ‘adam’ user
needs to be able to take consistent backups of the football database by using the -- single-transaction
option.
Which extra GRANT permissions are required for adam to take mysqldump backups?
A. The ‘adam’ user must also have SINGLE TRANSACTION global grant to take a consistent backup.
B. The ‘adam’ user must have the SUPER privilege in order to take data backups.
C. The ‘adam’ user must also have SELECT on the football database for backups to work.
D. The ‘adam’ user needs the PROCESS privilege to be able to take a consistent backup while other
users are connected.
Answer:B
15.Which statement true about the FLUSH LOGS command?
A. It requires the RELOAD, FILE, and DROP privileges.
B. It closes and reopens all log files.
C. It closes and sends binary log files to slave servers.
D. It flushes dirty pages in the buffer pool to the logs.
6 / 61
The safer , easier way to help you pass any IT exams.
Answer:B
16.You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server In order to include the
master server’s binary log information?
A. include-master-info
B. master-binlog
C. include-log-file
D. master-data
Answer:D
17.Which MySQL utility program should you use to process and sort the Slow Query Log based on query
time or average query time?
A. mysqlslow
B. mysqldurnpgslow
C. mysqlshow
D. mysqldump
E. mysqlaccess
Answer:B
18.You want to create a temporary table named OLD INVENTORY in the OLD_INVENTORY database on
the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave?
A. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to
OLD_INVENTORY.
B. change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY
table.
C. Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
D. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
E. Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY
and restart rnysqld before creating the temporary table.
Answer:BE
19.Which three statements are true about configuring the Performance Schema in MySQL 5.6?
A. All settings can be configured in the MySQL configuration file.
B. All settings are exposed through the setup tables in the performane schema database.
C. Instrumentation of background threads can be disabled only after a thread has started.
D. Accounts and tables can be instrumented dynamically.
E. Changes made dynamically to the setup tables are persistent over restarts.
F. The Performance Schema is enabled by default
Answer:ABD
20.Consider the following:
7 / 61
The safer , easier way to help you pass any IT exams.
What does the possible keys column in this output denote?
A. whether there are any indexes on the tables that you are querying
B. if there are any indexes that may be used to solve this query
C. whether you are using any indexes in your query
D. If it is possible for you to include any indexes in your query
Answer:D
21.Is It true that binary backups always take less space than text backups?
A. Yes, because binary backups only contain data, and not statements required to insert data into the
tables.
B. No, because if InnoDB tables contain many empty pages, they could take more space than the
INSERT statements.
C. No, because text backups can have optimizations, which make them smaller such as updating many
rows at once.
D. Yes, because even if InnoDB tables Contain many empty pages, text backups have empty INSERT
statements for them.
Answer:B
22.Which three statements describe the purpose of a read buffer?
A. It is used to cache results of nested queries that use any storage engine.
B. It is used to cache results of nested queries that use only MyISAM tables.
C. It is used to perform sequential table scans only for MyISAM.
D. It is used to perform sequential table scans for any storage engine.
E. It is used for bulk inserts into partitions that use any storage engine.
F. It is used for bulk inserts into partitions that use only the MyISAM storage engine.
Answer:BCF
23.What metadata does the INEORMATION_SCHEMA.COLLATIONS table provide?
A. the names of foreign keys between tables
B. the names of ordering rules for character sets
C. how the optimizer chooses an execution plan
D. a list of constraints on a table
Answer:B
8 / 61
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
