Sun-Certified-MySQL-5-0-Developer-Part-II- 310-813 .pdf -...

310-813
SUN
Sun Certified MySQL 5.0 Developer Part(R) II

Which of the following are valid ways of returning information on whether the field value is
present in the table animals?
QUESTION: 65
Which of the following correctly demonstrates using mysqlshowto list databases on a server?
A
QUESTION: 66
Will the following two queries produce the same result? If not, why?
SELECT TABLE_NAME
F ROM INFORMATIOH_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'mysql' SELECT
table_name
F ROM inf o rmation_schema.tatales
WHERE tatale_schema = 'mysql'