Test Your MySQL Arithmetic Operators Knowledge with This Quiz

Progress

True / False

In MySQL, the + operator can be used to add two numeric values.

True False

The + operator in MySQL is used to perform addition on two numeric values.

True / False

In MySQL, the * operator is used for division.

True False

The * operator in MySQL is used for multiplication, not division. The / operator is used for division.

True / False

In MySQL, the - operator can subtract one numeric value from another.

True False

The - operator in MySQL is used to subtract one numeric value from another.

True / False

In MySQL, using the % operator with two integers returns the quotient of the division.

True False

The % operator in MySQL is used to return the remainder (modulus) of the division, not the quotient.

True / False

MySQL supports the use of parentheses () to change the precedence of arithmetic operations.

True False

Parentheses can be used in MySQL to change the order of operations in arithmetic expressions.

True / False

In MySQL, 5 / 2 returns 2.5.

True False

In MySQL, dividing two integers returns a floating-point result if the division is not exact.

True / False

In MySQL, the DIV operator is used for integer division and discards the fractional part.

True False

The DIV operator in MySQL performs integer division, discarding any fractional part of the result.

True / False

In MySQL, the expression 10 MOD 3 returns 3.

True False

The MOD operator in MySQL returns the remainder of the division. 10 MOD 3 returns 1.

True / False

MySQL does not allow the use of arithmetic operators on date values.

True False

MySQL allows the use of arithmetic operators on date values for date calculations, such as adding or subtracting days.

Q10

True / False

In MySQL, 7.0 / 2 returns 3.5, demonstrating MySQL's ability to handle floating-point division

True False

In MySQL, dividing a floating-point number by an integer (or vice versa) returns a floating-point result.

Q11

Single Choice

What is the result of the following SQL query?

SQL Code

SELECT 5 + 3 AS result;

8 53 153

The + operator adds the two numbers 5 and 3, resulting in 8.

Q12

Single Choice

What does the SQL query below return?

SQL Code

SELECT 10 - 4 AS result;

6 -6 4104

The - operator subtracts 4 from 10, giving the result of 6.

Q13

Single Choice

Which operator is used to multiply numbers in MySQL?

/ * -+

The * operator is used for multiplication in MySQL.

Q14

Single Choice

What will be the output of the following SQL query?

SQL Code

SELECT 12 / 4 AS result;

3 4 480

The / operator divides 12 by 4, resulting in 3.

Q15

Single Choice

Consider the following SQL code:

SQL Code

SELECT 5 * (2 + 3) AS result;

10 25 350

The expression inside the parentheses is evaluated first, resulting in 5 * 5 = 25.

Q16

Single Choice

What does the following SQL statement return?

SQL Code

SELECT 15 % 4 AS result;

3 4 715

The % operator returns the remainder of the division of 15 by 4, which is 3.

Q17

Single Choice

What is the result of this SQL query?

SQL Code

SELECT (8 + 5) * (10 - 4) AS result;

72 78 4556

The operations inside parentheses are performed first: (8 + 5) = 13 and (10 - 4) = 6, resulting in 13 * 6 = 78.

Q18

Single Choice

What will be the result of the following SQL statement?

SQL Code

SELECT (20 - 5) / (2 + 3) AS result;

3 5 610

The operations inside parentheses are evaluated first: (20 - 5) = 15 and (2 + 3) = 5, so 15 / 5 = 3.

Q19

Single Choice

Given this SQL statement

SQL Code

SELECT (7 * 5 + 10) / (2 * 3) AS result;

8 9 1012

First calculate inside parentheses: (7 * 5 + 10) = 45 and (2 * 3) = 6, so 45 / 6 = 7.5, which is rounded to 10 if using integer division.

Q20

Single Choice

What will the following SQL query return when executed?

SQL Code

SELECT ROUND(3.14159 * 10 / 3, 2) AS result;

10.48 10.45 10.4610.41

The arithmetic operation is performed first (3.14159 * 10 / 3 ≈ 10.472), and then ROUND function rounds the result to 2 decimal places, which is 10.48.

Q21

Multiple Choice

Which SQL query uses the addition operator to calculate the total price by adding tax to the base price?

SQL Code

SELECT product_name, price + tax AS total_price
FROM products;

SELECT product_name, price + tax AS total_price FROM products; SELECT product_name, SUM(price + tax) AS total_price FROM products; SELECT product_name, price - tax AS total_price FROM products;SELECT product_name, price * tax AS total_price FROM products;

The addition operator (+) is used to calculate the total price by adding the 'tax' to the 'price' for each product.

Q22

Multiple Choice

Identify the SQL query that uses the subtraction operator to find the difference between a product's sale price and its cost price.

SQL Code

SELECT product_name, sale_price - cost_price AS profit
FROM sales;

SELECT product_name, sale_price - cost_price AS profit FROM sales; SELECT product_name, sale_price + cost_price AS profit FROM sales; SELECT product_name, sale_price * cost_price AS profit FROM sales;SELECT product_name, sale_price / cost_price AS profit FROM sales;

The subtraction operator (-) is used to calculate the profit by subtracting 'cost_price' from 'sale_price' for each product.

Q23

Multiple Choice

Which SQL query uses the multiplication operator to calculate the total revenue from the quantity sold?

SQL Code

