Oracle
1Z0-882 · Question #9
The people table contains the data as shown: Which two statements return two rows each?
The correct answer is B. SELECT 1,2 FROM people GROUP BY last_name E. SELECT first _name, last_name FROM people LIMIT 1, 2. See the full explanation below for the reasoning.
Question
The people table contains the data as shown:
Which two statements return two rows each?
Options
- ASELECT DISTINCT last_name, first_name FROM people
- BSELECT 1,2 FROM people GROUP BY last_name
- CSELECT first_name, last _name FROM people WHERE age LIKE `2'
- DSELECT 1, 2 FROM people WHERE last _name ='smith'
- ESELECT first _name, last_name FROM people LIMIT 1, 2
How the community answered
(24 responses)- A4% (1)
- B83% (20)
- C8% (2)
- D4% (1)
Community Discussion
No community discussion yet for this question.