Oracle MySQL 5 Database Administrator Certified Professional Set 4

1.

Which of the following statements are true regarding table locks?

They can only be released by the client holding them. They can be released by other connections than the client holding them. They are implicitly released when the connection is closed. They are not released when the connection is closed

2.

The CHECK TABLE command should be used...

To make sure a table has no structural problems. To find out why a query takes a long time to execute on a given table. To make sure that no table data are corrupted. to improve performance by updating index distribution statistics on InnoDB tables. To repair table structure problems.

3.

The REPAIR TABLE command should be used...

To improve performance by updating index distribution statistics. After multiple modifications to a tables data. To correct problems with a MyISAM table that have become corrupted. To check a tables structure to see if it may have been damaged and needs repair.

4.

The ANALYZE TABLE command should be used...

When you need to find out why a query is taking a long time to execute. To improve performance by updating index distribution statistics. After large amounts of table data have changed. To check a tables structure to see if it may have been damaged and needs repair.

5.

The OPTIMIZE TABLE command should be used...

To increase performance by defragmenting the table. To improve performance by sorting indexes. To improve performance by updating index statistics. To correct problems with a MyISAM table that have become corrupted. To check a tables structure to see if it may have been damaged and needs repair.

6.

The myisamchk command-line program must not be run on a set of tables if...

The server is running. The server might access the same table files. The server might access any tables in the same database.

7.

The CHECK TABLE command...

Will cause an error when used on MyISAM tables Will cause an error when used on InnoDB tables Will ignore MyISAM tables Will ignore InnoDB tables May be used to check both InnoDB and MyISAM tables

8.

Which of the following steps should be taken to restore an InnoDB table to a consistent state without having to shutdown the server?

Run the REPAIR TABLE command. Dump the table with mysqldump, drop the table then re-create from the dump file. Run the CHECK TABLE command. Dump the table with mysqlhotcopy, drop the table then re-create with the backup file.

9.

After a server crash, some InnoDB tables need to be repaired. However, when the server is restarted, auto- recover failed. How would you repair the InnoDB tables?

Restart the server with the --innodb_force_recovery option. Execute the REPAIR TABLE command. Execute the OPTIMIZE TABLE command.

10.

Suppose you have a server that has been started with the --myisam-recover option. When does the server perform the check on the MyISAM tables?

Each time the server is started. Each time it encounters an error. Each time it opens the MyISAM table files. Each time the CHECK TABLE command is issued.

Oracle MySQL 5 Database Administrator Certified Professional Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle MySQL 5 Database Administrator Certified Professional Set 4

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner