nerdexam
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)
  • A
    4% (2)
  • B
    84% (38)
  • C
    2% (1)
  • D
    9% (4)

Community Discussion

No community discussion yet for this question.

Full E20-120 Practice