Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: MySQL 010-002
Title
: Certified MySQL Associate
(English)
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. A table is successfully created by executing the following statement:
CREATE TABLE numbers (
double_number double,
decimal_number decimal(2,1)
)
One row is successfully inserted into the numbers table. At this point, the table contains the following data:
+---------------+----------------+
| double_number | decimal_number |
+---------------+----------------+
|
1.5 |
2.5 |
+---------------+----------------+
The row is updated by executing the following statement:
UPDATE numbers
SET double_number = double_number + 0.25,
decimal_number = decimal_number + 0.01
Which values are now stored in the double_number and decimal_number columns of the updated row?
Select the best response.
A. 1.8 and 2.5
B. 1.75 and 2.5
C. 1.8 and 2.51
D. 1.75 and 2.51
Answer: B
2. Which of the following statements can be used to list all databases that are accessible to the current
user?
Select the best response.
A. LIST DATABASES
B. SHOW DATABASES
C. DISPLAY DATABASES
D. VIEW DATABASES
Answer: B
3. Which of the following statements will discard the existing database called world?
Select the best response.
A. DELETE DATABASE world
B. DROP DATABASE world
C. REMOVE DATABASE world
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
D. TRUNCATE DATABASE world
Answer: B
4. Which statement can be used to list all columns in the City table?
Select the best response.
A. DISPLAY COLUMNS FROM City
B. SHOW COLUMNS FROM City
C. SHOW COLUMNS LIKE 'City'
D. SHOW City COLUMNS
Answer: B
5. The default database contains a table called City. Which of the following statements may be executed to
obtain a statement that could be used to (re-)create the City table?
Select the best response.
A. DESCRIBE City
B. DESCRIBE TABLE City
C. SHOW T