Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1z0-888

Free Oracle 1z0-888 Exam Braindumps (page: 9)

Page 7 of 39
PDF with 155 Questions

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.)

  1. mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
  2. INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
  3. export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
  4. SET GLOBAL mysql_cleartext_passwords=1;
  5. mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

Answer(s): D,E


Reference:

https://dev.mysql.com/doc/refman/5.7/en/cleartext-pluggable-authentication.html



Which are three facts about backups with mysqldump? (Choose three.)

  1. will lock all storage engines for duration of backup
  2. can back up a remote database server
  3. allow a consistent backup to be taken
  4. are able to back up specific items within a database
  5. create automatically compressed backups
  6. are always faster to restore than binary backups

Answer(s): B,C,D



Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

  1. It caches index blocks for MyISAM tables only.
  2. It caches index blocks for all storage engine tables.
  3. It is a global buffer.
  4. It is set on a per-connection basis.
  5. It caches index blocks for InnoDB tables only.

Answer(s): A,D


Reference:

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



You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

  1. log-master-updates
  2. rpl-recovery-rank
  3. server-id
  4. enable-master-start
  5. log_bin
  6. master-logging

Answer(s): C,E


Reference:

https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql



Viewing page 9 of 39
Viewing questions 33 - 36 out of 155 questions



Post your Comments and Discuss Oracle 1z0-888 exam prep with other Community members:

1z0-888 Exam Discussions & Posts