Código: 1Z0-870

Prova MySQL 5 Certified Associate Exam
Preço US$ 125.00
Duração 90 minutos
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%)
Client/Server Concepts
Database and Database Objects
 Section 2: Data Definition using SQL (25%)
Databases
Data Types
Tables
Constraints and Indexes
Views
 Section 3: Basic Data Manipulation using SQL (25%)
Recurring SQL Constructs
Adding data
Modifying data
Removing data
Searching data
 Section 4: Advanced Data Manipulation using SQL (20%)
Expressions
Grouping and Aggregate Functions
Joining Tables
Section 5: Transactions (10%)
Transaction Concepts
SQL for working with Transaction
Section 6: Import/Export (10%)
Tools for Import/Export
SQL for Import/Export
Exemplos de questões:
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.”

A) Data type
B) Table
C) Datetime data type
D) Database trigger

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.

A) You can use the WHERE clause to have your update affects a specific set of rows.
B) You use the SET clause to update multiple columns of a table separated by commas.
C) You can use co-related sub query in UPDATE statements to update data from other tables.
D) If you don't use the WHERE clause then the UPDATE will not update any rows in the table.