Dell-EMC
E10-110 · Question #130
An external table has been registered using this DQL statement: REGISTER TABLE airports_table (airport_nameSTRING(256), airport_code STRING(3)) Which DQL statement will return the airport_code for…
The correct answer is A. SELECT airport_code FROM airports_table WHERE airport_name = 'John F. Kennedy Airport'. See the full explanation below for the reasoning.
Question
An external table has been registered using this DQL statement:
REGISTER TABLE airports_table (airport_nameSTRING(256), airport_code STRING(3)) Which DQL statement will return the airport_code for John F. Kennedy Airport?
Options
- ASELECT airport_code FROM airports_table WHERE airport_name = 'John F. Kennedy Airport'
- BSELECT airport_code_table FROM airport_code name = "John F. Kennedy Airport"
- CSELECT airport_code FROM airport_code_table. airport_name = 'John F. Kennedy Airport'
- DSELECT airport_code FROM dm_airports_table WHERE airport_name = 'John F. Kennedy
How the community answered
(61 responses)- A79% (48)
- B3% (2)
- C11% (7)
- D7% (4)
Community Discussion
No community discussion yet for this question.