Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Be Interview Ready
Welcome Guest !
What is the value for SIGN(NVL(-16,0))?
on 11/14/2016 | Category:
Oracle Interview questions
| Views: 1939 |
Select from following answers:
Here Let see how we calculate these values.
Consider we have the following : SIGN(ABS(NVL(-75,0)))
Just like mathematics we should take it from the inner brackets.
So first step will be,
NVL(-75,0) = -75
Now, next bracket
ABS(-75) = 75 //ABS always take positive
Finally SIGN(75) = 1
If SIGN(>1) = 1, SIGN(<1) = -1, SIGN(0) = 0.
So in our question we didn't use the ABS function, So it remains Negative and SIGN Function of Negative will be -1.
Show Correct Answer
Many Interviews |
< Previous :
Which date components does the CURRENT_TIMESTAMP f ...
Next > :
ORACLE maintains referential integrity by automati ...
Comments or Responses
Login to post response
More Interview Questions by Manicse
ORACLE maintains referential integrity by automatically removing depen ...
What are the various credential types used along with OAuth 2.0?
What is the Maximum Number of triggers can be applied in a Table?
How to see Current User name who using in Oracle?
What is the Cluster Key?
Which of the following query will show you which constraints is mapped ...
What is BCP? What is its Use?
What is ABC in WCF?
Latest Interview Questions
What is the benefit of Unit Testing?
What is Arrange-Act-Assert (AAA) phase in Unit testing?
Write the code for fetching record from Redis using C#
Give an example of inserting bulk records to REDIS in C#
What is ConnectionMultiplexer?
List out some of the features of REDIS
What is REDIS?
What’s wrong in the following query? SELECT Name, MaxSal = Max(Sal ...