1Z1-888 PDF Pass Leader, 1Z1-888 Latest Real Test
Valid 1Z1-888 Test Answers & 1Z1-888 Exam PDF
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.
NEW QUESTION 89
Host slave1 has ip address 192.0.2.10.
Host slave2 has ip address 203.0.113.50
Examine these commands:
Why did this error occur?
- A. The mysqld instance has not been restarted after creating the login path.
- B. There is no password defined in the login path.
- C. The .mylogin.cnf file is not readable.
- D. The DNS is not configured correctly for slave1 host.
- E. The host on the command line is not defined in the login path.
Answer: C
NEW QUESTION 90
What is the order of tables shown in an EXPLAINoutput?
- A. It lists tables in the order in which their data will be read.
- B. It lists tables from the most optimized to the least optimized.
- C. It lists tables from the smallest to the largest.
- D. It lists tables in the order in which they are specified in the statement that is being explained.
Answer: D
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
NEW QUESTION 91
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 mysqlclient to connect to the server and send clear text passwords?
- A. INSTALL PLUGIN mysql_cleartext_password SONAME
'mysql_cleartext_password.so'; - B. SET GLOBAL mysql_cleartext_passwords=1;
- C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN='Y'
- D. mysql --enable-cleartext-plugin -uroot -p -h dbhost.example.com
- E. mysql --protocol=PLAIN -uroot -p -h dbhost.example.com
Answer: B,D
Explanation:
Explanation/Reference:
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
NEW QUESTION 92
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?
- A. A .mylogin.cnf file can store at most one login path.
- B. It is an alternative to storing the MySQL login details in a my.cnf file.
- C. It provides a FIPS-compliant keyring for storing MySQL login details.
- D. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- E. mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
- F. It provides means to help avoid accidentally exposing the MySQL login details.
Answer: B,F
Explanation:
Reference:
https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
NEW QUESTION 93
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?
- A. A .mylogin.cnf file can store at most one login path.
- B. mysql_config_editor is the only MySQL-provided utility that can print the values stored in
.mylogin.cnf. - C. It is an alternative to storing the MySQL login details in a my.cnf file.
- D. It provides a FIPS-compliant keyring for storing MySQL login details.
- E. A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- F. It provides means to help avoid accidentally exposing the MySQL login details.
Answer: C,F
NEW QUESTION 94
A master-slave replication setup has the slave showing this error:
On the master server, the binary logs show:
What could explain this error? (Choose two.)
- A. enforce_gtid_consistency=ONand consistency is broken between the master and the slave.
- B. The sync_relay_log=1000setting on the slave is too small.
- C. sync_binlog=0and the master server crashed.
- D. binlog_cache_size=1024is too small and transactions are lost.
- E. binlog_format=STATEMENTand a non-deterministic query was executed.
Answer: A,D
NEW QUESTION 95
Consider the two partial outputs of the SHOW GLOBAL VARIABLEScommand 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_connectionsvariable on the slave needs to be increased.
- B. server_idis not unique.
- C. The log_binvariable is set to OFF on the slave.
- D. The version of the slave is newer that the version of the master.
- E. The shared_memory_base_namevariable must match the master.
Answer: C
NEW QUESTION 96
Which two statements are true about MySQL when it has been started using the --skip-grant-tables option? (Choose two.)
- A. All users have unrestricted access.
- B. All connections succeed regardless of the username and password.
- C. User authentication is based on the operating system username.
- D. MySQL becomes read-only except for setting passwords.
- E. Only the password for active account can be changed.
Answer: A,B
Explanation:
You should not use skip-grant-tables options as it will start your server without using the privilege system.
It must be dangerous for you. Any one can access your account if you will use it.
If the server is started with the skip-grant-tables option, it does not read the grant tables or implement any access control. Anyone can connect and do anything, which is insecure.
Reference: https://www.ppgia.pucpr.br/pt/arquivos/techdocs/mysql/security.html
https://stackoverflow.com/questions/22849308/why-we-need-skip-grant-tables-in-mysql-to-remove-error-
1045access-denied-wha
NEW QUESTION 97
Consider the table people with the definition:
The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)
- A. Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
- B. Add a functional index for YEAR(Birthday).
- C. Add a generated column calculating YEAR(Birthday)and index that column.
- D. Add FORCE INDEX (Birthday)to the query.
- E. Execute ANALYZE TABLEto update the index statistics.
Answer: A,D
Explanation:
Explanation
NEW QUESTION 98
Consider:
Which statement best describes the meaning of the values in the ref columns?
- A. No indexed columns are used to select rows from the Countrytable. The world.City.CountryCodecolumn is used to select rows in the City table.
- B. world.City.CountryCodeis used as the primary key for the Country table.
- C. No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.
- D. world.City.CountryCode is used to sort the rows in the Citytable.
Answer: C
NEW QUESTION 99
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 and the table definition is changed.
- B. It results in a syntax error because you cannot specify more than one partition in the same statement.
- C. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
- D. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
Answer: D
NEW QUESTION 100
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; SET GLOBAL 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: B
NEW QUESTION 101
You have a MySQL replication setup and you intentionally stop the SQL thread on the slave.
What are two reasons that you may stop the SQL thread on the slave while keeping the I/O thread running?
- A. to allow a backup to be created under reduced load
- B. to allow for point-in-time recovery on the slave
- C. to prevent schema changes from propagating to the slave before they are validated
- D. to allow the remaining events to be processed on the slave while not receiving new events from the master
- E. to prevent any transaction experiencing a deadlock
Answer: A,B
NEW QUESTION 102
Which three allocate memory per thread in MySQL? (Choose three.)
- A. sort buffer
- B. thread cache
- C. read buffer
- D. query cache
- E. InnoDB buffer pool instance
- F. internal temporary table
Answer: A,C,E
Explanation:
Explanation/Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html
NEW QUESTION 103
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. Create additional login accounts (so that everyone does not need to log in as root) and assign them appropriate privileges.
- B. Execute a command with a minimal form of: mysql --initialize
- C. Set an exception in the host machine's firewall to allow external users to talk to mysqld.
- D. Create a configuration file containing default-storage-engine=InnoDB.
- E. Register mysqld as a service that will start automatically on this host machine.
Answer: D
NEW QUESTION 104
Consider the table people with the definition:
The application uses a query such as:
SELECT * FROM people WHERE YEAR(Birthday) = 1980;
The query is not using an index.
Which two methods can be used to allow the query to use an index? (Choose two.)
- A. Change the WHEREclause to Birthday BETWEEN 1980-01-01 AND 1980-12-31.
- B. Add a functional index for YEAR(Birthday).
- C. Add a generated column calculating YEAR(Birthday)and index that column.
- D. Add FORCE INDEX (Birthday)to the query.
- E. Execute ANALYZE TABLEto update the index statistics.
Answer: A,D
NEW QUESTION 105
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 and the table definition is changed.
- B. It results in a syntax error because you cannot specify more than one partition in the same statement.
- C. Only the first partition (p1) will be dropped because only one partition can be dropped at any time.
- D. All data in p1 and p3 partitions is removed, but the table definition remains unchanged.
Answer: D
NEW QUESTION 106
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 join buffer is used to process sorts when complex joins are being performed.
- C. The join buffer is set per connection.
- D. The value should be increased if the client performs several SELECToperations.
- E. The value should be increased from the default if the query joins large rows without using an index.
Answer: B,E
Explanation:
Explanation/Reference:
NEW QUESTION 107
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 LIMITclause to limit the deletion to 100,000 rows.
- B. If the data modification is non-deterministic, the query optimizer will resolve any potential issues.
- C. Use the LIMITclause in conjunction with the ORDER BYclause.
- D. Change the replication mode to MIXEDbefore issuing any delete statements when the LIMITclause is used.
Answer: C,D
Explanation:
Explanation/Reference:
NEW QUESTION 108
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. --master-data
- B. --skip-opt
- C. --single-transaction
- D. --lock-all-tables
- E. --create-apply-log
Answer: B,D
NEW QUESTION 109
You are remotely logged in to MySQL as the user "backup".
The account has temporarily been granted full privileges WITH GRANT to perform the actions required.
You want to change the password for the locally existing "backup" user.
Select the three commands which will perform the required action. (Choose three.)
- A. ALTER USER USER() IDENTIFIED BY 'password';
- B. SET PASSWORD FOR 'backup'@'localhost' = 'password';
- C. ALTER USER 'backup'@'localhost' IDENTIFIED BY 'password';
- D. SET PASSWORD FOR 'backup'@'localhost' = PASSWORD ('password')
- E. SET PASSWORD = 'password';
- F. ALTER USER 'backup' IDENTIFIED BY 'password';
- G. CREATE USER 'backup'@'localhost' IDENTIFIED BY 'password';
Answer: A,C,G
NEW QUESTION 110
......
Aim of the Certificate Exam
The certification exam is designed to help the candidate excel and command his future progression. It is designed to
- Provide individuals with a mark of excellence that is extremely recognized by the clients and seeks within across the industries
- Differentiate individual in a crowded job market
- Empower individuals to execute tasks with confidence and skill
1Z1-888 Dumps Ensure Your Passing: https://prep4sure.vcedumps.com/1Z1-888-examcollection.html
