1. | Which of these return a result to the client? |
Answer: (a).Stored functions
|
2. | Which of these is defined to execute when the table is modified only? |
Answer: (c).Triggers
|
3. | What executes on a time activated basis according to a schedule? |
Answer: (b).Events
|
4. | Stored programs improve database security. |
Answer: (a).True
|
5. | Which character does the mysql client program recognize as a statement delimiter? |
Answer: (c).;
|
6. | Which command is used to redefined the mysql delimiter? |
Answer: (c).delimiter
|
7. | Which of the following characters cannot be used as a delimiter? |
Answer: (d).\
|
8. | Stored routines refers to stored functions and procedures. |
Answer: (a).True
|
9. | Stored programs refer to stored objects of how many of the following types?
functions, procedures, triggers, events |
Answer: (d).4
|
10. | Which of the following statements does not modify the table? |
Answer: (d).SELECT
|