1. | To check if the data directory contains insecure files or directories, the command executed is _____________ |
Answer: (c).ls -la
|
2. | What enables the read and execute access to all users outside of mysql group. |
Answer: (a).drwxrwxr-x
|
3. | The server uses a Unix domain socket file for connections by clients to localhost. |
Answer: (a).True
|
4. | Which program is used as a utility for MyISAM table maintenance? |
Answer: (c).myisamchk
|
5. | What does the AUTO_INCREMENT sequences normally begin at? |
Answer: (b).1
|
6. | How can the value of recently generated sequence number be obtained? |
Answer: (a).LAST_INSERT_ID()
|
7. | What does LAST_INSERT_ID() return when no AUTO_INCREMENT value has been generated during the current connection? |
Answer: (b).0
|
8. | Triggers are not supported for _____________ |
Answer: (d).views
|
9. | Triggers and events are not invoked automatically by the server. |
Answer: (b).False
|
10. | How is a stored procedure invoked? |
Answer: (c).CALL
|