stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
Arithmetic Operator assessment - IM 2 Group 9 Flashcards | StudBud
Explore
/
Arithmetic Operator assessment - IM 2 Group 9
Arithmetic Operator assessment - IM 2 Group 9
10 terms
·
StudBud Administration
·
6 plays
Imported from external platform
Flashcards
10 cards
F
Practice quiz
P
Host live
L
Questions
10
Answers
1
Mathematical operators in MySQL are responsible for performing calculations and handling numerical data in SQL queries?
True
False
2
in LIMIT with Offset, LIMIT (3,5), where 3 is the number of rows to be displayed?
True
False
3
As per the best practices, using "LIMIT" in conjunction with "Order by" will ensure predictable results?
True
False
4
Based on the output below, num1 = 5, num2 = 10 when subtraction operation is used, the difference will be -10?
False
True
5
In the order of operations, using PEMDAS/BODMAS order of operations for processing the SUM?
False
True
6
In MySQL Arithmetic Operations, what function you will use when getting the exponentiation?
POWER(num1,num2,num3)
POWER(num1)
POWER(num1,num2)
POWERS()
7
Modulus '%' operator returns the remainder before diving one number by another?
True
False
8
Based on the query below, the arithmetic operator used is (+) which will return the sum of both column values?
False
True
9
What happens when an alias is not used from the arithmetic operation column? what column name is displayed in the table?
AS sum
num1 + num2
num1 + num2 AS sum
sum
10
Based on the output below, what arithmetic operation was used to come up with the results of 50 and 300?
Sum
Product
Difference
Quotient