MySQL 5.6 Developer: 1Z0-882

A floating- point column defined as FLOAT(7,5)allows___________

A. 7 digits to the left of the decimal point and 5 digits to the right

B. 5 digits to the left of the decimal point and 7 digits to the right

C. 7 digits in total, of which 5 are to the right of the decimal point

D. 7 digits in total, of which 5 are to the left of the decimal point

Which three are valid identifiers for the user table in the mysq1 database?

A. myssq1. user

B. `mysq1. user'

C. `mysq1'. `user'

D. Mysq1. `user'

E. `'mysq1. User''

Consider the CREATE FUNCTION statement:

CREATE FUNCTION countrycount ()

BEGIN

DECLARE count INT;

SELECT COUNT (*) INTO count FROM country;

RETURN count ;

END

What is the outcome when you try to create the function?

A. An error results as the SELECT must assign the return values to a user variable.

B. An error results as the count variable is not initialized with a value.

C. An error result as the function must be defined with the CONTAINS SQL clause.

D. An error result as the variable type returned by the function must be defined with a RETURNS clause.