MySQL Practice Test 4

1. Which procedure parameter enables the caller to pass in a value and get back a value?

2. What is def in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

3. The optimizer_prune_level is set by default.

4. In a single table (with 10 columns) join query the number of values needed to examine per column is __________

5. The IN, OUT and INOUT keywords do not apply to stored functions.

6. To minimize disk I/O, which of these should be chosen?

CHAR, VARCHAR

7. When a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access, the security context is __________

8. Reading from a table does not change it.

9. Which of these has higher priority?

writes, reads

10. Which statement is used to verify optimizer operation?