SIGN(valor). Prueba con números positivos y negativos:

SQL> SELECT SIGN(-10), SIGN(10) FROM DUAL;

SIGN(-10)    SIGN(10)
  ----------        ----------
        -1                  1

SQRT(n). SQL> SELECT SQRT(25), SQRT(25.6) FROM DUAL;

SQRT(25)    SQRT(25.6)
   --------             ----------
5                     5,05964426

TRUNC(número, [m]).

Con truncamiento positivo:

SQL> SELECT TRUNC(1.5634, 1), TRUNC(1.1684, 2), TRUNC(1.662) FROM DUAL;

TRUNC(1.5634,1)         TRUNC(1.1684,2)            TRUNC(1.662)
    ---------------                       ---------------                           ------------
          1,5                                     1,16                                         1

Con truncamiento negativo:

SQL> SELECT TRUNC(187.98,-1), TRUNC(187.98,-2), TRUNC(187.98,-3) FROM DUAL;

TRUNC(187.98,-1)         TRUNC(187.98,-2)       TRUNC(187.98,-3)
   ----------------                        ----------------                      ----------------
           180                                        100                                     0

Actividades propuestas

1. Cuál sería la salida de ejecutar estas funciones?

ABS(146)=            ABS(-30)=             POWER(3,-1)=                ROUND(33.67)=
CEIL(2)=               CEIL(1.3)=             ROUND(-33.67,2)=        ROUND(-33.67,-2)=
CEIL(-2.3)=          CEIL(-2)=                ROUND(-33.27,1)=        ROUND(-33.27,-1)=
FLOOR(-2)=         FLOOR(-2.3)=        TRUNC(67.232)=           TRUNC(67.232,-2)=
FLOOR(2)=          FLOOR(1.3)=          TRUNC(67.232,2)=        TRUNC(67.58,-1)=
MOD(22,23)=       MOD(10,3)=            TRUNC(67.58,1)=
POWER(10,0)=    POWER(3,2)=