Which two are true? (Choose two.)
Which two are true? (Choose two.)
CONCAT joins two character strings together, allowing them to be combined into one. FLOOR returns the largest integer less than or equal to a specified number, which means it rounds down the number to the nearest integer. These statements are true based on the definitions of the functions.
How F is correct. In case argument is passed in a negative. eg -1.4. The output is -2. But -1 is greater than -2. And, its contrast with option F. F. FLOOR returns the largest integer less than or equal to a specified number. select floor(-1.4) from dual; o/p ---2
A. CONCAT joins two character strings together. F. FLOOR returns the largest integer less than or equal to a specified number.
How F can be correct?! Okay, in oracle documents it is mentioned like : FLOOR returns the largest integer equal to or less than n. But why it returns less than inputted value?? (select floor(15,7) from dual => output is 15) That statement is proper for CEIL function for my point of view. Can anyone help me to overcome this simply seem but complicated question?
Floor takes the minimum integer value while CEIL takes the largest integer value. SELECT FLOOR('100.2') FROM DUAL; //op: 100 SELECT CEIL('100.2242') FROM DUAL;//op: 101
A-F Correct
Why option-b is not correct? can any one explain
Try to concat 3 different strings and see... it's posible in Microsoft SQL, not Oracle
CONCAT as a function in Oracle can only do two strings, if you want more, use || The function and operator are not the same thing!
how is F correct?
https://docs.oracle.com/database/121/SQLRF/functions076.htm#SQLRF00643 "FLOOR returns the largest integer equal to or less than n."