MYSQL 1Z0-873 問題集

質問 1：
Complete the following sentence.
The INFORMATION_SCHEMA.SCHEMATA table contains information about ...
A. ... all of the tables, triggers and views for every database.
B. ... the table structure for all databases.
C. ... every database's structure including tables, triggers, stored routines, views, etc.
D. ... all of the databases on the server, such as name, character set and collation.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
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?
A. mysql> LOCK TABLES A;mysql> LOCK TABLES B;mysql> LOCK TABLES C;
B. mysql> LOCK TABLES A READ, B WRITE, C READ;
C. mysql> LOCK TABLES A READ;mysql> LOCK TABLES B WRITE;mysql> LOCK TABLES C READ;
D. LOCK TABLES A, B, C READ, WRITE, READ;
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
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?
A. The mysql_restore utility should be used to update the server to its last known state.
B. The procedure described is wrong; instead, the mysqlcheck utility should be used and only if that fails should backup copies be restored.
C. Once the backup files from 03:00 have been restored, there is nothing more that can be done to restore the database files.
D. The binary logs recorded after the backup at 03:00 should be re-applied to make the database file consistent with the state just before the crash.
正解：D

質問 4：
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?
A. Execute the OPTIMIZE TABLE command.
B. Restart the server with the --innodb_force_recovery option.
C. Execute the REPAIR TABLE command.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
In order to use SELECT INTO OUTFILE backups, the output file
A. need not be created afresh; can be viewed by the world; and will reside on the server
B. must be created afresh; can be viewed by the world; and will reside on the server
C. must be created afresh; can not be viewed by the world; and will reside on the client or the server
D. need not be created afresh; can not be viewed by the world; and will reside on the server
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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 installation that contains many more character sets, which of the following statements is/are true?
A. The compiled version will use less memory, because only a few character sets will be loaded by the server.
B. The compiled version will use less disk space, because only a few character sets will be installed on disk.
C. The compiled version will use less file handles, because only a few files need to be opened when the server is started.
正解：A,B
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which of the following are true with regards to the server SQL mode?
A. The server SQL mode determines how the server should behave when performing data validation checks and interpreting different forms of syntax.
B. The server SQL mode determines whether the server should be read-only or accept commands such as INSERT, UPDATE, etc.
C. The default SQL mode can be set by adding a mode="" to the [mysqld] section of a server option file.
D. The SQL mode can be changed at the session level with a SET SESSION sql_mode="" command.
正解：A,D
解説: (Topexam メンバーにのみ表示されます)