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

  • 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 #16
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server.
Which two changes would ensure that the temporary table does not propagate to the slave? (Choose two.)
  1. A
    Set binlog_format=MIXED with the --replicate-ignore-temp-table option.
  2. B
    Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.
  3. C
    Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.
  4. D
    Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.
  5. E
    Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

Correct Answer:
BE

Question #17
Which three allocate memory per thread in MySQL? (Choose three.)
  1. A
    query cache
  2. B
    thread cache
  3. C
    read buffer
  4. D
    internal temporary table
  5. E
    sort buffer
  6. F
    InnoDB buffer pool instance

Correct Answer:
CEF

Question #18
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space.
What will happen when this occurs?
  1. A
    The server will crash.
  2. B
    The server suspends that INSERT operation until space becomes available.
  3. C
    An error message will be returned to the client .Server Error: ER_IO
  4. D
    The server suspends operations for all storage engines until space becomes available.

Correct Answer:
B

Question #19
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? (Choose two.)
  1. A
    mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
  2. B
    A .mylogin.cnf file can store at most one login path.
  3. C
    It provides a FIPS-compliant keyring for storing MySQL login details.
  4. D
    A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
  5. E
    It is an alternative to storing the MySQL login details in a my.cnf file.
  6. F
    It provides means to help avoid accidentally exposing the MySQL login details.

Correct Answer:
EF

Question #20
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?
  1. A
    Run the create_system_tables.sql file
  2. B
    Run the mysql_unpack.sql file
  3. C
    Invoke mysqld with the --initialize option.
  4. D
    Invoke mysql with the --initialize option.

Correct Answer:
C

Previous Questions Next Questions

All Pages