1Z0-873 Exam Questions

The CHECK TABLE command should be used...

The REPAIR TABLE command should be used...

The ANALYZE TABLE command should be used...

The OPTIMIZE TABLE command should be used...

The myisamchk command-line program must not be run on a set of tables if...

The CHECK TABLE command...

Which of the following steps should be taken to restore an InnoDB table to a consistent state without having to shutdown the server?

After a server crash, some InnoDB tables need to be repaired. However, when the server is restarted, auto-recover failed. How would you repair the InnoDB tables?

Which of the following is true of the mysqldump client program?

Using mysqldump, which of the following commands are used to backup one database?

Which of following list the default order in which option files are read on UNIX?

Which of the following are reasons to not just enable all logging?

In which of the following locations can sample .cnf or .ini files be found in any distribution?

Which of the following statements best describe the purpose of the general query log and how you enable it?

Which two of the following statements best describe the purpose of the slow query log and how you enable it?

Suppose you want queries that are not using indexes to be logged to the slow log. How would you enable this?

Which of the following best describe what the mysql_tzinfo_to_sql script is needed for and how to use it?

Which of the following steps should be performed in order to secure a MySQL server freshly installed from a binary tarball.

Which of the following are true with regards to the server SQL mode?

Which of the following should be done before upgrading the mysql server to a newer version?

When you upgrade from one version of MySQL to another which of these steps are considered necessary?

mysqldump can be instructed to include commands to drop and recreate tables before trying to create or load data.

Which of the following best describe a replication setup with regard to backup procedures?

When backing up a replication slave, which of the following replication files should also be backed up?

Assume you created a backup of the world database by the following statement. shell> mysqldump --opt world > dump.sql How can you import the data from this dumped file into the tes...

You have created a dump using mysqldump with the --extended-insert option. Will you be able to use this dump on any MySQL server instance?

The MySQL server host crashes at 10:00 in the morning, and is brought back online at 10:30. In order to ensure that all data are consistent, a copy is first made of the table, tabl...

Consider the three binary log files bin.00010, bin.00011 and bin.00012 which you want to restore data from. How should you process these files when using mysqlbinlog to satisfy int...

Consider the available command line options of mysqlbinlog. Which of the following statements are true?

Which of the following SQL constructs are not available with all storage engines, i.e. which are storage engine dependent?

Which of the following are true regarding the key buffer cache?

Which of the following are true regarding the table cache?

In which of the following files must the base directory be specified if MySQL is not installed in the default directory for the platform?

Which one of the following statements can be used to start MySQL 5.0 manually from the command line on windows?

Another user has issued LOCK TABLES pets READ You can...

Which of the following statements are true for locks established by the InnoDB storage engine?

Which of the following is true for how the InnoDB storage engine uses diskspace?

Which of the following is true for the command-line programs mysqlcheck and myisamchk?

MySQL is a multi-threaded database server. Every connection to the database server is handled by it's own thread.

mysqldump can be instructed to dump...

Which of the following is true of a MySQL client and server?

Which of the following APIs/connectors are included in a MySQL distribution?

Of the following mechanisms available to connect a MySQL client to a MySQL database server, which types of connections are only available on Windows based systems?

Suppose you have a server that has been started with the --myisam-recover option. When does the server perform the check on the MyISAM tables?

Will the following SELECT query list all of the tables in the INFORMATION_SCHEMA database? If not, why? SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'INFOR...

Complete the following sentence. The INFORMATION_SCHEMA.SCHEMATA table contains information about ...

Consider the following query: DELETE FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'world' AND table_name = 'Country' What would be the result of executing this query?

What are some advantages of using the INFORMATION_SCHEMA database rather than using the SHOW command?

What are some advantages of using the SHOW command rather than using the INFORMATION_SCHEMA?

Which of the following statements regarding the SHOW command and the INFORMATION_SCHEMA database are true?