MySQL Practice Test 2

1. Which keyword in the UPDATE statement is used to assign values to columns?

2. Which of these operators does not perform relative-value comparisons?

3. Which keyword is used to specify the foreign key after the table is created?

4. Which among the following are the correct definitions for “NULL” in Mysql?

5. Which keyword is used to delete all the rows from the table?

6. In the following MySQL command how many rows will be deleted?

DELETE person
WHERE person_id<10;
/*person_id is a primary key */

7. Which Clause is used to sort the stored data in alphabetical order?

8. Which authentications are required for login into Mysql command line tool?

9. The following SQL statement is invalid.

SELECT abc, xyz FROM table1 UNION abc, def FROM table2;

10. Foreign keys cannot handle deletes and updates.