1Z0-888 Practice Exam Tests Latest Updated on Aug-2021 [Q12-Q32]

1Z0-888 Practice Exam Tests Latest Updated on Aug-2021

Pass 1Z0-888 Exam in First Attempt Guaranteed Dumps!

NEW QUESTION 12
Consider the key buffer in a MySQL server. Which two statements are true about this feature?

• A. It caches index blocks for all storage engine tables.
• B. It caches index blocks for InnoDB tables only.
• C. It is a global buffer.
• D. It is set on a per-connection basis.
• E. It caches index blocks for MyISAM tables only.

Answer: D,E

Explanation:
Explanation/Reference:
Reference: https://stackoverflow.com/questions/3663515/mysql-what-is-the-key-buffer

 

NEW QUESTION 13
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?

• A. The /etc/hosts file does not have a valid IP entry for mysqld localhost, so it is binding to 127.0.0.1, which is already in use.
• B. The mysqld service has already been started on the same port.
• C. You failed to specify the port number 3306 to the command to start the server, so it is defaulting to port
  80, which is in use by the built-in web server.
• D. The network service process in the server is frozen, so all TCP/IP connections are paused and cannot be reused.
• E. The mysql.sock file in the MySQL /tmp directory was not removed after the reboot, so mysqld still thinks there is an active server running.

Answer: E

 

NEW QUESTION 14
A MySQL replication slave is set up as follows:
Uses 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 these entries:

What are two possible causes for this error to occur? (Choose two.)

• A. The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite.
• B. For tables with UNIQUE keys, statement-based replication must be used to maintain integrity.
• C. The slave user does not have INSERT, UPDATE, or DELETEpermission and cannot execute the Write_rowsfunction.
• D. The applications have the SUPERprivilege, which allows them to update rows.
• E. The slave was created with mysqldump -u root -p --skip-lock-tables -all-databases
  > /data/data.sql

Answer: B,E

 

NEW QUESTION 15
You back up by using mysqldump.
Which configuration is required on the MySQL Server to allow point-in-time recovery?

• A. gtid_enable
• B. bonlog_format=ROW
• C. apply-log
• D. binlog_format=STATEMENT
• E. log-bin

Answer: E

Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time-recovery.html

 

NEW QUESTION 16
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? (Choose two.)

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

Answer: A,D

 

NEW QUESTION 17
A MySQL instance has this configuration values set:

A transaction involving a single InnoDB INSERT statement commits.
Which list of locations is in the sequence of disk writes for this transaction?

• A. doublewrite buffer, redo log, tablespace, and binary log
• B. redo log, binary log, doublewrite buffer, and tablespace
• C. redo log, doublewrite buffer, tablespace, and binary log
• D. binary log, redo log, doublewrite buffer, and tablespace

Answer: D

 

NEW QUESTION 18
The 'applicationdb' is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather this information:
* The table data_current has 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archive has 4,500,000 rows.

Three tables are stored in the InnoDB shared tablespace and the details are as follows:

You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.

Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?

• A. Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
• B. Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system:
• C. Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
• D. Take a backup, stop the server, remove the data files, and restore the backup:

Answer: C

 

NEW QUESTION 19
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)

• A. Use the LIMIT clause in conjunction with the ORDER BY clause.
• B. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
• C. Change the replication mode to MIXED before issuing any delete statements when the LIMIT clause is used.
• D. Use the LIMIT clause to limit the deletion to 100,000 rows.

Answer: A,C

 

NEW QUESTION 20
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 total size of the index row.
• C. It shows how many columns in the index are examined.
• D. It shows the number of characters indexed in the key.

Answer: A

 

NEW QUESTION 21
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; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-
  bin.00004',
  RELAY_LOG_POS = 1383;
• B. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;
• C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE
  'hostname-relay-bin.00004', RELAY_LOG_POS = 1383;
• D. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

Answer: B

 

NEW QUESTION 22
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. --lock-all-tables
• B. --single-transaction
• C. --master-data
• D. --skip-opt
• E. --create-apply-log

Answer: A,D

 

NEW QUESTION 23
Consider the two partial outputs of the SHOW GLOBAL VARIABLES command from a master and slave server:
Master:

Slave:

There is a problem with the slave replicating from the master. Which statement describes the cause of the problem?

