1Z0-873 Exam Questions

What three data components are needed for data recovery?

What are some general principles of making a good MySQL backup?

Which of the following are some trade-offs between binary and text backups?

Which of the following steps describe how to do a proper binary backup of MyISAM tables?

Which of the following steps describe how to do a proper binary backup of InnoDB data?

Which of the following are requirements for MyISAM binary portability?

In order to use SELECT INTO OUTFILE backups, the output file

Which of the following statements is true for mysqldump?

Which of the following are some benefits of using MySQL built binaries over binaries built by yourself?

A windows binary installation includes several servers in the MySQL installation directory. What is the purpose of the mysqld-nt server?

When running the MySQL server under Windows, the --console option is used to display server errors in the console window.

What will the following statement do in a Windows environment? Assume that there are no conflicts in the pathname definitions. C:\> mysqld --install MySQL50 --defaults-file=C:\my-o...

Which of the following would be the effect of setting REFERENCES with ON UPDATE CASCADE?

Which of the following storage engines will ignore foreign keys if they are specified?

When working with InnoDB, which of the following are true of a parent / child foreign key relationship?

When working with InnoDB, which of the following is true when trying to create foreign key references?

Which of the following statements are true for InnoDB?

The my.cnf file contains the following entries: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:50M;/disk2/ibdata2:50M:autoextend Which of the following statements a...

Which of the following are some general characteristics of the MEMORY storage engine?

Which of the following are true for how BTREE and HASH index types should be used for MEMORY tables?

Which of the following statements are true regarding the data directory on a Windows binary installation?

Which of the following are requirements for InnoDB binary portability?

Which of the following package types are provided specifically for UNIX-style OS installations?

Index analysis and optimization using ANALYZE and OPTIMIZE statements should...

Suppose you install a server with a service name of "MySQL5" rather than the default. What sections in the option files will the server use for configuration?

Assume you compile MySQL from source and invoke configure with the following options. --with-charset=latin1 --with-extra-charsets=utf8,ucs2 Compared to a standard binary installati...

Which of the following can be influenced by the choice of character set?

Suppose you have a column in which most records are going to be between 30 and 32 characters. Which of the following column types would be most efficient?

You are using a multi-byte character set with variable-length encoding. You need to store records whose values are always 20 characters. Which of the following column types would b...

Another user has gotten a lock using GET_LOCK. You inquire on the status of the lock by using

Another user has issued the statement LOCK TABLE pets FOR WRITE You can...

Which of the following statements are true?

Which of the following statements are true?

When you set up per-table tablespace files for InnoDB...

Which of the following happens when BEGIN TRANSACTION or START TRANSACTION command is issued?

Which of the following statements are true with regard to savepoints in transactions?

Some statements implicitly commit pending transactions and start a new one.

Which of the following describes how deadlocks may occur and how InnoDB resolves them?

LOCK IN SHARE MODE should be used...