All of these tasks can be completed in many different ways. For instance the first mandatory task includes removing three accounts. This can be done in one or more SQL statements. The candidate is graded on IF they accomplished the task and not the method used to accomplish the task.
The Optional Tasks
- Copy a database
- Create a fulltext search
- Create a view to select certain data from a table
- Alter a table
- Update a compressed table
- Create a recurring event
- Update a global variable
- Use the INFORMATION_SCHEMA data in views to return instance information
- Import a CSV file
- Partition or repartition a table
Once again, do at least five of these optional tasks. It is suggested that a candidate do more that just in case the task is a little more complex or has a subtle twist not apparent at first site.
What the heck does that mean? For instance, one early tested created an event following the information from the help command on the mysql command line client. But it was not a recurring event, just a one time event. That was a simple mistake but costly.
Next up: Getting ready for exams at the User Conference! Yes, there are short cuts to make your testing experience EASIER at the UC.