CMDEV认证培训包-3期（PX020）习题3PX020030202170习题.docxVIP

QUESTION NO: 1 Assume that a table table1 contains the following data: mysql SELECT * FROM table1; 6 rows in set (0.00 sec) How many rows will be returned when the following statement is executed? SELECT DISTINCT col1 FROM table1; A. 6 B. 3 C. 4 Answer: C QUESTION NO: 2 Consider the friends table is given by the following information: mysql SELECT * FROM friends; Which of the following SELECT statements are valid? A. SELECT firstname FROM friends B. SELECT lastname, age, 1 FROM friends C. SELECT age D. SELECT age WHERE age 30 Answer: A,B,C QUESTION NO: 3 Which of the following comparisons is equivalent to: ( age = 4 ) and ( age = 8 ) A. age BETWEEN 4 and 8 B. age BETWEEN 3 and 9 C. age BETWEEN 5 and 7 D. age BETWEEN 4 and 7 Answer: A QUESTION NO: 4 What would be the outcome when following statement is executed? SELECT Name FROM City WHERE CountryCode = USA OR WHERE CountryCode = JPN A. The city names from USA and JPN in one result set. B. The city names from USA and JPN in two different result sets. C. The city names from USA in the first column and the cities from JPN in the second column. D. An error message is issued. Answer: D QUESTION NO: 5 Consider the following table structure. mysql DESCRIBE TEST; Why is it a bad idea to use SELECT * instead of specifying the required columns by their name? A. SELECT * may cause more data to be to be read from disk if your application only needs some columns. B. SELECT * causes more data to be sent over the network if your application only needs some columns. C. SELECT * prevents the use of indexes, so a full table scan is required for every query. D. SELECT * causes your application to depend on the columns present when you wrote it, so your application could break if new columns are added to the table structure Answer: A,B,D QUESTION NO: 6 Which of the following INSERT statements are syntactically correct? A. INSERT INTO friends (id, name, lastname, age) VALUES (1, John, Doe, 22) B. INSERT