1Z0-883 | The Up to the minute Guide To 1Z0-883 dumps
Q51. You have a login-path named “adamlocal” that was created by using the
mysql_config_editor command.
You need to check what is defined for this login_path to ensure that it is correct for you deployment.
You execute this command: $ mysql_config_editor print –login-path=adamlocal What is the expected output of this command?
A. The command prints all parameters for the login-path. The password is printed in plain text.
B. The command prints all parameters for the login-path. The password is shown only when you provide the –password option.
C. The command prints all parameter for the login-path. The password is replaced with stars.
D. The command prints the encrypted entry for the login-path. The is only possible to see if an entry exists.
Answer: C
Q52. Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?
A. MySQL Replication
B. Distributed Replication Block Device
C. Windows Server Failover Clustering
D. MySQL Cluster
Answer: A
Q53. 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?
A. At most two schemas are being updated concurrently.
B. The server needs more cores to use all slave threads.
C. The slave cannot process the relay log fast enough to use all threads.
D. The slave is configured with slave_parallel_workers = 4.
Answer: C
Q54. A MySQL replication slave is set up as follows:
User all InnoDB tables Receives ROW-based binary logs Has the read-only option
The replication slave has been found in an error state.
You check the MySQL error log file and find the following entries:
2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653,
Error_code: 1062
2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’
Error_code: 1062 2013-08-27 13:55:44 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_master-bin.000003’ position 496
What are two possible causes for this error to occur?
A. The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B. The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function.
C. For tables with UNIQUE keys, statement-based replication must be used maintain integrity.
D. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
E. The applications have the SUPER privilege, which allows them to update rows.
Answer: A,E
Q55. You have a server that has very limited memory but has a very large table.
You will use mysqldump to back up this table.
Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?
A. -- quick
B. -- skip-buffer
C. -- single-transaction
D. -- tab
Answer: C
Reference: http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html
Q56. 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 bin.00010 | mysql shell> mysqlbinlog bin.00011 | mysql shell> mysqlbinlog bin.00012 | mysql
B. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql
C. shell> mysqlbinlog – restore bin.00010 bin.00011 bin.00012
D. shell> mysqlbinlog – include-gtide=ALL bin.00010 bin.00011 bin.00012 | mysql
Answer: A
Q57. Consider the following statement on a RANGE partitioned table:
ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?
A. Only the first partition (p1) will be dropped as only one can be dropped at any time.
B. All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
C. A syntax error will result as you cannot specify more than one partition in the same statement.
D. All data in pi and p3 partitions are removed and the table definition is changed.
Answer: B
Reference: http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67772/partiti.htm
Q58. You are having problems with connections from a specific host (192.168.1.15) not closing down correctly. You want to find the state of the threads from that host check for long-running queries.
Which statement will accomplish this?
A. SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST WHERE HOST=’192.168.1.15’;
B. SELECT * FROM INFORMATION_SCHEMA.EVENTS WHERE HOST=’ 192.168.1.15’;
C. SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE HOST=’ 192.168.1.15’;
D. SELECT * FROM INFORMATION_SCHEMA.INNODB_METEICS WHERE HOST=’ 192.168.1.15’;
Answer: C
Q59. What are three actions performed by the mysql_secure_installation tool?
A. It prompts you to set the root user account password.
B. It checks whether file permissions are appropriate within datadir.
C. It asks to remove the test database, which is generated at installation time.
D. It can delete any anonymous accounts.
E. It verifies that all users are configuration with the longer password hash.
Answer: A,C,D
Reference: http://prefetch.net/blog/index.php/2006/06/18/securing-mysql-installations-with-mysql_secure_installation/
Q60. 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 allows different columns to be stored in separate files.
D. The partitioning expression is an integer or function that returns an integer value or NULL value.
E. Partitioning is only available for those storage engines that implements it natively.
Answer: C,D