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

  • 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 #11
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?
  1. A
    The access does not take effect until the user logs out and back in.
  2. B
    The access does not take effect until the next time the server is started.
  3. C
    The access is available immediately.
  4. D
    The access does not take effect until you issue the FLUSH PRIVILEGES statement.

Correct Answer:
C

Question #12
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.)
  1. A
    to allow the remaining events to be processed on the slave while not receiving new events from the master
  2. B
    to allow a backup to be created under reduced load
  3. C
    to allow for point-in-time recovery on the slave
  4. D
    to prevent schema changes from propagating to the slave before they are validated
  5. E
    to prevent any transaction experiencing a deadlock

Correct Answer:
BC

Question #13
Which two methods accurately monitor the size of your total database size over time? (Choose two.)
  1. A
    monitoring the Innodb_rows_inserted status variable
  2. B
    monitoring the innodb_redo_log_size variable
  3. C
    monitoring the information_schema.TABLES table
  4. D
    monitoring datadir size in the operating system
  5. E
    monitoring cumulative Innodb_page_size increase
  6. F
    monitoring the performance_schema_hosts_size variable

Correct Answer:
CF

Question #14
Consider the index information for the dept_emp table in the employee’s schema:

Which two conclusions can be made based on the output of the query? (Choose two.)
  1. A
    There are three indexes on the table.
  2. B
    There is a redundant index on the dept_no column.
  3. C
    The secondary indexes are optimized for unique key look-ups.
  4. D
    The values on the emp_no column must be unique.
  5. E
    The selectivity of the dept_no column is the best of the indexed columns.
  6. F
    There is a redundant index on the emp_no column.

Correct Answer:
CF

Question #15
Which two statements are true about InnoDB auto-increment locking? (Choose two.)
  1. A
    InnoDB never uses table-level locks.
  2. B
    InnoDB always protects auto-increment updates with a table-level lock
  3. C
    InnoDB does not use locks to enforce auto-increment uniqueness.
  4. D
    The auto-increment lock can be a table-level lock.
  5. E
    Some settings for innodb_autoinc_lock_mode can help reduce locking.

Correct Answer:
DE

Previous Questions Next Questions

All Pages