Oracle Database SQL — Question 260

Which two are true? (Choose two.)

Answer options

• A. CONCAT joins two character strings together.
• B. CONCAT joins two or more character strings together.
• C. FLOOR returns the largest positive integer less than or equal to a specified number.
• D. INSTR finds the offset within a character string, starting from position 0.
• E. INSTR finds the offset within a string of a single character only.
• F. FLOOR returns the largest integer less than or equal to a specified number.

Correct answer: A, F

Explanation

Option A is correct because CONCAT indeed joins two character strings together, and option F is also correct because FLOOR returns the largest integer less than or equal to a specified number. Options B and E are incorrect as they either overstate or misstate the functionality of CONCAT and INSTR, respectively. Options C and D are misleading in their definitions of FLOOR and INSTR.