Oracle 1z0-883 問題集

質問 1：
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

質問 2：
Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data.
This requires the following config file options:
Sync_binlog=1 Innodb_flush_log_at_trx_commit=1
Innodb_doublewrite=1
However, this configuration is expected to introduce disk I/O overhead.
What three changes will reduce disk I/O overheads?
A. Placement of InnoDB log files and datadir on separate physical disks
B. Use of soft links for database directories on the same physical disk
C. Allocation of RAM to the buffer pool such that more of the data can fit in RAM
D. Use of delay_key_write=ON for batch index update
E. Use of separate directories on the same physical disk for log files and data files
正解：A,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?
A. The server was not started with the - enable--ssl-plugin option.
B. The server's SSL certificate was invalid.
C. The --- ssl level was not specified.
D. -- ssl is not a valid server option.
E. The mysqld binary was not compiled with SSL support.
正解：E

質問 4：
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 メンバーにのみ表示されます)

質問 5：
In a design situation, there are multiple character sets that can properly encode your data.
Which three should influence your choice of character set?
A. Disk usage when storing data
B. Syntax when writing queries involving JOINS
C. Character set mapping index hash size
D. Memory usage when working with the data
E. Comparing the encoded data with similar columns on other tables
正解：C,D,E

質問 6：
You use-login-path to access a MySQL server on a Linux installation.
Which statement is true about the - login-path option that is created by using mysql_config_editor?
A. All system users have access to the MySQL server via-login path local.
B. When using - login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later.
C. __login-path allows you to provide login credentials without passing clear text passwords on the command line.
D. __login-path can be used only for MySQL servers running on a local machine.
正解：C

質問 7：
You have taken a Logical Volume Manager (LVM) snapshot backup of a volume that contains the MySQL data directory.
Why is it important to remove snapshots after completing a RAW backup in this way?
A. The snapshot size will continue to grow as changes to the volume are made.
B. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.
C. The system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.
D. The system keeps a copy of changes in memory and can cause an out of memory event.
正解：B

質問 8：
You have been notified that the 'apps' . 'reports' table has been accidentally truncated.
You have single file mysqldump backup available taken prior to the truncate. The backup contains all the tables from the instance, and the 'apps' . 'reports' table must be restored without affecting the other remaining databases and tables.
Which restore option is suitable in this scenario?
A. Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table.
B. Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'
C. Restore the backup to another databases instance and obtain a copy of the reports table individually.
D. Extract the 'apps' . 'reports' table from the backup using the SOURCE command.
正解：C

質問 9：
Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?
A. MySQL Replication
B. Distributed Replication Block Device
C. Windows Server Failover Clustering
D. MySQL Cluster
正解：A