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 two PHP modules provide APIs for developing MYSQL applications?

A. Mysqli

B. Mysqlnd

C. PDO

D. PDO_mysql

You create a new,empty database called `test'. You want to change the database `s CHARACTER SET to "latin1" and the database `sCOLLATION to `latin_german_ci'.

Which statement is true?

A. You can do this one command: ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_german_ci

B. You can only do this with two separate commands: ALTER DATABASE `test' CHARACTER SET latin1 ALTER DATABASE `test' COLLATE latin_german1_ci

C. You cannot change the CHARACTER set or COLLATION value on an existing database.

D. Databases do not have CHARACTER SET or COLLATION attributes.

Consider the content of the class and student tables: Class

Which three queries produce the same result?

A. SELECT * FROM class INNER JOIN student ON class.class_id=student.class_id

B. SELECT * FROM JOIN student LEFT JOIN student ON class. Class.class_id=student.class_id

C. SELECT * FROM class INNER JOIN student WHERE NOT ISNULL (student.class_id)

D. SELECT * FROM JOIN student On class .class_id=student.class_id WHERE NOT ISNULL (student.class_id)

E. SELECT * FROM student RIGHT JOIN class ON class.class_id=student.class_id

A MySQL command- line client is started with safe updates disabled. Mysql - -safe updates=0

What happens when you execute an UPDATE statement without a WHERE clause?

A. Results in an error

B. Updates every row in the specified table(s)

C. Results in - -safe-updates being enabled automatically

D. Causes a syntax error