Predict the output of the following queries:
i. Select power(5,3);
ii. Select mod(5,3);
OR
Briefly explain the purpose of the following SQL functions:
i. power()
ii. mod()
Answered Feb 05, 2023
Output:
i. 125
ii. 2
i. power(): It returns the value of a number raised to the power of another number.
For example:
Select power(5,3);
Output: 125
ii. mod(): It returns the remainder of a number divided by another number.
Select mod(5,3);
Output: 2
Output: i) 8.720 ii) 10
Correct answer is (a) Tables
The output is a string “83”; String addition means concatenation.
It displays a message box with character ‘E’ from the fifth (4 + 1) place
The out Put is “04802828159”. That is the string “0480” concatenates(joins) the number 2828159. The output is a string not a number.
Output is 12. In this statement first it take the value of k in 5 then increment it K++. So first operand for + is 5. Then it becomes 6....
1. 15 2. 16
The output is “ADELINE”.
Output is 4. Result will be the memory size of floating point number
a = -4, b = 2 and c = 1
Install the Bissoy app to consult with a doctor.
Log in to ask questions, provide answers, or leave comments.