Which SQL statement is used to add a new row to a table?
Correct!
Wrong!
The INSERT statement adds one or more rows to a database table.
To modify existing data in a table, you would use the _____ statement:
Correct!
Wrong!
UPDATE alters the values of columns for rows that meet the WHERE condition.
Which clause filters rows returned by a SELECT query based on a condition?
Correct!
Wrong!
The WHERE clause restricts result sets by evaluating Boolean expressions.
The SQL wildcard character that substitutes for any sequence of characters in a LIKE pattern is:
Correct!
Wrong!
The percent sign (%) matches zero or more characters in pattern matching.
Which function returns the number of rows in a group or entire table?
Correct!
Wrong!
COUNT(*) tallies all rows, including those with NULLs.
To remove all rows from a table quickly while preserving its structure, use:
Correct!
Wrong!
TRUNCATE TABLE deallocates data pages and resets high-water marks.
Loading Questions...
What keyword specifies an alias for a column in the SELECT list?
Correct!
Wrong!
The AS keyword (optional) assigns a temporary name to the result column.
A subquery enclosed in parentheses that returns a single value used in an outer query is called:
Correct!
Wrong!
A scalar subquery yields one row and one column to supply a value.
Which operator combines the results of two SELECT statements and removes duplicates?
Correct!
Wrong!
UNION merges result sets and eliminates duplicate rows by default.