1Z0-006 Basic SQL Statements 2

Question 1

Which clause in a SELECT statement is used to filter rows AFTER grouping has been applied?

Accepted Answer

HAVING

Answer

HAVING filters groups after GROUP BY aggregation, while WHERE filters individual rows before grouping.

Question 2

What does the DISTINCT keyword do in a SELECT statement?

Accepted Answer

Removes duplicate rows from the result set

Answer

SELECT DISTINCT eliminates duplicate rows so each unique combination of selected column values appears only once.

Question 3

Which SQL statement is used to add new rows to a table?

Accepted Answer

INSERT

Answer

INSERT INTO is the SQL statement used to add one or more new rows of data into a table.

Question 4

In a SELECT statement, what is the correct order of clauses?

Accepted Answer

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY

Answer

The standard clause order is SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

Question 5

What happens when you use UPDATE without a WHERE clause?

Accepted Answer

All rows in the table are updated

Answer

An UPDATE without WHERE updates every row in the table with the specified new values.

(1Z0-006) Oracle Database Foundations Associate Practice Test