1Z0-888 Dumps with Free 365 Days Update Fast Exam Updates
Verified 1Z0-888 dumps Q&As - 2022 Latest 1Z0-888 Download
NEW QUESTION 11
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? (Choose two.)
- A. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
- B. Execute the PURGE BINARY LOGS NOT USED command.
- C. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.
- D. Remove all of the binary log files that have a modification date earlier than today.
- E. Edit the .index file to remove the files you want to delete.
Answer: A,C
Explanation:
A: To safely purge binary log files, follow this procedure:
1. On each slave server, use SHOW SLAVE STATUS to check which log file it is reading.
2. Obtain a listing of the binary log files on the master server with SHOW BINARY LOGS.
3. Determine the earliest log file among all the slaves. This is the target file. If all the slaves are up to date, this is the last log file on the list.
4. Make a backup of all the log files you are about to delete. (This step is optional, but always advisable.)
5. Purge all log files up to but not including the target file.
Syntax:
PURGE { BINARY | MASTER } LOGS
{ TO `log_name' | BEFORE datetime_expr }
NEW QUESTION 12
Which two are considered good security practices when using passwords? (Choose two.)
- A. Store passwords external to the database.
- B. Use simple keyboard actions that give mixed letters.
- C. Use one-way encryption for storage of passwords.
- D. Choose short passwords to save on storage space.
- E. Do not use dictionary-based words.
Answer: C,E
Explanation:
Reference: https://stackoverflow.com/questions/14798275/best-way-to-store-passwords-in- mysql-database
NEW QUESTION 13
This output is from a SHOW SLAVE STATUS:
What would cause the SQL_Delay variable to have a value of 360?
- A. The master has performed a large transaction, which will take 360 seconds to complete on the slave.
- B. The slave was configured for delayed replication with a delay of six minutes.
- C. The slave will need an estimated 360 seconds to update the remaining contents from the relay log.
- D. The network latency between the master and the slave is 360 milliseconds.
Answer: B
NEW QUESTION 14
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. log-bin
- D. apply-log
- E. binlog_format=STATEMENT
Answer: C
Explanation:
Reference: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time- recovery.html
NEW QUESTION 15
You have a scheduled task on Linux that executes mysqldumpagainst the localhost server periodically.
When checking the logs of this event to ensure that things are working and that backups will restore, you notice an output that is concerning.
The command the scheduled task is executing as follows:
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --protocol=TCP
> /backups/latest.sql
Warning: Using a password on the command-line interface can be insecure.
Which two methods are available to avoid the warning? (Choose two.)
- A. Connect through the --socket rather than the default --protocol=TCP for local connection.
$ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living --socket=/tmp/mysql.sock > /backups/ latest.sql - B. Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.
- C. Store your password in an option file eg: ~/.my.cnf and use --defaults-file so that it is read and used.
[client]
password=t100043va - D. Use the password validation plugin available to improve user name and password strength.
Answer: B,D
Explanation:
https://dev.mysql.com/doc/mysql-security-excerpt/8.0/en/password-security-user.html
https://dev.mysql.com/doc/refman/5.6/en/validate-password.html
NEW QUESTION 16
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)
- A. mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
- B. It provides means to help avoid accidentally exposing the MySQL login details.
- C. A .mylogin.cnf file can store at most one login path.
- D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- E. It provides a FIPS-compliant keyring for storing MySQL login details.
- F. It is an alternative to storing the MySQL login details in a my.cnf file.
Answer: B,F
NEW QUESTION 17
You need to dump the data from the master server and import it into a new slave server.
Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?
- A. include-log-file
- B. master-data
- C. include-master-info
- D. master-binlog
Answer: B
NEW QUESTION 18
Consider the index information for the dept_emptable 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 emp_nocolumn.
- C. The values on the emp_nocolumn must be unique.
- D. The selectivity of the dept_nocolumn is the best of the indexed columns.
- E. The secondary indexes are optimized for unique key look-ups.
- F. There is a redundant index on the dept_nocolumn.
Answer: B,E
NEW QUESTION 19
A particular government's security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?
- A. using GRANT ... REQUIRE X509 AND REQUIRE ISSUER '/C=.....' AND REQUIRE SUBJECT
'/C=.....' - B. using GRANT USAGE, X509, .......ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
- C. using GRANT USAGE, SSL, .....ON *.* TO user@remotehost IDENTIFIED BY 'secret_password'
- D. using GRANT ... REQUIRE SSL for a secure connection
Answer: A
NEW QUESTION 20
A crucial database, 'db_prod', just disappeared from your production MySQL instance.
In reviewing the available MySQL logs (General, Audit, or Slow) and your own application-level logs, you identified this command from a customer facing application:
SELECT id FROM users WHERE login='payback!';DROP DATABASE db_prod;'
Which three methods could have been used to prevent this SQL injection attack from happening? (Choose three.)
- A. changing all passwords for the MySQL account 'root'@'%'immediately after losing an employee who knew the current password
- B. removing any remaining anonymous accounts from your MySQL instance
- C. using a hashing or encryption method to secure all user passwords in your MySQL tables
- D. giving limited privileges to accounts used by application servers to interact with their backing databases
- E. using SSL/TLS on your outward facing web servers (https://) to encrypt all user sessions
- F. writing your client code to properly escape all user input
- G. validating all user input before sending it to the database server
Answer: A,B,C
NEW QUESTION 21
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?
(Choose two.)
- A. SET GLOBAL mysql_cleartext_passwords=1;
- B. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
- C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
- D. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
- E. INSTALL PLUGIN mysql_cleartext_password SONAME 'mysql_cleartext_password.so';
Answer: A,D
NEW QUESTION 22
The MySQL installation includes the mysql_config_editorutility for managing login paths stored in a
.mylogin.cnffile.
Which two are true about the login path feature? (Choose two.)
- A. A .mylogin.cnffile can store at most one login path.
- B. It provides means to help avoid accidentally exposing the MySQL login details.
- C. mysql_config_editoris the only MySQL-provided utility that can print the values stored in
.mylogin.cnf. - D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- E. It is an alternative to storing the MySQL login details in a my.cnffile.
- F. It provides a FIPS-compliant keyring for storing MySQL login details.
Answer: B,E
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
NEW QUESTION 23
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. log-bin
- D. apply-log
- E. binlog_format=STATEMENT
Answer: C
NEW QUESTION 24
You are using the Performance Schema to investigate replication on a slave which has a single master.
The option slave-parallel-typeis set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)
- A. THREAD_ID 21has stopped running.
- B. At most, two schemas are being updates concurrently.
- C. The slave cannot process the relay log fast enough to use all threads.
- D. The salve has two intermediate relay slaves connected to it.
- E. The server needs more cores to use all slave threads.
- F. The slave is configured with slave_parallel_workers= 4
Answer: C,F
NEW QUESTION 25
Consider the join_buffer_sizeparameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
- A. The join buffer is global and can be changed only by restarting the server.
- B. The value should be increased if the client performs several SELECToperations.
- C. The join buffer is used to process sorts when complex joins are being performed.
- D. The join buffer is set per connection.
- E. The value should be increased from the default if the query joins large rows without using an index.
Answer: C,E
Explanation:
Explanation/Reference:
NEW QUESTION 26
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 is a global buffer.
- C. It is set on a per-connection basis.
- D. It caches index blocks for InnoDB tables only.
- E. It caches index blocks for MyISAM tables only.
Answer: C,E
NEW QUESTION 27
Which three options are most likely to be changed for production form their default values?
- A. join_buffer_size
- B. character_set_system
- C. innodb_buffer_pool_size
- D. max_connections
- E. max_user_connections
- F. port
- G. innodb_log_file_size
Answer: E,F,G
NEW QUESTION 28
......
MySQL 5.7 Database Administrator
Preparation Guide for Oracle 1z0-888 Certification Exam
Introduction
The MySQL 5.7 Database Administrator Certification Exam certifies the candidate has an understanding of MySQL Database technology. This certificate is also known as Oracle 1z0-888 Exam which is a benchmark for experience and expertise recognized by employers across the globe.
Updated Oracle Study Guide 1Z0-888 Dumps Questions: https://www.testpassking.com/1Z0-888-exam-testking-pass.html