Oracle 1Z0-883 Online Practice Questions and Exam Preparation

Oracle 1Z0-883 Online Questions & Answers

• Question 51:

  You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?

  A. Ensure that none of the attached slaves are using any of the binary logs you want to delete.
  B. Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files.
  C. Execute the PURGE BINARY LOGE NOT USED command.
  D. Remove all of the binary log files that have a modification date earlier than today.
  E. Edit the .index file to remove the files you want to delete.
  D. Remove all of the binary log files that have a modification date earlier than today.

• Question 52:

  A database exists as a read-intensive server that is operating with query_cachek_type = DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment:

  

  A web application uses a limited set of queries.

  

  The Query Cache hit rate is high.

  

  All resultsets fit into the Query Cache.

  

  All queries are configured to use the Query Cache successfully.

  The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service.

  Based solely on the information provided, what is the most likely cause for this slowdown at the database level?

  A. The Query Cache is pruning queries due to an increased number of requests.
  B. Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups.
  C. Mutex contention on the Query Cache is forcing the queries to take longer due to its single- threaded nature.
  D. The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution.
  C. Mutex contention on the Query Cache is forcing the queries to take longer due to its single- threaded nature.

• Question 53:

  You have a server that has very limited memory but has a very large table.

  You will use mysqldump to back up this table.

  Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

  A. -- quick
  B. -- skip-buffer
  C. -- single-transaction
  D. -- tab
  C. -- single-transaction

• Question 54:

  Which two capabilities are granted with the SUPER privilege?

  A. Allowing a client to kill other client connections
  B. Allowing a client to shut down the server
  C. Allowing change of the server runtime configuration
  D. Allowing client accounts to take over the account of another user
  A. Allowing a client to kill other client connections
  B. Allowing a client to shut down the server

• Question 55:

  User A issues the command:

  LOCK TABLES pets READ;

  Which command can User B execute against the pets table?

  A. UPDATE pets...
  B. SELECT....FROM pets
  C. INSERT INTO pets...
  D. ALTER TABLE pets...
  B. SELECT....FROM pets

• Question 56:

  A user executes the statement;

  PURGE BINARY LOGS TO `mysql-bin.010';

  What is the result?

  A. It deletes all binary log files, except `mysql-in.010'.
  B. It deletes all binary log files up to and including `mysql-bin.010'.
  C. It deletes all binary log files before `mysql-bin.010'.
  D. It deletes all binary log files after `mysql-bin.010'.
  B. It deletes all binary log files up to and including `mysql-bin.010'.

• Question 57:

  Identify a performance impact when using the Performance Schema.

  A. There is no impact on performance.
  B. There is an overhead for querying the Performance Schema but not for having it enabled.
  C. There is a constant overhead regardless of settings and workload.
  D. The overhead depends on the settings of the Performance Schema.
  B. There is an overhead for querying the Performance Schema but not for having it enabled.

• Question 58:

  You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory. Why is it important to remove snapshots after completing a RAW backup in this way?

  A. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.
  B. The snapshot size will continue to grow as changes to the volume are made.
  C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.
  D. The system keeps a copy of changes in memory and can cause an out of memory event.
  C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.

• Question 59:

  Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?

  A. Both technologies use the TCP/IP stack as their primary transmission medium.
  B. DRBD uses shared-disk technology.
  C. Both technologies guarantee an identical copy of data on the secondary node.
  D. Only MySQL can maintain a time-delayed copy of data on the secondary node.
  B. DRBD uses shared-disk technology.

• Question 60:

  Which two options describe how MySQL Server allocates memory?

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