Question 1

What is the primary function of the SELECT query in SQL?

Accepted Answer

To retrieve data from a database.

Answer

To update data in a database.

Answer

To delete data from a database.

Answer

To create a new database.

Question 2

What does the WHERE clause do in an SQL query?

Accepted Answer

It allows you to set conditions on the data you want to retrieve.

Answer

It limits the number of rows returned.

Answer

It sorts the data in ascending order.

Answer

It combines multiple tables together.

Question 3

How do you use the IN operator in a SQL query?

Accepted Answer

To specify multiple values for a column.

Answer

To count the number of records.

Answer

To sort data in an ascending order.

Answer

To filter data within a range.

Question 4

What is the purpose of the CAST function in SQL?

Accepted Answer

To convert data from one type to another.

Answer

To count the number of records.

Answer

To create an alias for a column.

Answer

To round off numeric values.

Question 5

What does the ROUND function do?

Accepted Answer

It rounds off numeric values to a specific number of decimal places.

Answer

It concatenates two strings together.

Answer

It counts the number of rows in a table.

Answer

It calculates the total sum of a column.

Question 6

What is an alias in SQL?

Accepted Answer

A nickname for a column or table name.

Answer

A command to delete records.

Answer

A feature to sort results.

Answer

A method to create new tables.

Question 7

What is the function of the GROUP BY clause in SQL?

Accepted Answer

To group rows that have the same values in specified columns.

Answer

To filter results based on conditions.

Answer

To retrieve data from multiple tables.

Answer

To sort the results in ascending order.

Question 8

How does the ORDER BY clause function in an SQL query?

Accepted Answer

It sorts the data based on specified columns.

Answer

It filters records based on specific conditions.

Answer

It retrieves data from multiple tables.

Answer

It creates a new column in the results.

Question 9

What does a nested SELECT statement involve?

Accepted Answer

Using a SELECT statement inside another SELECT statement.

Answer

Combining two tables into one.

Answer

Sorting results by multiple columns.

Answer

Counting the number of unique values.

Question 10

What is the use of the HAVING clause in SQL?

Accepted Answer

To impose conditions on groups created by GROUP BY.

Answer

To filter out null values from a column.

Answer

To sort data in descending order.

Answer

To create a new alias for a table.