Verified 1z0-888 Dump 2021

NEW QUESTION 1
What two statements are true regarding FLUSH TABLES FOR EXPORT?

• A. It can be used to export TEMPORARY tables.
• B. Table only exports when the table has its own tablespace.
• C. The InnoDB Storage engine must be used for the table being exported.
• D. It is the safest way to extract tables from the shared tablespace.
• E. Partitioned tables are not supporte

Answer: AB

NEW QUESTION 2
Consider:

Which statement best describes the meaning of the value for the key_len column?

• A. It shows how many bytes will be used from each index row.
• B. It shows the number of characters indexed in the key.
• C. It shows the total size of the index row.
• D. It shows how many columns in the index are examine

Answer: A

NEW QUESTION 3
You enable binary logging on MySQL Server with the configuration: binlog-format=STATEMENT log-bin
Which database updates are logged on the master server to the binary log by default?

• A. all updates except to the TEMPDB database
• B. all updates except to the PERFORMANCE_SCHEMA database
• C. all updates not involving temporary tables
• D. all updates to the default database, except temporary tables
• E. all updates to all databases

Answer: D

NEW QUESTION 4
Which two statements are true regarding the creating of new MySQL physical and logical backups?

• A. Physical backups can be used to recover from data corruption.
• B. Logical backups are human-readable whereas physical backups are not.
• C. Logical backups are always larger than physical backups.
• D. Physical backups are usually slower than text backups.
• E. Physical backups are usually faster than text backup

Answer: AE

NEW QUESTION 5
When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file?

• A. it contains the binary log.
• B. it contains a general tablespace.
• C. it is the default location for all new tables that you create.
• D. it contains the system tablespace.
• E. it contains the redo log.
• F. it contains the undo lo

Answer: CD

NEW QUESTION 6
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave
must be “rolled forward” to provide all the latest datA. The SHOW SLAVE STATUS indicates these values: RELAY_LOG_FILE=hostname-relay-bin.00004 RELAY_LOG_POS=1383
Which command set would make the slave current?

• A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;
• B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;
• C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
• D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = ‘hostname-relay-bin.00004’, RELAY_LOG_POS = 1383;

Answer: C

NEW QUESTION 7
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR
package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default -- basedir value) for your operating system.
Which step should you perform before defining your own databases and database tables?

• A. Execute a command with a minimal form of: mysql --initialize
• B. Register mysqld as a service that will start automatically on this host machine.
• C. Create a configuration file containing default-storage-engine=InnoDB.
• D. Set an exception in the host machine’s firewall to allow external users to talk to mysqld.
• E. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.

Answer: C

NEW QUESTION 8
The following grants were executed:
GRANT CREATE ROUTING ON sales.* TO ‘webadmin’@’%’; GRANT ALTER ON PROCEDURE sales.myproc TO ‘webadmin’@’%’;
A user successfully connects to the database as webadmin and created a stored procedure named get_reports. The next day, the user logs in again as webadmin and wants to delete the stored procedure named get_reports, and therefore, issues the following statement:
USE sales;
DROP PROCEDURE IF EXISTS get_reports; What is the result of executing the statement?

• A. The user will get an error because he or she did not use the ALTER statement to drop the stored procedure.
• B. The user will get an error because he or she did not put the database name in front of the stored procedure name.
• C. The stored procedure named get_reports will be dropped.
• D. The user will get an error because he or she does not have the permission to drop stored procedure

Answer: C

NEW QUESTION 9
Examine the mysqldumpslow output:

Which two options could explain the slow query?

• A. There is network congestion between client and server.
• B. No index has been defined on the filtered column.
• C. There are 108 queries still being executed.
• D. A table lock is causing delays.
• E. A full table scan is being use

Answer: AE

NEW QUESTION 10
Consider the index information for the dept_emp table in the employee’s schema:

Which two conclusions can be made based on the output of the query?

• A. There are three indexes on the table.
• B. There is a redundant index on the dept_no column.
• C. The secondary indexes are optimized for unique key look-ups.
• D. The values on the emp_no column must be unique.
• E. The selectivity of the dept_no column is the best of the indexed columns.
• F. There is a redundant index on the emp_no colum

Answer: CF

NEW QUESTION 11
A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?

