Digital Solutions SQL

Question 1

6. What SQL clause is used to filter rows in a SELECT query based on a specified condition?

Accepted Answer

WHERE

Question 2

4. What is the purpose of the SQL INSERT statement?

Accepted Answer

Add new records

Question 3

12. In a SQL sub-selection, where is the result set of the subquery typically used?

Accepted Answer

As a filter condition in the WHERE clause

Question 4

14. Which SQL statement is used to remove rows from a table based on a specified condition?

Accepted Answer

DELETE

Question 5

10. What is the purpose of the SQL JOIN operation?

Accepted Answer

Combine multiple tables based on related columns

Question 6

7. What is the purpose of the SQL GROUP BY clause?

Accepted Answer

Group rows with the same values into summary rows

Question 7

11. Which type of SQL join returns only the rows that have matching values in both tables being joined?

Accepted Answer

INNER JOIN

Question 8

8. Which SQL clause is used to filter grouped rows in a SELECT query?

Accepted Answer

HAVING

Question 9

5. Which SQL statement is used to modify existing data in a table?

Accepted Answer

UPDATE

Question 10

9. What SQL clause is used to sort the result set of a SELECT query in ascending or descending order?

Accepted Answer

ORDER BY

Question 11

3. Which SQL statement is used to add a new column to an existing table?

Accepted Answer

ALTER TABLE

Question 12

13. What is the purpose of the SQL UNION operator?

Accepted Answer

Select distinct rows from two or more SELECT statements

Question 13

1. Which SQL statement is used to create a new database table?

Accepted Answer

CREATE

Question 14

15. What is the purpose of the SQL LIMIT clause in a SELECT statement?

Accepted Answer

Set the maximum number of rows to be returned

Question 15

2. What SQL statement is used to remove an existing database table?

Accepted Answer

DROP

Questions 15