MidExWT-CS2101

What type of operator is used to perform mathematical calculations in MySQL?

• Comparison Operators

• Arithmetic Operators

• Bitwise Operators

• Logical Operators

Which SQL command is used to retrieve data from one or more tables in MySQL?

• INSERT

• UPDATE

• SELECT

• JOIN

What does an INNER JOIN return?

• All rows from both tables

• Rows from both tables that match the specified condition

• All rows from the right table

• All rows from the left table

Which clause is used to filter rows that meet a specific condition?

• GROUP BY

• WHERE

• LIMIT

• ORDER BY

What does the LIMIT clause do in a SQL query?

• Filters rows based on conditions

• Groups rows with the same values

• Restricts the number of rows returned

• Sorts the result set

Which statement is used to add new rows of data into a table?

• DELETE

• SELECT

• INSERT

• UPDATE

What is the purpose of the HAVING clause?

• To limit the number of rows returned

• To sort the result set

• To filter results of a GROUP BY operation

• To filter rows before grouping

Which aggregate function would you use to find the average value?

• MAX()

• AVG()

• COUNT()

• SUM()

What does the ORDER BY clause do?

• Limits the number of rows returned

• Filters rows based on conditions

• Sorts the result set

• Groups rows with the same values

Which command is used to modify existing records in a table?

• DELETE

• SELECT

• UPDATE

• INSERT