Quiz 1Z0-871

Quiz 1Z0-871, MySQL 5 Developer Certified Professional , Part I

A column defined as DECIMAL, with no parameters, is equivalent to which of the below?

Is the following statement true or false?

Is the following a valid CREATE statement?

Is the following statement true or false? "Math involving DOUBLE and FLOAT columns is always accurate because MySQL 5 supports precision mathematics

Is the following statement true or false? "VARCHAR columns usually require less storage space than CHAR columns

Is the following statement true or false? "A 24-bit column can be specified with BIT(24) in a CREATE statement

Is the following statement true or false? "Fields with the DECIMAL column type are always stored more efficiently than those with type FLOAT

Which statement(s) from following list are true for BINARY and VARBINARY data types?

Ignoring any errors or warnings that may be issued, which values are now in the table?

Which of the quoted values below will be returned for the name field in the SELECT results?