1Z0-873 Exam Questions

Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server?

Which mysqld command line option disables incoming TCP/IP connections?

When making connections to a MySQL server on a Unix platform, which of the following is true?

Which of the following best describes the processing model for how the MySQL server handles queries?

Which of the following best describes how MySQL utilizes the grant table buffers?

In a standard MySQL installation which of following files are stored below the data directory?

Where is the data stored for a table that is defined as using the FEDERATED Storage Engine?

Which of the following best describes the scope of explicitly and implicitly set locks?

When you acquire an advisory lock using GET_LOCK(), the lock is released if

which of the following best describes why table locking is often not desirable compared to page or row locking?

With MyISAM table locking, deadlocks do not occur because:

Which of the following (series of) statements will leave the three tables A, B and C locked for reading, writing and reading respectively once all statements have been executed?

You want to lock the three tables a, b and c, and issue the following statements: mysql> LOCK TABLES a READ; mysql> LOCK TABLES b READ; mysql> LOCK TABLES c READ; Which tables are...

When choosing a storage engine for each of your tables, which things are to consider?

Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table?

Which of the following methods can be used to determine the storage engine of your table named "Country"?

Which of the following storage engines cannot be disabled?

Which of the following features are supported by MyISAM tables?

Which of the following actions are performed during an RPM installation of the MySQL server package?

When installing a RPM based distribution, the data directory will be set to which of the following locations?

Which of the following list the difference between mysqld, mysqld_safe and mysql.server respectively?

Which of the following commands can be used to stop a MySQL server on a UNIX system?

On a Unix host with the host name "sakila", where will mysqld write errors to?

When starting the mysqld program, which of the following statements are true?

Which types of startup options can be configured for the server?

When specifying options, which of the following are valid advantages of using options files over parameters on a command line?

Which of the following statements are true for MyISAM tables?

Suppose your are adding rows to a MyISAM table and the server runs out of disk space. What will happen?

When working with MyISAM tables, which of the following statements are true regarding deadlocks?

Which of the following are characteristics of the MyISAM fixed-row storage format as compared to the dynamic row format?

Which of the following statements are true for the MERGE storage engine?

When will you be able to copy InnoDB table space files to other systems and use the data there?

Which of the following statements are true regarding the InnoDB storage engine?

When working with InnoDB, for which of the following reasons should you use the FOR UPDATE locking modifier?

Which of the following correctly defines dirty reads, non-repeatable reads and phantom row?

When working with the InnoDB engine, which of the following correctly defines the READ UNCOMMITTED isolation level?

When working with the InnoDB storage engine, which of the following correctly defines the READ COMMITTED isolation level?

Isolation levels can be set...

Which of the following are effects of defining foreign keys in InnoDB tables without specifying either ON UPDATE or ON DELETE?

Which of the following statements are true for tables using the FEDERATED storage engine?

Besides specifying the column names and data types, which connection parameters may be defined when defining a FEDERATED table?

Which of the following are some general capabilites of the mysql client program?

which of the following are some general capabilities of the mysqladmin client program?

Which of the following are some general properties of the mysqlimport client program?

Which of the following is/are properties of the mysqldump client program?

Which of the following correctly defines the general difference between a read lock and a write lock?

Which of the following correctly describes the differences between explicitly and implicitly set locks?

What are some properties of using LOCK TABLE?

Which of the following describes how READ LOCAL locking works?

Which of the following statements are true regarding table locks?