The latest 010-002 practice exam
Author: admin
Latest 010-002 exam dumps
Exam Number/Code: 010-002
Questions and Answers:50 Q&As
Updated: 2009-08-31
Register for Exam: Prometric/Pearson VUE
Exam Name:Certified MySQL Associate(English)
010-002 dumps Description
Credit Toward CertificationWhen you pass Exam 010-002: Certified MySQL Associate(English), you complete the requirements for the following certification(s):
MYSQL Certified Technical Specialist: Certified MySQL Associate(English) Note This preparation guide is subject to change at any time without prior notice and at the sole discretion of MYSQL. MYSQL exams might include adaptive testing technology and simulation items. MYSQL does not identify the format in which exams are presented. Please use this preparation guide to prepare for the exam, regardless of its format.
we have Pass4side 010-002 practice exam,Pass4side 010-002 braindumps,Pass4side 010-002 study guide,Pass4side 010-002 dumps.and Pass4sure 010-002 exam,Pass4sure 010-002 practice exam,pass4sure 010-002 study guide. and we have Testking 010-002 exam,Testking 010-002 study guide,testking 010-002 braindumps.etc.
Pass4side professional IT Q&As vendors, offer well after-sale service for 010-002 Exam. To all the customers buy the real 010-002 Exam questions and answers, Pass4side provide track service for 010-002 study guides. when you buy the Q&As with in 3 months. you can enjoy the upgrade Q&As service for free with 010-002 practice exam. If in this period, the certified test center change the MYSQL 010-002 Exam Q&As, we will update the 010-002 simulations Q&A in the first time, and provide you the download update for free
Exam : MySQL 010-002
Title : Certified MySQL Associate (English)
1. 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
D. TRUNCATE DATABASE world
Answer: B
2. 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
3. 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
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 TABLE City
D. SHOW CREATE TABLE City
Answer: D
if you think the exam questions and answers are excellent , you can view : 010-002 Practice exam
No related posts.
Related posts brought to you by Yet Another Related Posts Plugin.
Leave a Reply
You must be logged in to post a comment.