B is correct, CONCAT joins two or more arguments.
--Example query
select concat('this ', 'is ', 'a ', 'test') concat from dual;
Output: "this is a test"
F is also correct, since it accepts negative numbers as well.
--Example query
select floor(-5.2526) from dual;
Output: -6 (-6 is smaller than -5, it also caught me offguard the first time).
B is not true
if you want to use CONCAT() with many arguments then it looks like the example below
select concat('this', concat(' is', concat(' a', ' test'))) from dual;
Starting from Oracle 23c, CONCAT can take multiple arguments:
https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/CONCAT.html
https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/CONCAT.html
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
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 voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
highwater
5 days, 21 hours agoLuisLikes
1 month, 2 weeks agohighwater
5 days, 21 hours ago15eeda4
2 months, 3 weeks ago5cff9a8
5 months agoDrexan
5 months, 1 week agohmatinnn
1 year, 4 months agoLee_jong_suk
1 year, 3 months agoGuru_C
1 year, 8 months agoProctored_Expert
2 years, 3 months agoMahdiHamdii
2 years, 3 months agoboddoju
2 years, 4 months agoJ4vi
2 years, 1 month agoRik92
1 year, 10 months agopawanl
2 years, 6 months ago