PNG60403 TOPIC 4.4

What is the primary command used to retrieve information from a database in SQL?

• UPDATE

• DELETE

• INSERT

• SELECT

Which clause is used to filter records based on specified conditions in SQL queries?

• WHERE

• HAVING

• GROUP BY

• ORDER BY

What is the purpose of the ORDER BY clause in SQL queries?

• Filter records

• Join tables

• Aggregate data

• Sort results

Which SQL function is used to count the number of occurrences of a specific column?

• AVG()

• SUM()

• MAX()

• COUNT()

What type of join combines rows from two or more tables based on a related column?

• OUTER JOIN

• LEFT JOIN

• INNER JOIN

• RIGHT JOIN

What does the GROUP BY statement do in SQL queries?

• Filter groups

• Sort rows

• Group rows

• Join tables

Which clause is used to filter summarized GROUP BY results in SQL queries?

• GROUP BY

• ORDER BY

• WHERE

• HAVING

What can significantly enhance your ability to work efficiently with data in SQL?

• Understanding SQL queries

• Using Excel

• Writing reports

• Creating presentations

What is the simplest form of a query in SQL that retrieves columns from one or more tables?

• SELECT

• INSERT

• DELETE

• UPDATE

Which SQL clause is used to sort the result-set in ascending or descending order?

• GROUP BY

• HAVING

• ORDER BY

• WHERE