Oracle Database 12c: SQL Fundamentals — Question 23

Which arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

Answer options

• A. addition
• B. subtraction
• C. raising to a power
• D. finding the quotient
• E. finding the lowest value

Correct answer: A, C, E

Explanation

The correct operations that can be performed using built-in SQL functions in Oracle are addition, raising to a power, and finding the lowest value. Subtraction and finding the quotient are not standard SQL functions in Oracle, while finding the lowest value is typically achieved using the MIN function.