A - FALSE; MOD returns the remainder of a division operation
B - FALSE; FLOOR returns the greatest integer smaller or equal to a specified number
C - TRUE; TRUNC(2.152) and TRUNC(sysdate) are valid expressions
D - FALSE; CONCAT joins only two strings (or other datatype expressions that are implicitly converted to a string)
E - TRUE; CEIL as well as FLOOR can be used for both possitive and negative numbers
Concat may be used with number datatype... for me C,D,E are right
MANAGER_ID NUMBER(6)
DEPARTMENT_ID NUMBER(4)
SQL> select concat(manager_id,department_id) from employees;
CONCAT(MANAGER_ID,DEPARTMENT_ID)
--------------------------------------------------------------------------------
90
10090
10090
A is wrong. A quotient is the result of a division operation. MOD returns the remainder of n2 divided by n1.
B is wrong. FLOOR returns the largest integer equal to or less than n.
C is correct. The TRUNC (number) function returns n1 truncated to n2 decimal places. The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt.
D is wrong. CONCAT returns char1 concatenated with char2. Both char1 and char2 can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.
E is correct. Not clearly documented but implied with: "This function takes as an argument any numeric data type". Negative numbers are still numbers.
It's amusing how the link in the alleged solution is correct, but the given solution is wrong. MOD returns the remainder of course.
I agree with C & E
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
you1234
Highly Voted 3 years, 6 months agoEkos
3 years, 1 month agoama
3 years, 6 months agonautil2
Most Recent 3 months, 1 week agoauwia
6 months, 2 weeks agoMinoro
1 year, 1 month agoFelipeC
11 months agoraferen10
1 year, 1 month agoFranky_T
1 year, 8 months agoAldo_7
1 year, 1 month agoryuah
2 years agoSimoneF
3 years, 1 month ago