When performing diagnostic functions on a server should excessive start and stop messages be looked for in the error log, and why?
A. No, start and stop messages are of no relevance to diagnostics.
B. Yes, because there is a bug in mysqld that can cause multiple start and stop messages to be inserted in the log.
C. No, because they will not provide any information as to what is wrong.
D. Yes, because they can indicate that there is something causing the server to restart unexpectedly and not due to normal startup and shutdown.
Which of the following best describe the purpose of the long_query_time variable?
A. It is used to tell the server when to log a query as slow.
B. It is used to see the time it took the last longest query to run.
C. It is used to tell the server after how many seconds to abort a query.
D. It is used to tell the server the total CPU seconds that are allotted to a client connection before it shut down.
Which of the following best describes the table cache in MySQL and some of its properties?
A. The table cache is a global cache for all open tables.
B. Separate table caches are created for data in each open table.
C. It is used to cache frequently used table indexes.
D. It is used to cache the status of individual tables.
Which of the following statements best describe the key buffer?
A. It is a global buffer.
B. It is set on a per-connection basis.
C. It caches index blocks for MyISAM tables only.
D. It caches index blocks for InnoDB tables only.
E. It caches index blocks for all storage engine tables.
Which of the following best describes the purpose of the InnoDB buffer pool?
A. It caches data and index information for InnoDB tables.
B. It is the amount of buffers available during a transaction.
C. It holds changes made during a transaction before they are written to the log.
Which of the following best describes what you might expect after disabling InnoDB at run time?
A. It will disable InnoDBs associated memory buffers and data structures, however it will not save any memory.
B. It will still enable InnoDBs associated memory buffers and data structures, however it will save memory.
C. It will disable InnoDBs associated memory buffers and data structures, which will save memory.
Which of the following best describes the purpose of the record buffer (as controlled through the read_buffer_size variable), and how it is set?
A. The record buffer is set per connection.
B. The record buffer is used for operations such as ORDER BY or GROUP BY.
C. The record buffer is global and is only set by restarting the server.
D. The record buffer is used to perform sequential table scans, reducing the number of reads from disk.
Which of the following correctly describe the purpose of the sort buffer, and when it is set?
A. The size of the sort buffer is set per-connection.
B. The sort buffer is global and the size can only be set by restarting the server.
C. The sort buffer is used to control the maximum number of sorts the server can perform simultaneously.
D. The sort buffer is used for operations such as ORDER BY or GROUP BY which can speed up sorting operations.
Which of the following best describes the purpose of the join buffer, and when should you increase the size of it?
A. The join buffer is used to process joins.
B. The join buffer is set per-connection.
C. The join buffer is global and can only be changed by restarting the server.
D. The value should be increased if the client performs a lot of SELECT operations.
E. The join buffer is used to process sorts when complex joins are being performed.
F. The value should be increased if the client has the tendency to perform complex joins.
When should you enable the Query Cache?
A. A lot of repeating and identical SELECT queries are received by the server.
B. The underlying tables don't change very often.
C. The server machine has more than one CPU.
D. The server machine has more than one network interface.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-874 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.