Which two statements are true about single row functions?
A.
CONCAT: can be used to combine any number of values
B.
FLOOR: returns the smallest integer greater than or equal to a specified number
C.
CEIL: can be used for positive and negative numbers
D.
TRUNC: can be used with NUMBER and DATE values
E.
MOD: returns the quotient of a division operation
The Answer Is:
C, D
This question includes an explanation.
Explanation:
Regarding single row functions in Oracle Database 12c:
C. CEIL: can be used for positive and negative numbers. This is true. The CEIL function rounds a number up to the nearest integer, and it works for both positive and negative values.
D. TRUNC: can be used with NUMBER and DATE values. This is correct. The TRUNC function can truncate numbers or dates to a specified precision.
Options A, B, and E are incorrect:
A is incorrect because CONCAT function typically concatenates two strings; to concatenate more, you must nest CONCAT calls or use the || operator.
B is incorrect because FLOOR returns the largest integer less than or equal to the specified number, not greater.
E is incorrect because MOD returns the remainder of a division operation, not the quotient.
[Reference: Oracle Database SQL Language Reference, 12c Release 1 (12.1)]
1z0-071 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"