Oracle 1z0-883 問題集

質問 1：
Which three data components are needed for point-in-time recovery?
A. The error log
B. The data backup
C. Binary logs
D. The backup log
E. Configuration files
F. The general query log
正解：B,C,E

質問 2：
Which three statements are characteristic of the MEMORY storage engine?
A. It can support transactions
B. It can support foreign keys.
C. Table contents are not saved if the server is restarted.
D. It cannot contain text or BLOB columns.
E. Each table has a corresponding.MYI and .MYD file.
F. Each table is represented on disk as an.frm file.
正解：C,D,F

質問 3：
Consider the MySQL Enterprise Audit plugin,
You add the following lines to the my.cnf configuration tile:
[mysqld]
Plugin-load=audit_log.so
Audit-log=FORCE_PLUS_PERMANENT
You attempt to start up the MySQL service and notice that it fails to start.
Which two statements would explain why the service did not start?
A. The audit_log.so library is not an executable file.
B. The audit_log.so library is in a location that is different from that defined by the plugin_dir option.
C. FORCE_PLUS_PERMANENT is not valid for the audit-log option.
D. The audit plugin must be loaded dynamically by using the INSTALL PLUGIN command.
E. The audit log file does not exist in which to write audit events.
F. The audit_log.so library does not exist.
正解：B,F
解説: (Topexam メンバーにのみ表示されます)

質問 4：
A general purpose MySQL instance is configured with the following options:
-- log-slow-queries -- long-query-time=,0001 -- log-slow-admin-queries -- general-log -- log-bin -- binlog-format=STATEMENT -- innodb-flush-log-at-trx-commit=1
Which three statements are true?
A. The Slow Query Log records more data than the General Query Log.
B. The binary Log records more data than the General Query Log.
C. The Slow Query Log records more data than the Binary Log.
D. The General Query Log records more data than the Slow Query Log.
E. The Binary Log records more data than the Slow Query Log.
F. The General Query Log records more data than the Binary Log.
正解：C,D,F

質問 5：
You attempt to connect to a Mysql Server by using the mysql program. However, you receive the following notice:
ERROR 2059 (HY000): Authentication plugin 'mysql_clear_password' connot be loaded: plugin not enabled
What would you run to fix the issue?
A. The mysql_upgrade script
B. The mysql client with the - enable-cleartext-plugin option
C. The mysql_secure_installation script to update server security settings
D. The install plugin command for the mysql_cleartext_password plugin
E. The mysql client with the - ignore-password-hashing option
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
The 'allplicationdb' is using innoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather the following information:
[mysqld] Datadir=/var/lib/mysql/ Innodb_file_per_table=0
Three tables are stored in the innoDB shared tablespace and the details are as follows: -The table data_current has 1,000,000 rows.
-The table data_reports has 1,500,000 rows. -The table data_archive has 4,500,000 rows. Shell> is -1 /var/lib/mysql/ -rw-rw---- 1 mysql mysql 744G Aug 26 14:34 ibdata1 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile0 -rw-rw---- 1 mysql mysql 480M Aug 26 14:34 ib_logfile1 ...
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storting it on your backup partition.
Shell> mysqldump - u root - p applicationdb data_archive > /backup/data_archive.sql
Mysql> DROP TABLE data_archive;
Which set of actions will allow you to free disk space back to the file system?
A. Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the
file system:
Mysql> OPTIMIZE TABLE data_current, data_reports;
B. Take a backup, stop the server, remove the data files, and restore the backup:
Shell> mysqldump - u root -p applicationdb / > /backup/applicationdb.sql
Shell> /etc/init.d/mysql stop
Shell> cd /var/lib/mysql/
Shell> rm ibdata1 ib_logfile0 ib_logfile1
Shell> /etc/init.d/mysql start
Shell> mysql - u root - p applicationdb < /backup/applicationdb.sql
C. Set the server to use its own tablespace, and then alter the table so that data is moved from the
shared tablespace to its own:
Mysql> SET GLOBAL innodb_file_per_table=1;
Mysql> ALTER TABLE data_current ENGINE=InnoDB;
Mysql> ALTER TABLE data_repors ENGINE=InnoDB;
D. Enable compression on the table, causing InnoDB to release unused pages on disk to the file
system:
Mysql> SET GLOBLE innodb_file_per_table=1;
Mysql> SET GLOBLE innodb_file_format=Barramcuda;
Mysql> ALTER TABLE data_current ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
Mysql> ALTER TABLE data_history ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
正解：B

質問 7：
Your developers have created table to store some of their program's data. After examining the slow Query Log, you see that they are using the LIKE operator and SUBSTER () functions against a VARCHAR (10000) column quite often.
An example of the start of one row of data:
'GREEN01020495888331993-12-10/2...'
What should you do to improve the overall performance?
A. Convert the column to TEXT and add a fulltext index to the table.
B. Convert their column to BINARY.
C. Redesign the table so that the most commonly searched for string patterns are in their own columns.
D. Create multiple prefix indexes of differing lengths.
正解：A

質問 8：
Which two are true regarding MySQL binary and text backups?
A. Binary backups are usually slower than text backups.
B. Binary backups are usually faster than text backups.
C. Text backups are human-readable while binary backups are not.
D. Binary backups are not portable across different operating systems.
正解：C,D

質問 9：
Assume that you want to know which Mysql Server options were set to custom values.
Which two methods would you use to find out?
A. Check the output of SHOW GLOBAL VARIABLES and compare it with default values.
B. Check the configuration files in the order in which they are read by the Mysql Server and compare them with default values.
C. Check the command-line options provided for the Mysql Server and compare them with default values.
D. Query the INFORMATION_SCHEMA.GLOBAL_VARIABLES table and compare the result with default values.
正解：A,D