1Z0-873 - MySQL 5 Database Administrator Certified Professional Exam

Go back to Oracle

Example Questions

Which of the following commands can be used to stop a MySQL server on a UNIX system? Which of the following is true for the command-line programs mysqlcheck and myisamchk? Which of the following list the difference between mysqld, mysqld_safe and mysql.server respectively? Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server? The REPAIR TABLE command should be used... Which of the following best describes how MySQL utilizes the grant table buffers? Which of the following SQL constructs are not available with all storage engines, i.e. which are storage engine dependent? Which of the following best describes why table locking is often not desirable compared to page or row locking? 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 MyISAM tables? When working with InnoDB, which of the following is true when trying to create foreign key references? When working with InnoDB, which of the following are true of a parent / child foreign key relationship? Which of the following are requirements for InnoDB binary portability? Which of the following APIs/connectors are included in a MySQL distribution? Which of the following is true of a MySQL client and server? When running the MySQL server under Windows, the --console option is used to display server errors in the console window. Index analysis and optimization using ANALYZE and OPTIMIZE statements should... LOCK IN SHARE MODE should be used... Which two of the following statements best describe the purpose of the slow query log and how you enable it? When working with MyISAM tables, which of the following statements are true regarding deadlocks? When working with the InnoDB storage engine, which of the following correctly defines the READ COMMITTED isolation level? When starting the mysqld program, which of the following statements are true? 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? Which of the following can be influenced by the choice of character set? When choosing a storage engine for each of your tables, which things are to consider? Which of the following are some benefits of using MySQL built binaries over binaries built by yourself? Which of the following statements best describe the purpose of the general query log and how you enable it? 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? In which of the following locations can sample .cnf or .ini files be found in any distribution? Which of the following are requirements for MyISAM binary portability? 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-opts.cnf Another user has gotten a lock using GET_LOCK. You inquire on the status of the lock by using Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table? Besides specifying the column names and data types, which connection parameters may be defined when defining a FEDERATED table? Which of the following package types are provided specifically for UNIX-style OS installations? Which of the following correctly describes the differences between explictly and implicitly set locks? Which of the following are true with regards to the server SQL mode? Which of the following correctly defines the general difference between a read lock and a write lock? Which of the following steps should be taken to restore an InnoDB table to a consistent state without having to shutdown the server? Suppose your are adding rows to a MyISAM table and the server runs out of disk space. What will happen? When installing a RPM based distribution, the data directory will be set to which of the following locations? When specifying options, which of the following are valid advantages of using options files over parameters on a command line? Another user has issued LOCK TABLES pets READ You can... Some statements implicitly commit pending transactions and start a new one. 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 inter-file dependencies? Which mysqld command line option disables incoming TCP/IP connections? 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 now locked? Using mysqldump, which of the following commands are used to backup one database? The CHECK TABLE command should be used... 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, tablespace and log files currently on the server host, and these files are then restored from a backup made at 03:00 the same morning. What should be done in order to bring the database to the state it was at just before the server host crashed?

Study Guides