The MySQL user `adam' currently has USAGE permissions to the database.
The football database is transactional and has non-stop updates from application users. The `adam' user needs to be able to take consistent backups of the football database by using the -single-option.
transaction
Which extra GRANT permissions are required for adam to take mysqldump backups?

• A.The `adam' user needs the PROCESS privilege to be able to take a consistent backup while other users are connected.
• B.The `adam' user must also have SINGLE TRANSACTION global grant to take a consistent backup.
• C.The `adam' user must also have SELECT on the football database for backups to work.
• D.The `adam' user must have the SUPER privilege in order to take data backups.

Comment: *

Name: *

Email: *

Verification: *

When you examine a new MySQL installation with default configuration, you find a file called ibdata1 in the database directory. Which two statements are true about this file? (Choose two.)

• A.it contains the undo log.
• B.it contains the binary log.
• C.it contains the redo log.
• D.it contains a general tablespace.
• E.it is the default location for all new tables that you create.
• F.it contains the system tablespace.

Comment: *

Name: *

Email: *

Verification: *

Consider the index information for the dept_emptable in the employee's schema:

Which two conclusions can be made based on the output of the query? (Choose two.)

• A.The selectivity of the dept_nocolumn is the best of the indexed columns.
• B.The secondary indexes are optimized for unique key look-ups.
• C.There are three indexes on the table.
• D.The values on the emp_nocolumn must be unique.
• E.There is a redundant index on the emp_nocolumn.
• F.There is a redundant index on the dept_nocolumn.

Comment: *

Name: *

Email: *

Verification: *

What does the possible_keyscolumn in this output denote?

• A.if there are any indexes that may be used to solve this query
• B.if it is possible for you to include any indexes in your query
• C.whether you are using any indexes in your query
• D.whether there are any indexes on the tables that you are querying

Comment: *

Name: *

Email: *

Verification: *

Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)

• A.to find out why a query takes a long time to execute on a given table
• B.to make sure a table has no structural problems
• C.to improve performance by updating index distributing statistics on InnoDB tables
• D.to repair table structure problem
• E.to make sure that no table indexes are corrupted

Comment: *

Name: *

Email: *

Verification: *