Practice Test GeeksOracle SQL Practice Test
← All Oracle SQL Flashcard Decks

Oracle SQL Functions Flashcards

6 cards from real Oracle SQL practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 6 Oracle SQL Functions flashcards as text

  1. Which Oracle SQL aggregate function returns the average of a column's values?

    Answer: AVG

    AVG calculates the arithmetic mean of non-NULL values in a column.

  2. What does the CONCAT function do in Oracle SQL?

    Answer: Joins two strings together

    CONCAT(string1, string2) joins two strings end-to-end, equivalent to using the || operator in Oracle.

  3. Which Oracle SQL function returns the smallest integer greater than or equal to a number?

    Answer: CEIL

    CEIL (ceiling) returns the smallest integer that is greater than or equal to the input number.

  4. What does TO_CHAR(SYSDATE, 'YYYY-MM-DD') return in Oracle SQL?

    Answer: The current date formatted as a string like '2026-03-21'

    TO_CHAR converts a DATE to a VARCHAR2 string using the specified format mask, producing a readable date string.

  5. Which Oracle SQL function searches for a substring within a string and returns its position?

    Answer: INSTR

    INSTR(string, substring) returns the position of the first occurrence of substring within string, or 0 if not found.

  6. What does the DECODE function do in Oracle SQL?

    Answer: Acts like a CASE expression, mapping values to results

    DECODE(expr, search1, result1, ..., default) compares expr to each search value and returns the corresponding result, similar to CASE WHEN.