1Z0-873 Exam Questions
139 real 1Z0-873 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
Which of the following statements correctly describes the way to enable and use shared memory connections to the MySQL database server?
- Question #2
Which mysqld command line option disables incoming TCP/IP connections?
- Question #3
When making connections to a MySQL server on a Unix platform, which of the following is true?
- Question #4
Which of the following best describes the processing model for how the MySQL server handles queries?
- Question #5
Which of the following best describes how MySQL utilizes the grant table buffers?
- Question #6
In a standard MySQL installation which of following files are stored below the data directory?
- Question #7
Where is the data stored for a table that is defined as using the FEDERATED Storage Engine?
- Question #8
Which of the following best describes the scope of explicitly and implicitly set locks?
- Question #9
When you acquire an advisory lock using GET_LOCK(), the lock is released if
- Question #10
which of the following best describes why table locking is often not desirable compared to page or row locking?
- Question #11
With MyISAM table locking, deadlocks do not occur because:
- Question #12
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?
- Question #13
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...
- Question #14
When choosing a storage engine for each of your tables, which things are to consider?
- Question #15
Which of the following variables specify the default storage engine to use if no storage engine is specified when creating a table?
- Question #16
Which of the following methods can be used to determine the storage engine of your table named "Country"?
- Question #17
Which of the following storage engines cannot be disabled?
- Question #18
Which of the following features are supported by MyISAM tables?
- Question #19
Which of the following actions are performed during an RPM installation of the MySQL server package?
- Question #20
When installing a RPM based distribution, the data directory will be set to which of the following locations?
- Question #21
Which of the following list the difference between mysqld, mysqld_safe and mysql.server respectively?
- Question #22
Which of the following commands can be used to stop a MySQL server on a UNIX system?
- Question #23
On a Unix host with the host name "sakila", where will mysqld write errors to?
- Question #24
When starting the mysqld program, which of the following statements are true?
- Question #25
Which types of startup options can be configured for the server?
- Question #26
When specifying options, which of the following are valid advantages of using options files over parameters on a command line?
- Question #27
Which of the following statements are true for MyISAM tables?
- Question #28
Suppose your are adding rows to a MyISAM table and the server runs out of disk space. What will happen?
- Question #29
When working with MyISAM tables, which of the following statements are true regarding deadlocks?
- Question #30
Which of the following are characteristics of the MyISAM fixed-row storage format as compared to the dynamic row format?
- Question #31
Which of the following statements are true for the MERGE storage engine?
- Question #32
When will you be able to copy InnoDB table space files to other systems and use the data there?
- Question #33
Which of the following statements are true regarding the InnoDB storage engine?
- Question #34
When working with InnoDB, for which of the following reasons should you use the FOR UPDATE locking modifier?
- Question #35
Which of the following correctly defines dirty reads, non-repeatable reads and phantom row?
- Question #36
When working with the InnoDB engine, which of the following correctly defines the READ UNCOMMITTED isolation level?
- Question #37
When working with the InnoDB storage engine, which of the following correctly defines the READ COMMITTED isolation level?
- Question #38
Isolation levels can be set...
- Question #39
Which of the following are effects of defining foreign keys in InnoDB tables without specifying either ON UPDATE or ON DELETE?
- Question #40
Which of the following statements are true for tables using the FEDERATED storage engine?
- Question #41
Besides specifying the column names and data types, which connection parameters may be defined when defining a FEDERATED table?
- Question #42
Which of the following are some general capabilites of the mysql client program?
- Question #43
which of the following are some general capabilities of the mysqladmin client program?
- Question #44
Which of the following are some general properties of the mysqlimport client program?
- Question #45
Which of the following is/are properties of the mysqldump client program?
- Question #46
Which of the following correctly defines the general difference between a read lock and a write lock?
- Question #47
Which of the following correctly describes the differences between explicitly and implicitly set locks?
- Question #48
What are some properties of using LOCK TABLE?
- Question #49
Which of the following describes how READ LOCAL locking works?
- Question #50
Which of the following statements are true regarding table locks?