Which function call returns true?

Question

Options

• AIS_EMAIL(@sap.com)
• BIS_EMAIL("@sap.com")
• CIS_EMAIL("[email protected]")
• DIS_EMAIL([email protected])

• A
  4% (1)
• B
  4% (1)
• C
  83% (19)
• D
  9% (2)

Explanation

IS_EMAIL("[email protected]") returns true because it is a properly formatted email address - containing a local part, an @ symbol, and a domain - passed as a string literal (in quotes). Option A and D fail because they pass unquoted values, which are invalid syntax for a string function - the argument must be a quoted string, not a bare expression. Option B ("@sap.com") is a quoted string but is not a valid email address since it has no local part before the @.

Memory tip: Think "two requirements to pass" - the value must be (1) a quoted string and (2) a valid email format ([email protected]). Only C satisfies both.

No community discussion yet for this question.