Oracle-MySQL 5 Developer Certified Professional Exam, Part II Set 1

Warning/Error Count. ✘ Warning/Error Codes. ✘ Warning/Error messages. ✘

SHOW WARNINGS LIMIT SHOW WARNINGS LIMIT limit can not be used with show warnings

An error would be returned, as this is not valid syntax. ✘ The number of current warnings would be returned. ✘ The total number of warnings server-wide would be returned ✘

When it is not able to completely fulfill a request. When a system-level error occurs. When an action has possible unintended side-effects.

The MylSAM storage engine should be preferred when you expect many reads and few updates to occur The MylSAM storage engine should be preferred when you expect a mix of many reads and many updatesto occur The InnoDB storage engine should be preferred when you expect many reads and few updates to occur The InnoDB storage engine should be preferred when you expect a mix of many reads and many updatesto occur

Rewrite queries to use indexes Use EXPLAIN Use ORDER BY

Fixed-length are slower, but require less disk space, as variable-length are faster, but require more disk space. ✘ Fixed-length are faster and require less disk space, as variable-length are slower and require more diskspace. ✘ Fixed-length are faster, but require more disk space, as variable-length are slower, but require less diskspace. ✘ Fixed-length are slower and require more disk space, as variable-length are faster and require less diskspace. ✔

A Column prefix allows for a shorter index, making it read less from disk, ✘ A Column prefix allows for a shorter index name, making less code to be written. ✘ A Column prefix is another name for a left-most prefix, which is usefully with multi-column indexes. ✘

The amount of time to write a query The number of results returned The amount of disk I/O needed The amount of disk space needed

the row may be used exclusively to return the data ✘ the index may be used exclusively to return the data ✘ both the row and the index are always used to return the data ✘