WGU C170 BASIC SQL EXAM WITH 100%
CORRECT AND VERIFIED ANSWERS
Correct
Incorrect
Your answers
1 of 99
Term
A common practice is to create a(n) on any field that
is used as a search key, in comparison operations in a
conditional expression, or when a user wants to list rows in a
specific order.
Give this one a try later!
VIEW TRIGGER
INDEX SEQUENCE
Don't know?
2 of 99
Term
,Which of the following queries will output the table
contents when the value of P_PRICE is less than or equal
to 10?
Give this one a try later!
"SELECT P_DESCRIPT,
"SELECT P_DESCRIPT, P_INDATE, P_INDATE, P_PRICE, V_CODE
P_PRICE, V_CODE FROM FROM PRODUCT WHERE
PRODUCT WHERE P_PRICE < 5;" P_PRICE <= 10;"
"SELECT P_DESCRIPT, P_INDATE,
"SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM
P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE =
PRODUCT WHERE V_CODE <> 21344 OR V_CODE = 24288;"
21344;"
Don't know?
3 of 99
Term
The CHECK constraint is used to define a condition for the
values that the attribute domain cannot have.
Give this one a try later!
FALSE Oracle
ALIAS DELETE
Don't know?
, 4 of 99
Term
The special operator used to check whether an attribute
value matches a given string pattern is
Give this one a try later!
LIKE EQUALS
CONTAINS MATCHES
Don't know?
5 of 99
Term
A table can be deleted from the database by using the
command.
Give this one a try later!
RENAME TABLE ALTER TABLE
DROP TABLE UPDATE TABLE
Don't know?
, 6 of 99
Term
The SQL aggregate function that gives the number
of rows containing non-null values for a given
column is .
Give this one a try later!
AVG COUNT
MAX SUM
Don't know?
7 of 99
Term
The special operator used to check whether an attribute
value is within a range of values is
Give this one a try later!
Boolean UNIQUE
FALSE BETWEEN
Don't know?
CORRECT AND VERIFIED ANSWERS
Correct
Incorrect
Your answers
1 of 99
Term
A common practice is to create a(n) on any field that
is used as a search key, in comparison operations in a
conditional expression, or when a user wants to list rows in a
specific order.
Give this one a try later!
VIEW TRIGGER
INDEX SEQUENCE
Don't know?
2 of 99
Term
,Which of the following queries will output the table
contents when the value of P_PRICE is less than or equal
to 10?
Give this one a try later!
"SELECT P_DESCRIPT,
"SELECT P_DESCRIPT, P_INDATE, P_INDATE, P_PRICE, V_CODE
P_PRICE, V_CODE FROM FROM PRODUCT WHERE
PRODUCT WHERE P_PRICE < 5;" P_PRICE <= 10;"
"SELECT P_DESCRIPT, P_INDATE,
"SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM
P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE =
PRODUCT WHERE V_CODE <> 21344 OR V_CODE = 24288;"
21344;"
Don't know?
3 of 99
Term
The CHECK constraint is used to define a condition for the
values that the attribute domain cannot have.
Give this one a try later!
FALSE Oracle
ALIAS DELETE
Don't know?
, 4 of 99
Term
The special operator used to check whether an attribute
value matches a given string pattern is
Give this one a try later!
LIKE EQUALS
CONTAINS MATCHES
Don't know?
5 of 99
Term
A table can be deleted from the database by using the
command.
Give this one a try later!
RENAME TABLE ALTER TABLE
DROP TABLE UPDATE TABLE
Don't know?
, 6 of 99
Term
The SQL aggregate function that gives the number
of rows containing non-null values for a given
column is .
Give this one a try later!
AVG COUNT
MAX SUM
Don't know?
7 of 99
Term
The special operator used to check whether an attribute
value is within a range of values is
Give this one a try later!
Boolean UNIQUE
FALSE BETWEEN
Don't know?
