MySQL Practice Test 2

1. Will the following SQL command produce any error?

INSERT INTO person
(person_id, fname,lname)
VALUES (1,’S’,’U’),
VALUES (2,’T’,’U’);
/* where person_id is a primary key */

2. What cannot be done on a view?

3. Which clause is used to remove a foreign key constraint?

4. Which clause names the parent table and the index columns in the table?

5. What is abc in the following MySQL statement?

	SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

6. Which keyword used with UNION does not retain duplicate rows?

7. Which command is used to show all tables that are stored in a database?

8. The property of InnoDB that enforces foreign key relationships stay intact is called _____________

9. What does 'C' stand for in the ACID property of transactions?

10. Which command is used in Mysql command line tool to return to window command shell?