1-
|
In an SQL query, which SQL keyword is used with GROUP BY to select groups meeting specified
criteria?
|
|
A -
|
AND
|
|
B -
|
EXISTS
|
|
C -
|
HAVING
|
|
D -
|
WHERE
|
2-
|
Which SQL keyword is used to name a new table and describe the table's columns?
|
|
A -
|
SET
|
|
B -
|
CREATE
|
|
C -
|
ALTER
|
|
D -
|
MODIFY
|
3-
|
In an SQL query, which SQL keyword must be used to remove duplicate rows from the result table?
|
|
A -
|
DELETE
|
|
B -
|
DISTINCT
|
|
C -
|
NOT EXISTS
|
|
D -
|
UNIQUE
|
4-
|
In an SQL query, the built-in function COUNT works with columns containing data of which of the
following data types?
|
|
A -
|
Integer
|
|
B -
|
Numeric
|
|
C -
|
Char
|
|
D -
|
All of these answers.
|
5-
|
If the table PRODUCT has a column PRICE that has the data type Numeric (8,2), the values stored for
this attribute will be stored .
|
|
A -
|
as eight digits, a decimal point, and two more digits
|
|
B -
|
as ten digits with no stored decimal point
|
|
C -
|
as eight digits with no stored decimal point
|
|
D -
|
as six digits with no stored decimal point
|
6-
|
In an SQL query, which built-in function is used to obtain the largest value of numeric columns?
|
|
A -
|
AVG
|
|
B -
|
COUNT
|
|
C -
|
MAX
|
|
D -
|
MIN
|
7-
|
In an SQL query, which SQL keyword is used to specify the names of tables to be joined?
|
|
A -
|
FROM
|
|
B -
|
HAVING
|
|
C -
|
JOIN
|
|
D -
|
SELECT
|
8-
|
In an SQL query, which built-in function is used to compute the average value of numeric columns?
|
|
A -
|
AVG
|
|
B -
|
MEAN
|
|
C -
|
MIN
|
|
D -
|
SUM
|
9-
|
When one SQL query is embedded in the WHERE clause of another SQL query, this is referred to as a
__________.
|
|
A -
|
join
|
|
B -
|
WHERE Query
|
|
C -
|
subquery
|
|
D -
|
set query
|
10-
|
In an SQL query, which SQL keyword is used to implement a subquery?
|
|
A -
|
GROUP BY
|
|
B -
|
HAVING
|
|
C -
|
ORDER BY
|
|
D -
|
SELECT
|