Quiz 1Z0-871

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

Which of the following statements are true?

Which of the following CREATE statements are the correct way of specifying the table?

Which of the following statements accurately describes the difference between HASH and BTREE indexes used for MEMORY tables?

What changes (if any) should be made to the table?

Which of the following CREATE TABLE statements will succeed?

What is the benefit of creating an index on a table?

INSERT INTO numbers VALUES (NULL)

Which of the following will CREATE a table with exactly one multi-column index?

What is missing? CREATE TABLE t1 ______ world

Which of the following statements will add two columns of INT type to the `country` table?