1z0-883 Exam Training Practice Tests (Oracle MySQL 5.6 Database Administrator)]

Question 1

Which two are correct steps in taking a binary backup of MyISAM tables?

A. Make a copy of the .frm, .myd, and the .myi files. B. Always stop the server prior to the backup. C. Stop the server or lock the tables prior to the backup. D. Stop the server or lock the databases prior to the backup. E. Make a copy of the binary log and tablespace files.

Correct Answer: A,C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

You examine the output of SHOW GLOBAL STATUS and notice that the value of Created_tmp_disk_tables is consistently increasing.
Which two variables would likely fix this issue?

A. Max_heap_table_size B. Table_open_cache_instancs C. Tmp_table_size D. Table_open_cache E. Max_tmp_tables F. Table_definition_cache

Correct Answer: A,C

Question 3

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. Extract the 'apps' . 'reports' table from the backup using the SOURCE command. B. Execute mysqldump on the backup,sql file and apply - filter arguments to obtain only the 'apps' . 'reportys' table. C. Restore the backup to another databases instance and obtain a copy of the reports table individually. D. Execute LOAD DATA INFILE 'backup.sql' SCHEMA='apps' TABLE= 'reports'

Correct Answer: C

Question 4

While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.
Which method will reduce the number of file handles in use?

A. Implementing storage engine data compression options B. Relocating your data and log files to separate storage devices C. Activating the MySQL Enterprise thread pool plugin D. Disconnecting idle localhost client sessions

Correct Answer: D

Question 5

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.

Correct Answer: B

Question 6

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.
Which two conditions must be true?

A. The master database cannot have more columns than the slave. Only the slave deatbase can have more columns. B. The slave database cannot have more columns than the master. Only the master database can have more columns. C. Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server. D. Columns that are common to both versions of the table must be defined in the same order on the master and the slave. E. Each extra column in the copy with more columns must not have a default value.

Correct Answer: C,D

Question 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. Create multiple prefix indexes of differing lengths. D. Redesign the table so that the most commonly searched for string patterns are in their own columns.

Correct Answer: A

Question 8

What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?

A. Mysqldump with - binary-data option B. Mysqlhotcopy C. Mysqldumpslow D. File system snapshots E. Mysql Enterprise Backup

Correct Answer: A,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 9

Mysqldump was used to create a single schema backup;
Shell> mysqldump -u root -p sakila > sakila2013.sql
Which two commands will restore the sakila database without interfering with other running database?

A. Shell> mysqlimport -u root -p sakila sakila2013.sql B. Shell> mysql -u root -p -e 'use sakila; source sakila2013.sql' C. Shell> mysql -u root -p -silent < sakila2013.sql D. Shell> mysql -u root -p sakila <sakila2013.sql E. Mysql> USE sakila; LOAD DATA INFILE 'sakila2013.sql';

Correct Answer: B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 10

The InnoDB engine has a feature known as clustered indexes.
Which three statements are true about clustered indexes as used in InnoDB?

A. A clustered index allows fulltext searching within InnoDB, B. If no indexes exist, a hidden clustered index is generated based on row IDs. C. A clustered index is a grouping of indexes from different tables into a global index for faster searching. D. A primary key is used as a clustered index. E. A clustered index provides direct access to a page containing row data. F. A primary key must exist for creation of a clustered index. G. The first unique index is always used as a clustered index and not a primary key.

Correct Answer: A,B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Oracle MySQL 5.6 Database Administrator - 1z0-883 Exam Practice Test