• A. Ye
• B. Shut down the mysqld process, enable the transportable_tablespace option, and move the UNDO directory to the SSD.
• C. Ye
• D. Shut down, copy the UNDO tablespaces to the new location, and change the innodb_undo_directory value in your my.cnf.
• E. N
• F. The UNDO tablespaces must remain on the same file system as the system tablespaces.
• G. N
• H. The sequential write pattern of the UNDO tablespaces is not supported on modern SSD block device

Answer: C

NEW QUESTION 12
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

• A. Run the create_system_tables.sql file
• B. Run the mysql_unpack.sql file
• C. Invoke mysqld with the --initialize option.
• D. Invoke mysql with the --initialize optio

Answer: C

NEW QUESTION 13
Which two methods accurately monitor the size of your total database size over time?

• A. monitoring the Innodb_rows_inserted status variable
• B. monitoring the innodb_redo_log_size variable
• C. monitoring the information_schemA.TABLES table
• D. monitoring datadir size in the operating system
• E. monitoring cumulative Innodb_page_size increase
• F. monitoring the performance_schema_hosts_size variable

Answer: CF

NEW QUESTION 14
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

• A. It relies on the shared disk architecture being visible to both servers.
• B. It is provided by means of IP-level disk replication.
• C. It implements High Availability by using the NET Connector's load balancing capabilities.
• D. It is a shared-nothing architectur

Answer: A

NEW QUESTION 15
Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

• A. executing REVOKE LOADFROM *.*
• B. setting the --local-service=0 option when starting mysqld
• C. executing REVOKEFILEFROM *_*
• D. executing REVOKEFILE ON *_* FROM ‘ ‘@’%’
• E. setting the --local-infile=0 option when starting mysqld
• F. setting the --open-files-limit=0 option when starting mysqld

Answer: F

NEW QUESTION 16
Which statement best describes the purpose of the InnoDB buffer pool?

• A. It is amount of buffers available during a transaction.
• B. It caches only the indexes for InnoDB tables.
• C. It caches data and indexes for InnoDB tables.
• D. It holds changes made during a transaction before they are written to the log.
• E. It is a pool of memory for SQL query sort operations from within the InnoDB engin

Answer: C

NEW QUESTION 17
A simple master-to-slave replication is currently being used. This information is extracted from the SHOW SLAVE STATUS output:

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

The table mytable on the slave contains:

You have issued a STOP SLAVE command. You have determined that it is safe to skip the transaction in this case. 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 GTID_NEXT=”CONSISTENCY”; BEGIN; COMMIT;SET GTID_NEXT=”AUTOMATIC”;
• B. SET GTID_NEXT=”5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8”; BEGIN; COMMIT; SET GTID_NEXT=”AUTOMATIC”;
• C. SET GLOBAL SQL_SKIP_SLAVE_COUNTER=1
• D. SET GLOBAL enforce_gtid_consistency=ON
• E. SET GTID_EXECUTED=”5da6b4f5-6f60-11e8-b2d6-0010e05f3e06:8”;

Answer: C

NEW QUESTION 18
A MySQL database uses all InnoDB tables and is configured as follows;

You will be setting up a replication slave by using mysqldump. You will need a consistent backup taken from your running production server. The process should have minimal impact to active database connections.
Which two arguments will you pass to mysqldump to achieve this?

• A. --skip-opt
• B. --lock-all-tables
• C. --create-apply-log
• D. --single-transaction
• E. --master-data

Answer: AB

NEW QUESTION 19
You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORDEXPIRE; What is the outcome?

• A. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will have to change the password before seeing the mysql> prompt.
• B. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will not be permitted to log in because the password is expired.
• C. When ‘erika’@’localhost’ tries to log in with the MySQL command-line client, the user will be permitted to log in but will not be able to issue ant statements until the user changes the password.
• D. You receive a syntax error that indicates that you cannot set a password and expire it at the same tim

Answer: A

NEW QUESTION 20
Consider the join_buffer_size parameter in MySQL Server. Which two statements are true about the join buffer?

• A. The value should be increased if the client performs several SELECT operations.
• B. The join buffer is set per connection.
• C. The join buffer is used to process sorts when complex joins are being performed.
• D. The value should be increased from the default if the query joins large rows without using an index.
• E. The join buffer is global and can be changed only by restarting the serve

Answer: CD

NEW QUESTION 21
Which three allocate memory per thread in MySQL?

• A. query cache
• B. thread cache
• C. read buffer
• D. internal temporary table
• E. sort buffer
• F. InnoDB buffer pool instance

Answer: CEF

NEW QUESTION 22
......