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

Page 4 of 39
PDF with 155 Questions

Which two options describe how MySQL Server allocates memory? (Choose two.)

  1. Each connection may have its own per-thread memory allocations.
  2. Thread memory is pre-allocated up to thread_cache_size for performance.
  3. Each thread allocates memory from a global pool.
  4. Global memory resources are allocated at server startup.

Answer(s): A,D



Which three are key advantages of standard MySQL replication? (Choose three.)

  1. supports native automatic failover
  2. enables automatic resync of databases when discrepancies are detected
  3. provides arbitrary geographic redundancy with minimal overhead to master
  4. synchronously guarantees identical slave copy
  5. is easy to configure and has low performance overhead
  6. can easily add slaves for read scaling

Answer(s): B,E,F



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

Answer(s): C



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

Answer(s): B,C



Viewing page 4 of 39
Viewing questions 13 - 16 out of 155 questions



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

1z0-888 Exam Discussions & Posts