Which of the following best describes what MASTER_LOG_FILE and MASTER_LOG_POS provides?
A. The path of the log file.
B. The file to log replication actions to.
C. The masters binary log name used for replication.
D. The position in the masters binary log in which to start replication.
Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system.
A. true
B. false
Which of the following are requirements for running more than one MySQL server on the same machine?
A. On Windows each server that runs as a service must have a different service name.
B. Each server must have its own log files.
C. Each server must share the same error log.
D. Each server must run on a different disk.
E. Each server must have its own network interfaces.
F. There must be more than one processor on the machine.
G. InnoDB tablespace files must be separate between servers.
Which of the following are general features of replication?
A. Can be used to distribute the load caused by servicing many clients.
B. Provides complete redundancy and high availability at all times.
C. Multiple copies are available in case a server crashes or goes offline.
D. Allows the databases on one server to be made available on another server.
What kind of replication is supported by the MySQL server?
A. Multiple-master replication
B. Master to slave replication
C. Single file based clustering
D. MySQL doesn't support replication
Can you have several MySQL servers running on the same computer, using the same InnoDB tablespace files?
A. No
B. Yes, always
C. Yes, provided their permissions are set to read-only
Which of the following is/are required on the master server for replication to work?
A. Issue the START MASTER command.
B. Binary logging must be turned on.
C. Tell the master which slaves to connect to.
D. Make a backup of all databases to be replicated.
Which of the following best describe some possible benefits of using RAID?
A. Better user-level security.
B. Data redundancy.
C. Read performance gains.
D. Write performance gains. E. Hot-swappable disk drives.
E. Better memory and processor utilization.
Suppose you have a server whose log files, data directory, and temporary files are distributed on different disks. How would this affect overall performance, compared to a server where all components reside on a single disk?
A. Performance would remain about the same, because the same amount of disk usage would be needed.
B. You would expect a performance gain because the disk related activities would be split more evenly.
C. Performance would drop because the server would have to do extra work to read information off of the different disks.
Which of the following are methods to improve performance?
A. Spreading single tables to different disks pointed to by a symbolic link.
B. Spreading whole databases to different disks pointed to by a symbolic link.
C. Moving the MySQL utilities such as mysqladmin to different disks pointed to by a symbolic link.
D. Moving less needed parts of the MySQL install such as the documentation or the test files to different disks pointed to by a symbolic link.
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.