Q1. 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 --- ssl level was not specified.
B. The server was not started with the – enable--ssl-plugin option.
C. -- ssl is not a valid server option.
D. The mysqld binary was not compiled with SSL support.
E. The server’s SSL certificate was invalid.
Answer: B
Q2. Which three data components are needed for point-in-time recovery?
A. The error log
B. The backup log
C. The general query log
D. Binary logs
E. The data backup
F. Configuration files
Answer: D,E,F
Q3. What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?
A. Mysql Enterprise Backup
B. Mysqldump with – binary-data option
C. Mysqlhotcopy
D. File system snapshots
E. Mysqldumpslow
Answer: A,B
Reference: http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html
Q4. 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 system can only support one snapshot per volume, and you need to remove it to be able to take your next backup.
B. The snapshot size will continue to grow as changes to the volume are made.
C. The snapshots take a significant amount of disk space as they are a duplicate copy of the data.
D. The system keeps a copy of changes in memory and can cause an out of memory event.
Answer: C
Q5. Which three statements are characteristic of the MEMORY storage engine?
A. Each table is represented on disk as an.frm file.
B. Each table has a corresponding.MYI and .MYD file.
C. It can support foreign keys.
D. It cannot contain text or BLOB columns.
E. Table contents are not saved if the server is restarted.
F. It can support transactions
Answer: A,D,E
Q6. You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.
Some details are as follows: . The Mysql instance has 400 databases. . Each database on an average consists of 25-50 tables.
You use the query:
SELECT TABLE_SCHEMA,
‘ENGINE’,
COUNT (*),
SUM (data_length) total_size
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = ‘BASE TABLE’
GROUP BY TABLE_SCHEMA, ‘ENGINE’
;
Why is this query slow to execute?
A. Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming.
B. Collecting information requires various disk-level operations and is time consuming.
C. Aggregating details from various storage engine caches for the final output is time consuming.
D. Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tables.
Answer: B
Q7. Consider the following statement on a RANGE partitioned table:
ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?
A. Only the first partition (p1) will be dropped as only one can be dropped at any time.
B. All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
C. A syntax error will result as you cannot specify more than one partition in the same statement.
D. All data in pi and p3 partitions are removed and the table definition is changed.
Answer: B
Reference: http://docs.oracle.com/cd/F49540_01/DOC/server.815/a67772/partiti.htm
Q8. What is true regarding InnoDB locking?
A. InnoDB row locks may be escalated to page or table-level locks.
B. InnoDB only uses row locks, not page or table-level locks,
C. InnoDB uses row and table-level locks, but row locks are not escalates,
D. InnoDB locks only those rows that are updated.
E. InnoDB uses row-level or table-level locks depending on the number of rows affected.
Answer: E
Reference: http://dev.mysql.com/doc/refman/5.0/en/table-locking.html
Q9. 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. __login-path can be used only for MySQL servers running on a local machine.
C. __login-path allows you to provide login credentials without passing clear text passwords on the command line.
D. When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later.
Answer: D
Q10. Which MySQL utility program should you to process and sort the slow Query log based on query time or average query time?
A. Mysqlslow
B. Mysqldumpslow
C. Mysqlshow
D. Mysqldump
E. Mysqlaccess
Answer: B
Reference: http://dev.mysql.com/doc/refman/5.0/en/mysqldumpslow.html