Study tips 1Z0-871

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

You have issued the statement: CREATE TABLE numbers (number INT NOT NULL) ENGINE=MYISAM What is the result of issuing the following statement: INSERT INTO numbers VALUES (NULL)

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

Which of the following CREATE TABLE statements will succeed?

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

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

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

Which of the following statements are true?

Which of the following statements can be used to change the name of the column name into firstname?

Which of the following MySQL client programs require a connection to a MySQL server in order to work on database contents?