nerdexam
SAP

C_TAW12_750 · Question #246

The USER has the following fields: ID, FIRSTJMAME, LAST_NAME. FIRST_NAME, LAST_NAME have the same basic type and length. You want to compare fields FIRST_NAME, LAST_NAME to each other. Which of the…

The correct answer is B. SELECT*FROM users AS a INTO TABLE lt_users WHERE a»first_name = a»last_name C. SELECT*FROM users INTO TABLE lt_users WHERE first name = users »last_name. See the full explanation below for the reasoning.

Question

The USER has the following fields: ID, FIRSTJMAME, LAST_NAME. FIRST_NAME, LAST_NAME have the same basic type and length. You want to compare fields FIRST_NAME, LAST_NAME to each other. Which of the following SELECT statements can you use? There are 2 correct answers to this question. Response:

(1/1 Points)

Options

  • ASELECT*FROM users INTO TABLE lt_users WHERE first_name = users last_name
  • BSELECT*FROM users AS a INTO TABLE lt_users WHERE a»first_name = a»last_name
  • CSELECT*FROM users INTO TABLE lt_users WHERE first name = users »last_name.
  • DSELECT*FROM users AS a INTO TABLE lt_users WHERE a first_name = last_name.

How the community answered

(36 responses)
  • A
    19% (7)
  • B
    72% (26)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_TAW12_750 Practice