Which two are character manipulation functions? (Choose two.)

The correct answer is A. TRIM B. REPLACE. TRIM() and REPLACE() are character manipulation functions. Incorrect Answers C: TRUNC(x,y) is arithmetic function, it truncates x to the decimal precision of y. If y is negative, it truncates to y number of places to the left of the decimal point. This can also be used on DATE…

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

Options

ATRIM
BREPLACE
CTRUNC
DTO_DATE
EMOD
FCASE

How the community answered

(33 responses)

A
82% (27)
C
3% (1)
E
6% (2)
F
9% (3)

Explanation

TRIM() and REPLACE() are character manipulation functions. Incorrect Answers C: TRUNC(x,y) is arithmetic function, it truncates x to the decimal precision of y. If y is negative, it truncates to y number of places to the left of the decimal point. This can also be used on DATE columns. D: TO_DATE(x,[y]) function converts the non-date value x to a date using the format specified by E: MOD(x,y) is arithmetic function, the modulus of x, defined in long division as the integer remainder when x divided by y until no further whole number can be produced. F: There is no character manipulation function CASE in Oracle.

Topics

#character functions#TRIM#REPLACE#single-row functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice