1Z0-006 SQL Fundamentals & Data Manipulation

Question 1

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

Accepted Answer

INSERT

Answer

UPDATE

Answer

MERGE

Answer

ALTER

Question 2

To modify existing data in a table, you would use the _____ statement:

Accepted Answer

UPDATE

Answer

DELETE

Answer

SELECT

Answer

TRUNCATE

Question 3

Which clause filters rows returned by a SELECT query based on a condition?

Accepted Answer

WHERE

Answer

GROUP BY

Answer

ORDER BY

Answer

HAVING

Question 4

The SQL wildcard character that substitutes for any sequence of characters in a LIKE pattern is:

Accepted Answer

%

Answer

_

Answer

#

Answer

*

Question 5

Which function returns the number of rows in a group or entire table?

Accepted Answer

COUNT()

Answer

SUM()

Answer

MAX()

Answer

AVG()

Question 6

To remove all rows from a table quickly while preserving its structure, use:

Accepted Answer

TRUNCATE TABLE

Answer

DELETE with no WHERE

Answer

DROP TABLE

Answer

ALTER TABLE

Question 7

What keyword specifies an alias for a column in the SELECT list?

Accepted Answer

AS

Answer

LIKE

Answer

INTO

Answer

BY

Question 8

A subquery enclosed in parentheses that returns a single value used in an outer query is called:

Accepted Answer

Scalar subquery

Answer

Correlated subquery

Answer

Inline view

Answer

Set operator

Question 9

Which operator combines the results of two SELECT statements and removes duplicates?

Accepted Answer

UNION

Answer

UNION ALL

Answer

INTERSECT

Answer

MINUS