• A. The max_connections variable on the slave needs to be increased.
• B. The version of the slave is newer that the version of the master.
• C. The log_bin variable is set to OFF on the slave.
• D. server_id is not unique.
• E. The shared_memory_base_name variable must match the master.

Answer: C

 

NEW QUESTION 24
You have the following in your my.cnf configuration file:
[mysqld]
default_authentication_plugin=sha256_password
You want to create a new user who will be connecting from the IP address 192.0.2.10, and you want to use the authentication plug-in that implements SHA-256 hashing for user account passwords.
Which two statements would create a user named webdesign for this IP address with the password of imbatman using a SHA_256 password hash? (Choose two.)

• A. CREATE USER WITH sha256_password 'sha256_user'@'192.0.2.10' IDENTIFIED AS 'webdesign' USING 'imbatman';
• B. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY SHA265 AS 'imbatman';
• C. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED AS sha256_user WITH sha256_password
  'imbatman';
• D. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED WITH sha256_password BY 'imbatman';
• E. CREATE USER 'webdesign'@'192.0.2.10' WITH mysql_native_password USING SHA265 BY
  'imbatman';
• F. CREATE USER 'webdesign'@'192.0.2.10' IDENTIFIED BY 'iambatman';

Answer: B,F

 

NEW QUESTION 25
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? (Choose two.)

• A. There is a redundant index on the dept_no column.
• B. The values on the emp_no column must be unique.
• C. There are three indexes on the table.
• D. The secondary indexes are optimized for unique key look-ups.
• 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 column.

Answer: D,F

 

NEW QUESTION 26
Due to an authentication plug-in that is used on the server, passwords are required to be sent as clear text as opposed to the usual encrypted format.
Which two methods would allow the mysql client to connect to the server and send clear text passwords?

• A. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
• B. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
• C. SET GLOBAL mysql_cleartext_passwords=1;
• D. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
• E. INSTALL PLUGIN mysql_cleartext_password SONAME 'mysql_cleartext_password.so';

Answer: B,C

 

NEW QUESTION 27
You have forgotten the root user account password. You decide to reset the password and execute:

Which additional argument makes this operation safer?

• A. --skip-networking, to prohibit access from remote locations
• B. --read-only, to set all data to read-only except for super users
• C. --reset-grant-tables, to start the server with only the mysql database accessible.
• D. --old-passwords, to start MySQL to use the old password format while running without the grant tables.

Answer: A

 

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

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

Answer: B

Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-optimization.html

 

NEW QUESTION 29
old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;

Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?

• A. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
• B. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
• C. All data in p1 and p3 partitions is removed and the table definition is changed.
• D. It results in a syntax error because you cannot specify more than one partition in the same statement.

Answer: A

 

NEW QUESTION 30
You want to create a temporary table named OLD_INVENTORYin the OLD_INVENTORYdatabase 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? (Choose two.)

• A. Stop SQL_THREADon the slave until you have finished using the OLD_INVENTORYtemporary table.
• B. Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
• C. Change the binlog_formatoption to ROW and restart mysqld before you create the OLD_INVENTORYtable.
• D. Use the --replicate-ignore-tableoption with the value equal to
  OLD_INVENTORY.OLD_INVENTORYand restart mysqldbefore creating the temporary table.
• E. Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

Answer: D,E

 

NEW QUESTION 31
You have just executed a manual backup by using this command:
mysqlbackup -u root -p --socket=/tmp/my.sock --backup-dir=/my/backup/ backup The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?

• A. Backup State = Compressed BackupOperation = copy-back
• B. Backup State = Raw BackupOperation = backupdir-to-image
• C. Backup State = Prepared BackupOperation = apply-log
• D. Backup State = Prepared BackupOperation = validate
• E. Backup State = Raw BackupOperation = apply-log

Answer: B

 

NEW QUESTION 32
......

MySQL Database Administration  Free Certification Exam Material from ExamTorrent with 125 Questions: https://www.examtorrent.com/1Z0-888-valid-vce-dumps.html

1Z0-888 Dumps Full Questions - Exam Study Guide: https://drive.google.com/open?id=1bIuZ4J15DjNh-Wyc4vGUVyNEG-nH5m1O