最新的MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I - 1Z0-873免費考試真題

A. Each time the server is started.

B. Each time it encounters an error.

C. Each time the CHECK TABLE command is issued.

D. Each time it opens the MyISAM table files.

A. Per session

B. Per user name

C. Globally

D. Per transaction

A. The MySQL server should be set to run as it's own user, not as an administrative account.

B. The server should be started with the mysqld_secure script.

C. All initial accounts should have passwords set and unused accounts should be removed.

D. The data directory and it's contents should be strictly accessible only to the user MySQL runs as.

A. The total minimum size of the InnoDB data files is 100MB

B. The total maximum size of the InnoDB data files is 100MB

C. The data files will be stored below the default data directory

D. There are two InnoDB data files

E. The initial size of the InnoDB data files on server startup will be set to 50MB. If more space is needed, another 50MB will be allocated.

F. There are three InnoDB data files

A. The slow log records the text of all queries that exceed the long_query_time variable.

B. The slow log records the timestamps of when the server is performing slowly and when it is low on resources.

C. The slow log is enabled with the --log-slow or --log-slow=file_name option.

D. The slow log is enabled with the --log-slow-queries or --log-slow-queries=file_name option.

A. You intend to execute an UPDATE statement on any row.

B. You intend to run more than ten UPDATE statements in one transaction.

C. You intend to SELECT a set of rows, then modify those rows.

A. May be used to check both InnoDB and MyISAM tables

B. Will cause an error when used on InnoDB tables

C. Will ignore MyISAM tables

D. Will cause an error when used on MyISAM tables

E. Will ignore InnoDB tables

A. Startup options can only be given in option files.

B. Startup options can be given either in option files, or as parameters on the command line.

C. Startup options can be given either in option files, or as parameters on the command line, except for Windows services.

D. Startup options can only be given on the command line.

E. Startup options can only be given on the command line except for Windows Services.

A. Both the SHOW command and the INFORMATION_SCHEMA provide the same domain of information.

B. The SHOW command exceeds the domain of information that the INFORMATION_SCHEMA database can provide.

C. The INFORMATION_SCHEMA database exceeds the domain of information that the SHOW command can provide.

A. Only data

B. Only table structures

C. Both table structures and data