|Prova||MySQL 5 Certified Associate Exam|
|Número de questões||50|
|Nota de aprovação||60%|
|Treinamento oficial recomendado||MySQL for Beginners (SQL-4401)|
Tópicos do exame
|Section 1: Theory, Terminology and Concepts (10%)|
|Database and Database Objects|
|Section 2: Data Definition using SQL (25%)|
|Constraints and Indexes|
|Section 3: Basic Data Manipulation using SQL (25%)|
|Recurring SQL Constructs|
|Section 4: Advanced Data Manipulation using SQL (20%)|
|Grouping and Aggregate Functions|
|Section 5: Transactions (10%)|
|SQL for working with Transaction|
|Section 6: Import/Export (10%)|
|Tools for Import/Export|
|SQL for Import/Export|
|1. Which of the following terms is described in the statement below?:“It is procedural code that is automatically executed in response to certain events on a particular table or view in a database.”
2. Fill in the blank with the appropriate word:
The ________data type defines a date that is combined with a time of day along with fractional seconds that is based on a 24-hour clock.
3. Which of the following are true about UPDATE statements??
Each correct answer represents a complete solution. Choose all that apply.