Basic SQL Statements Flashcards
7 cards from real 1Z0-006 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Basic SQL Statements flashcards as text
Which clause in a SELECT statement is used to filter rows AFTER grouping has been applied?
Answer: HAVING
HAVING filters groups after GROUP BY aggregation, while WHERE filters individual rows before grouping.
What does the DISTINCT keyword do in a SELECT statement?
Answer: Removes duplicate rows from the result set
SELECT DISTINCT eliminates duplicate rows so each unique combination of selected column values appears only once.
Which SQL statement is used to add new rows to a table?
Answer: INSERT
INSERT INTO is the SQL statement used to add one or more new rows of data into a table.
In a SELECT statement, what is the correct order of clauses?
Answer: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY
The standard clause order is SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
What happens when you use UPDATE without a WHERE clause?
Answer: All rows in the table are updated
An UPDATE without WHERE updates every row in the table with the specified new values.
Which operator in SQL is used to compare a value against a list of values?
Answer: IN
The IN operator checks whether a value matches any value in a specified list, e.g., WHERE dept IN ('HR','IT').
What is the result of: SELECT 10 + NULL FROM DUAL?
Answer: NULL
Any arithmetic operation involving NULL produces NULL because NULL represents an unknown value.