How to pass 1Z0-888 exam easily with less time? We provides the most valid 1Z0-888 pdf to boost your success rate in Oracle Database 1Z0-888 MySQL 5.7 Database Administrator exam. If you are one of the successful candidates with We 1Z0-888 exam questions, do not hesitate to share your reviews on our Oracle Database materials.
Visit our site to get more 1Z0-888 Q and As:https://www.itexambus.com/1z0-888.html (155 QAs Dumps)
Question 1:
Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?
A. mysqldumpslow
B. mysqldump
C. mysqlaccess
D. mysqlshow
E. mysqlslow
Correct Answer: A
Question 2:
Is it true that binary backups always take less space than text backups?
A. Yes, because binary backups only contain data, and not statements required to insert data into the tables.
B. No, because text backups can have optimizations, which make them smaller, such as updating many rows at once.
C. No, because if InnoDB tables contain many empty pages, they could take more space than the INSERT statements.
D. Yes, because even if InnoDB tables contain many empty pages, text backups have empty INSERT statements for them.
Correct Answer: C
Question 3:
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command; shell> mysql –u root –p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely for this slowdown?
A. The MySQL server has stopped inserting data to check index consistency.
B. InnoDB is doing CRC32 checks over the tablespace data as it grows.
C. The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.
D. InnoDB has filled the redo log and now must flush the pages.
E. Secondary indexes no longer fit into the buffer pool.
Correct Answer: A
Question 4:
Which two options describe how MySQL Server allocates memory? (Choose two.)
A. Each connection may have its own per-thread memory allocations.
B. Thread memory is pre-allocated up to thread_cache_size for performance.
C. Each thread allocates memory from a global pool.
D. Global memory resources are allocated at server startup.
Correct Answer: AD
Question 5:
You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?
A. The access does not take effect until the user logs out and back in.
B. The access does not take effect until the next time the server is started.
C. The access is available immediately.
D. The access does not take effect until you issue the FLUSH PRIVILEGES statement.
Correct Answer: C
Question 6:
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? (Choose two.)
A. to allow the remaining events to be processed on the slave while not receiving new events from the master
B. to allow a backup to be created under reduced load
C. to allow for point-in-time recovery on the slave
D. to prevent schema changes from propagating to the slave before they are validated
E. to prevent any transaction experiencing a deadlock
Correct Answer: BC
Question 7:
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 option.
Correct Answer: C
Reference: https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
Question 8:
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. mysql –protocol=PLAIN –uroot –p –h dbhost.example.com
B. INSTALL PLUGIN mysql_cleartext_password SONAME `mysql_cleartext_password.so\’;
C. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=\’Y\’
D. SET GLOBAL mysql_cleartext_passwords=1;
E. mysql –enable-cleartext-plugin –uroot –p –h dbhost.example.com
Correct Answer: DE
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Question 9:
Which are three facts about backups with mysqldump? (Choose three.)
A. will lock all storage engines for duration of backup
B. can back up a remote database server
C. allow a consistent backup to be taken
D. are able to back up specific items within a database
E. create automatically compressed backups
F. are always faster to restore than binary backups
Correct Answer: BCD
Question 10:
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:
The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?
A. They are not affected by this configuration change.
B. They all connect via the secure sha256_password algorithm without any configuration change.
C. They will have their passwords updated on start-up to sha256_password format.
D. They will have to change their password the next time they login to the server.
Correct Answer: A
Question 11:
You are no longer able to log in to an existing MySQL Server because the root password credentials not working. You need to reset the root password to complete various administrative tasks. What are the two major methods that will achieve this? (Choose two.)
A. Start the MySQL Server in –safe-mode, which only loads the privilege system for changes as data is inaccessible.
B. Start the MySQL Server with reset-root-password in my.cnf, which will prompt you to enter a new root user password.
C. Start the MySQL Server with –init-file pointing to SQL that executes an ALTER USER statement to change the root user password.
D. Start the MySQL Server with –skip-grant-tables and execute SQL, which will update the root password.
E. Start the MySQL Server with 璱nitialize-insecure to force a password reset procedure on the command line.
Correct Answer: CD
Reference: https://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html
Question 12:
These details are shown when logged in to an account:
Which set of statements would match the accounts shown?
A. mysql> CREATE USER `employee\’@\’localhost\’ IDENTIFIED BY `more_secrets\’; mysql> CREATE USER \’\’@\’\’ IDENTIFIED BY `valid_password\’ WITH PROXY `employee\’@\’localhost\’;
B. mysql> CREATE USER `employee\’@\’localhost\’ IDENTIFIED BY `more_secrets\’; mysql> GRANT PROXY ON `employee\’@\’localhost\’ TO `robert\’@\’localhost\’;
C. mysql> CREATE USER `robert\’@\’localhost\’ IDENTIFIED BY `secret_password\’; mysql>CREATE USER `employee\’@\’localhost\’ IDENTIFIED BY `more_secrets\’;
D. mysql> CREATE_USER \’\’@\’\’ IDENTIFIED WITH authentication_pam ACCOUNT LOCK; mysql> CREATE USER `employee\’@\’localhost\’ IDENTIFIED BY `more_secrets\’; mysql> GRANT PROXY ON `employee\’@\’localhost\’ TO \’\’@\’\’;
Correct Answer: D
Question 13:
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 host on the command line is not defined in the login path.
B. The mysqld instance has not been restarted after creating the login path.
C. There is no password defined in the login path.
D. The DNS is not configured correctly for slave1 host.
E. The .mylogin.cnf file is not readable.
Correct Answer: E
Question 14:
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 LOAD FROM *.*
B. setting the –local-service=0 option when starting mysqld
C. executing REVOKE FILE FROM *_*
D. executing REVOKE FILE ON *_* FROM ` `@\’%\’
E. setting the –local-infile=0 option when starting mysqld
F. setting the –open-files-limit=0 option when starting mysqld
Correct Answer: F
Question 15:
Which three tasks are handled by the optimizer? (Choose three.)
A. Decide which indexes to use.
B. Rewrite the WHERE clause.
C. Parse the query.
D. Change the order in which the tables are joined.
E. Validate the query.
F. Execute the query.
G. Verify that the user is allowed to execute the query.
Correct Answer: BCF
Visit our site to get more 1Z0-888 Q and As:https://www.itexambus.com/1z0-888.html (155 QAs Dumps)