nerdexam
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)
  • A
    79% (48)
  • B
    3% (2)
  • C
    11% (7)
  • D
    7% (4)

Community Discussion

No community discussion yet for this question.

Full E10-110 Practice