Download Oracle.1z0-888.PracticeTest.2018-09-19.38q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-888 |
| Exam Name: | MySQL 5.7 Database Administrator |
| Date: | Sep 19, 2018 |
| File Size: | 904 KB |
Demo Questions
Question 1
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?
- Run the create_system_tables.sql file
- Run the mysql_unpack.sql file
- Invoke mysqld with the --initialize option.
- Invoke mysql with the --initialize option.
Correct answer: C
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html Reference: https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html
Question 2
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?
- mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
- INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
- export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
- SET GLOBAL mysql_cleartext_passwords=1;
- mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com
Correct answer: DE
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html Reference: https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html
Question 3
Which are three facts about backups with mysqldump?
- will lock all storage engines for duration of backup
- can back up a remote database server
- allow a consistent backup to be taken
- are able to back up specific items within a database
- create automatically compressed backups
- are always faster to restore than binary backups
Correct answer: BCD
