Multiple choice technology databases

What are the Text and Image Functions?A. PATINDEX,TEXTPTR,TEXTVALIDB. BINARY_CHECKSUM MIN ,CHECKSUM SUM ,CHECKSUM_AGG STDEV ,COUNT STDEVP ,COUNT_BIG C.BINARY_CHECKSUM MIN ,CHECKSUM SUM ,CHECKSUM_AGG STDEV ,TEXTPTR,TEXTVALID

  1. A only

  2. Both A nad B

  3. B Only

  4. Both B and C
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

PATINDEX, TEXTPTR, and TEXTVALID are text and image functions in SQL Server. PATINDEX finds pattern positions, TEXTPTR returns a text pointer value, and TEXTVALID checks if a text pointer is valid. Options B and C incorrectly list aggregate functions like MIN, CHECKSUM, and STDEV, which are statistical functions, not text/image functions.

Keep practicing — related questions