MYSQL MySQL 5.0 Database Administrator Certified Professional Exam, Part I - 1Z0-873무료 덤프문제 풀어보기

A. It allows a transaction to only see its uncommitted changes.

B. It allows a transaction to see committed changes made by other transactions.

C. It allows a transaction to see both committed/uncommitted changes made by other transactions.

D. It allows a transaction to see uncommitted changes made by other transactions.

A. Implicitly set locks may span several commands.

B. Explicitly set locks will span only one statement or transaction.

C. Explicitly set locks may span several commands.

D. Implicitly set locks will span only one statement or transaction.

A. --end-position will read the binlog entries up to the specified position

B. --start-file will read the binlog entries starting with the specified filename

C. --end-datetime will read the binlog entries up to the specified date and time

D. --start-datetime will read the binlog entries starting at the specified date and time

E. --start-position will read the binlog entries starting at the specified position

F. --end-file will read the binlog entries ending after the specified filename

A. Autocommit mode is suspended until COMMIT.

B. Nothing happens as they are not valid commands.

C. Autocommit mode is suspended and has to be re-enabled explicitly.

D. Autocommit mode overrides BEGIN TRANSACTION and START TRANSACTION.

A. The replication world file

B. The world db file

C. The master.info file

D. None of the above

E. The relay index

F. Any relay logs

A. InnoDB tables cannot be recovered after a crash, you have to restore data from backup.

B. MyISAM tables will be automatically recovered after a crash.

C. MyISAM tables cannot be recovered after a crash, you have to restore data from backup.

D. MyISAM tables will be recovered after a crash if the myisam-recover option is configured.

E. InnoDB tables will be automatically recovered after a crash.

F. InnoDB tables will be recovered after a crash if the innodb-recover option is configured.

A. The information returned from the INFORMATION_SCHEMA can be stored in other tables.

B. INFORMATION_SCHEMA is a feature of standard SQL, and SHOW is a MySQL specific command.

C. Using the INFORMATION_SCHEMA can provide more concise information.

D. It is faster than using SHOW commands.

E. You always use SELECT to retrieve any of the metadata.

A. Both machines must use the same operating system.

B. Database and table names must use lowercase format.

C. Both machines must use IEEE floating-point format or contain no floating-point columns.

D. Both machines must use two's-complement integer arithmetic.

A. You can use both of the above statements, i.e. process the files either in a group or separately. All inter-file dependencies will be taken care of with both methods.

B. shell> mysqlbinlog bin.00010 | mysqlshell> mysqlbinlog bin.00011 | mysqlshell> mysqlbinlog bin.00012 |mysql

C. shell> mysqlbinlog bin.00010 bin.00011 bin.00012 | mysql

A. basedir.cnf

B. basedir.ini

C. my.cnf

D. config.ini

E. my.ini

F. config.cnf