Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-888

Oracle 1z0-888 Exam Practice Questions (P. 5)

  • Full Access (155 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
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.)
  1. A
    mysql --protocol=PLAIN –uroot –p –h dbhost.example.com
  2. B
    INSTALL PLUGIN mysql_cleartext_password SONAME ‘mysql_cleartext_password.so’;
  3. C
    export LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN=’Y’
  4. D
    SET GLOBAL mysql_cleartext_passwords=1;
  5. E
    mysql --enable-cleartext-plugin –uroot –p –h dbhost.example.com

Correct Answer:
DE

Question #22
Which are three facts about backups with mysqldump? (Choose three.)
  1. A
    will lock all storage engines for duration of backup
  2. B
    can back up a remote database server
  3. C
    allow a consistent backup to be taken
  4. D
    are able to back up specific items within a database
  5. E
    create automatically compressed backups
  6. F
    are always faster to restore than binary backups

Correct Answer:
BCD

Question #23
Consider the key buffer in a MySQL server.
Which two statements are true about this feature? (Choose two.)
  1. A
    It caches index blocks for MyISAM tables only.
  2. B
    It caches index blocks for all storage engine tables.
  3. C
    It is a global buffer.
  4. D
    It is set on a per-connection basis.
  5. E
    It caches index blocks for InnoDB tables only.

Correct Answer:
AD

Question #24
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. A
    log-master-updates
  2. B
    rpl-recovery-rank
  3. C
    server-id
  4. D
    enable-master-start
  5. E
    log-bin
  6. F
    master-logging

Correct Answer:
CE

Question #25
You have a MySQL instance with the following variables in the /etc/my.cnf file:

You issue these statements:
USE prices;
UPDATE sales.january SET amount=amount+1000;
An hour after excluding the statements, you realize that you made a mistake and you want to go to the binary log and look at the statements again.
Which statement is true? (Choose two.)
  1. A
    You would receive an error on the statement because you cannot update a different database that what is specified with the USE statement.
  2. B
    The changes caused by the UPDATE statement are logged to the binary log because the instance is using --binlog-format = ROW
  3. C
    The statement would fail because you cannot update more than one row at a time when using --binlog-format = ROW.
  4. D
    Nothing is logged because you are executing an UPDATE statement that will cause changes to more than one row, and you do not have the --binlog-format value set to STATEMENT.
  5. E
    Nothing was written to the binary log because you cannot perform a calculation in a query without enclosing the statement in single quotation marks.

Correct Answer:
DE

Previous Questions Next Questions

All Pages