Oracle MySQL 5.6 Database Administrator - 1z1-883 Exam Practice Test
Consider the Mysql Enterprise Audit plugin.
You are checking user accounts and attempt the following query:
Mysql> SELECT user, host, plugin FROM mysql.users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
Which subset of event attributes would indicate this error in the audit.log file?
You are checking user accounts and attempt the following query:
Mysql> SELECT user, host, plugin FROM mysql.users;
ERROR 1146 (42S02): Table 'mysql.users' doesn't exist
Which subset of event attributes would indicate this error in the audit.log file?
Correct Answer: D
Vote an answer
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?
Which two conditions must be true?
Correct Answer: C,D
Vote an answer
Which three data components are needed for point-in-time recovery?
Correct Answer: B,C,F
Vote an answer
You are using the performance Schema to investigate replication on a slave:
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?
Mysql> SELECT THREAD_ID threads.NAME, SUM (COUNT_STAR) AS Totalcount, SUM (SUM_TIMER_WAIT) AS Totaltime
FROM performance_schema.events_waits_summary_by_thread_by_event_name
INNER JOIN performance_schema_threads USING (THREAD_ID)
WHERE threads .NAME LIKE 'thread/sql/slave\-%'
GROUP BY THREAD_ID, threads.NAME;
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output?
Correct Answer: A,C
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?
Correct Answer: D,E
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
A user executes the statement;
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?
PURGE BINARY LOGS TO 'mysql-bin.010';
What is the result?
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
Consider the following:
Mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?
Mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA' \G ******************************** 1. row ******************************** Id: 1 Select_type: SIMPLE Table: City Type: ref Possible_keys: name_country_index Key: name_country_index Ref: const, const Rows: 1 Extra: Using where
Which statement best describes the meaning of the value for the key_len column?
Correct Answer: A
Vote an answer
MySQL is installed on a Linux server and has the following configuration:
[mysqld]
User=mysql
Datadir=/data/mysql
As the 'root' user, change the datadir location by executing:
Shell> cp -R /var/lib/mysql/data/mysql/
Shell> chown -R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the 'mysql' user?
[mysqld]
User=mysql
Datadir=/data/mysql
As the 'root' user, change the datadir location by executing:
Shell> cp -R /var/lib/mysql/data/mysql/
Shell> chown -R mysql /data/mysql/
What is the purpose of changing ownership of datadir to the 'mysql' user?
Correct Answer: D
Vote an answer
In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?
Which three should influence your choice of character set?
Correct Answer: B,C,D
Vote an answer
A Mysql Server has been running an existing application successfully for six months.
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?
The my.cnf is adjusted to contain the following additional configuration:
[mysqld]
Default-authentication-plugin=sha256_password
The Mysql Server is restarted without error.
What effect will the new configuration have in existing accounts?
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).