The type of file system you chose may affect MySQL use and/or performance with regard to...
A. Table opening time.
B. Size limits of files.
C. Time to recover from a crash.
D. The number of users MySQL can handle.
E. The type of storage engines that can be used.
Which of the following steps are used to create database symbolic links on Windows?
A. Stop the server.
B. Restart the server.
C. Use the ln -s command.
D. Update your my.ini with the path to the new location.
E. Move the database directory from the data directory to a new location.
F. Create a file in the data directory with the database name with an extension of .sym that contains the full path to the new location.
Which of the following best describes the effect that the per-process limit of open file descriptors in an operating system has on MySQL, and what can be done to increase it?
A. The --open-files-limit option can be used to increase it.
B. It limits the amount of operations MySQL can perform at one time.
C. It limits the maximum size of the table cache that holds file descriptors.
D. The operating system may be able to be reconfigured to increase this limit.
Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it?
A. It is limited by the maximum size of the table cache.
B. The --key_cache option may be used to increase the limit.
C. The maximum number of threads per-process of the operating system.
D. The operating system may be able to be reconfigured to increase this limit.
Which of the following best describes what the connection backlog is and why it may need to be increased?
A. It may need to be increased on a server with a high rate of transactions.
B. The backlog is the queue of processes waiting to be processed on a server.
C. The backlog is the queue of network connections of clients waiting to connect.
D. It may need to be increased on a server with a high rate of client connections.
Which of the following optimizations could be made based on data collected in the slow query log?
A. Tune server parameters.
B. Change the storage engines in use.
C. Make changes to the network infrastructure.
D. Rewrite queries to perform more efficiently.
E. Normalize data or add indexes to the tables that the queries use.
Which of the following best describes what mysqldumpslow does and how to use it?
A. It shows a summary of the slow log contents.
B. It dumps the contents of the slow log into a readable format.
C. shell> mysqldumpslow log_name
D. shell> mysqldumpslow < log_name
When choosing hardware for your MySQL server, is memory important to MySQL and why?
A. No, because MySQL makes use of virtual memory on disks.
B. No, because MySQL makes more use of disks and processors than memory.
C. Yes, because more memory allows for less swapping by the operating system.
D. Yes, because more memory allows for larger buffers improving caching and reducing disk usage.
Which of the following disk characteristics are most important to a database server and why?
A. Disk size, because a database needs a lot of storage space.
B. Transfer rate, because the database needs to be able to transfer the data off the disks at a very high rate.
C. Disk seek time, because it is more important for the heads of the disk to move quickly from track to track.
Which of the following best describe what could cause low utilization of query cache?
A. The query cache size is too small.
B. The CACHE_QUERY keyword is not being used.
C. The Qcache_priority variable is set too small.
D. The server might be trying to cache queries when it really isn't worth it.
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.