MySQL 5.6 Database Administrator - 1z1-883 Exam Practice Test

Question 1

Identify a performance impact when using the Performance Schema.

A. There is no impact on performance.

B. There is a constant overhead regardless of settings and workload.

C. The overhead depends on the settings of the Performance Schema.

D. There is an overhead for querying the Performance Schema but not for having it enabled.

Correct Answer: C

Question 2

Which three statements are characteristic of the MEMORY storage engine?

A. It can support foreign keys.

B. Table contents are not saved if the server is restarted.

C. It can support transactions

D. Each table has a corresponding.MYI and .MYD file.

E. It cannot contain text or BLOB columns.

F. Each table is represented on disk as an.frm file.

Correct Answer: B,E,F

Question 3

Which three statements describe how the strict SQL mode provides added security?

A. It rejects statements that try to insert out-of-range values

B. It rejects invalid dates.

C. It rejects dates with zero day or month values.

D. It limits the operations that the server can perform.

E. It rejects queries that produce out-of-range values.

Correct Answer: A,C,D

Question 4

In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?

A. Comparing the encoded data with similar columns on other tables

B. Memory usage when working with the data

C. Character set mapping index hash size

D. Syntax when writing queries involving JOINS

E. Disk usage when storing data

Correct Answer: A,B,C

Question 5

Consider the three binary log files bin.00010, bin.00011, and bin.00012 from which you want to restore data.
Which method would use mysqlbinlog for greater consistency?

A. shell> mysqlbinlog - include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql

B. shell> mysqlbinlog - restore bin.00010 bin.00011 bin.00012

C. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

D. shell> mysqlbinlog bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql

Correct Answer: D

Question 6

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' position 684
Why did you receive this error?

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

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

C. The table definition on the slave -litters from the master.

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

Correct Answer: B

Question 7

A database exists as a read-intensive server that is operating with query_cachek_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
database level?

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

B. Mutex contention on the Query Cache is forcing the queries to take longer due to its single-threaded nature.

C. The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution.

D. Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups.

Correct Answer: B

Question 8

You are using replication and the binary log files on your master server consume a lot of disk space.
Which two steps should you perform to safely remove some of the older binary log files?

A. Remove all of the binary log files that have a modification date earlier than today.

B. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.

C. Ensure that none of the attached slaves are using any of the binary logs you want to delete.

D. Edit the .index file to remove the files you want to delete.

E. Execute the PURGE BINARY LOGE NOT USED command.

Correct Answer: B,C

Explanation: Only visible for Actualtests4sure members. You can sign-up / login (it's free).

Question 9

Which two statements are true regarding partitioning in Mysql?

A. Tables with BLOB and TEXT columns cannot be partitioned.

B. Partitioning allows easier management of smaller data sets for certain queries.

C. Partitioning is only available for those storage engines that implements it natively.

D. Partitioning allows different columns to be stored in separate files.

E. The partitioning expression is an integer or function that returns an integer value or NULL value.

Correct Answer: D,E

Question 10

What are three methods to reduce Mysql server exposure to remote connections?

A. Setting - mysql_secure_configuration to enable paranoid mode

B. Setting specific GRANT privilege to limit remote authentication

C. Using SSL when transporting data over remote networks

D. Setting -- skip-networking when remote connections are not required

E. Using the sql_mode=STRICT_SECURE after connections are established for encrypted communications

Correct Answer: B,D,E

Oracle MySQL 5.6 Database Administrator - 1z1-883 Exam Practice Test

Latest Update

Useful Links

Contact Us