Dell-EMC
E20-120 · Question #335
An external table has been registered using this DQL statement: REGISTER TABLE area_code_table (city STRING(256), area_code STRING(3)) Which DQL statement will return the area_code for New York?
The correct answer is B. SELECT area_code FROM dm_dbo.area_code_table WHERE city = 'New York'. See the full explanation below for the reasoning.
Question
An external table has been registered using this DQL statement:
REGISTER TABLE area_code_table (city STRING(256), area_code STRING(3)) Which DQL statement will return the area_code for New York?
Options
- ASELECT area_code FROM dm_area_code_table WHERE city = 'New York'
- BSELECT area_code FROM dm_dbo.area_code_table WHERE city = 'New York'
- CSELECT area_code FROM area_code_table (ALL) WHERE area_code_table.city = 'New York'
- DSELECT area_code_table FROM area_code WHERE city = 'New York'
How the community answered
(45 responses)- A4% (2)
- B84% (38)
- C2% (1)
- D9% (4)
Community Discussion
No community discussion yet for this question.