nerdexam
Oracle

1Z0-459 · Question #23

You want to develop a BI Publisher report for all active users in the company. Identify the correct SQL statement.(Choose the best answer.)

The correct answer is C. upper(:p_varchar_Org)). See the full explanation below for the reasoning.

Question

You want to develop a BI Publisher report for all active users in the company. Identify the correct SQL statement.(Choose the best answer.)

Options

  • Aupper(:p_varchar_UserID))
  • BB. upper(:p_varchar_UserID))
  • Cupper(:p_varchar_Org))
  • DD.upper(:p_varchar_Org))
  • Eupper(:p_varchar_UserID))

How the community answered

(30 responses)
  • A
    13% (4)
  • B
    3% (1)
  • C
    77% (23)
  • E
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-459 Practice