What does SQL stand for?

• Structured Query List
• Simple Query Language
• Structured Query Language
• Sample Query Language

Which SQL statement is used to retrieve data from a database?

• GET
• SELECT
• FETCH
• SHOW

What keyword is used to insert new data into a table?

• ADD
• UPDATE
• INSERT
• INPUT

Which clause is used to filter records?

• ORDER BY
• SELECT
• GROUP BY
• WHERE

What is used to sort the result-set in SQL?

• SORT BY
• FILTER BY
• ORDER BY
• ALIGN BY

What type of join returns only matching rows from both tables?

• LEFT JOIN
• RIGHT JOIN
• FULL JOIN
• INNER JOIN

Which aggregate function returns the number of rows?

• TOTAL()
• COUNT()
• SUM()
• AVG()

What clause is used with GROUP BY to filter grouped records?

• WHERE
• ORDER BY
• HAVING
• FILTER

Which keyword combines the result of two SELECT statements and removes duplicates?

• UNION
• JOIN
• MERGE
• INTERSECT

Which function returns the average of numeric values?

• MEAN()
• AVG()
• AVERAGE()
• SUM()/COUNT()

What does the `START TRANSACTION` command do?

• Begins a stored procedure
• Begins a transaction block
• Creates a user session
• Starts a trigger

What is the purpose of the `COMMIT` statement?

• Save changes permanently
• Undo changes
• Validate user
• Rollback transaction

What does the `ROLLBACK` command do?

• Saves a query result
• Restores data to a savepoint
• Undoes uncommitted changes
• Archives a table

Which MySQL object executes automatically in response to events on a table?

• Procedure
• Trigger
• Event
• Function

Which clause is used to define a trigger’s execution time?

• ON
• BEFORE/AFTER
• WHEN
• FOR EACH