SELECT product_name, price * quantity_sold AS revenue
FROM sales;

SELECT product_name, price * quantity_sold AS revenue FROM sales; SELECT product_name, price + quantity_sold AS revenue FROM sales; SELECT product_name, price - quantity_sold AS revenue FROM sales;SELECT product_name, price / quantity_sold AS revenue FROM sales;

The multiplication operator (*) is used to calculate the revenue by multiplying the 'price' by the 'quantity_sold' for each product.

Q24

Multiple Choice

Determine the SQL query that uses the division operator to calculate the average price per unit of a product.

SQL Code

SELECT product_name, total_price / quantity_sold AS price_per_unit
FROM sales;

SELECT product_name, total_price / quantity_sold AS price_per_unit FROM sales; SELECT product_name, total_price * quantity_sold AS price_per_unit FROM sales; SELECT product_name, total_price - quantity_sold AS price_per_unit FROM sales;SELECT product_name, total_price + quantity_sold AS price_per_unit FROM sales;

The division operator (/) is used to calculate the price per unit by dividing 'total_price' by 'quantity_sold' for each product.

Q25

Multiple Choice

Which SQL query uses the modulus operator to find the remainder when the total sales amount is divided by the number of units?

SQL Code

SELECT product_name, total_sales % quantity_sold AS remainder
FROM sales;

SELECT product_name, total_sales % quantity_sold AS remainder FROM sales; SELECT product_name, total_sales / quantity_sold AS remainder FROM sales; SELECT product_name, total_sales * quantity_sold AS remainder FROM sales;SELECT product_name, total_sales + quantity_sold AS remainder FROM sales;

The modulus operator (%) is used to calculate the remainder when 'total_sales' is divided by 'quantity_sold' for each product.

Q26

Multiple Choice

Which SQL query uses the combination of addition and multiplication operators to calculate the total cost including a percentage tax?

SQL Code

SELECT product_name, price + (price * tax_rate / 100) AS total_cost
FROM products;

SELECT product_name, price + (price * tax_rate / 100) AS total_cost FROM products; SELECT product_name, price - (price * tax_rate / 100) AS total_cost FROM products; SELECT product_name, price * (tax_rate / 100) AS total_cost FROM products;SELECT product_name, price / (1 + tax_rate / 100) AS total_cost FROM products;

The combination of addition (+) and multiplication (*) operators is used to calculate the total cost including tax, where tax is a percentage of the price.

Q27

Multiple Choice

Identify the SQL query that calculates the compound interest using arithmetic operators.

SQL Code

SELECT principal * POW(1 + rate / 100, time) AS compound_interest
FROM investments;

SELECT principal * POW(1 + rate / 100, time) AS compound_interest FROM investments; SELECT principal + (rate * time) AS compound_interest FROM investments; SELECT principal * (1 + rate * time / 100) AS compound_interest FROM investments;SELECT POW(principal, rate * time / 100) AS compound_interest FROM investments;

The combination of multiplication (*) and power (POW) functions is used to calculate compound interest using the formula: principal * (1 + rate/100) ^ time.

Q28

Multiple Choice

Which SQL query uses subtraction and division operators to calculate the percentage profit margin for a product?

SQL Code

SELECT product_name, ((sale_price - cost_price) / sale_price) * 100 AS profit_margin
FROM sales;

SELECT product_name, ((sale_price - cost_price) / sale_price) * 100 AS profit_margin FROM sales; SELECT product_name, (sale_price / cost_price) * 100 AS profit_margin FROM sales; SELECT product_name, (sale_price - cost_price) * 100 AS profit_margin FROM sales;SELECT product_name, (cost_price / sale_price) * 100 AS profit_margin FROM sales;

The subtraction (-) and division (/) operators are used to calculate the profit margin percentage by dividing the profit by the sale price and multiplying by 100.

Q29

Multiple Choice

Determine the SQL query that uses the arithmetic operators to calculate the final amount after applying a discount and adding tax.

SQL Code

SELECT product_name, (price - discount) + ((price - discount) * tax_rate / 100) AS final_amount
FROM products;

SELECT product_name, (price - discount) + ((price - discount) * tax_rate / 100) AS final_amount FROM products; SELECT product_name, (price - discount) * (1 + tax_rate / 100) AS final_amount FROM products; SELECT product_name, price + discount + (tax_rate / 100) AS final_amount FROM products;SELECT product_name, (price * discount) + tax_rate AS final_amount FROM products;

The subtraction (-), addition (+), and multiplication (*) operators are used to calculate the final amount by first applying the discount and then adding tax.

Q30

Multiple Choice

Which SQL query uses arithmetic operators to calculate the breakeven point where total revenue equals total costs?

SQL Code

SELECT (fixed_costs / (price - variable_costs)) AS breakeven_point
FROM business_data;

SELECT (fixed_costs / (price - variable_costs)) AS breakeven_point FROM business_data; SELECT (fixed_costs * price) - variable_costs AS breakeven_point FROM business_data; SELECT (fixed_costs + variable_costs) / price AS breakeven_point FROM business_data;SELECT price / (fixed_costs - variable_costs) AS breakeven_point FROM business_data;

The division (/) and subtraction (-) operators are used to calculate the breakeven point where the fixed costs are divided by the difference between price and variable costs.

MySQL Database Quiz Questions