WGU C170 COMPLETE LATEST BASIC
SQL BASED QUESTIONS AND
ANSWERS
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. -
ANSWER-recursive
The ___________ condition is generally composed of an equality comparison between the foreign key
and the primary key of related tables. - ANSWER-join
A database language enables the user to create database and table structures to perform basic data
management chores. - ANSWER-TRUE
______________________ is the process the DBMS uses to verify that only registered users access the
database. - ANSWER-Authentication
Only numeric data types can be added and subtracted in SQL. - ANSWER-FALSE
A table can be deleted from the database by using the _______________________ command. -
ANSWER-DROP TABLE
To list all the contents of the PRODUCT table, a user would use ________________________________ -
ANSWER-SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. - ANSWER-FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. - ANSWER-
FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query. - ANSWER-
subquery
"The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,
V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE
match is ________________________________________________ - ANSWER-"SELECT P_DESCRIPT,
P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE
PRODUCT.V_CODE = VENDOR.V_CODE;"
In the SQL environment, the word ___________ covers both questions and actions. - ANSWER-query
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is
_______ - ANSWER-SUM
String comparisons are made from left to right. - ANSWER-TRUE
Date procedures are often more software-specific than other SQL procedures. - ANSWER-TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in a
_____________ statement. - ANSWER-SELECT
A(n) _________________ order sequence is a multilevel ordered sequence that can be created easily by
listing several attributes, separated by commas, after the ORDER BY clause. - ANSWER-cascading
Data type selection is usually dictated by the nature of the data and by the intended use. - ANSWER-
TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07. - ANSWER-
FALSE
The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often
used in conjunction with the DISTINCT clause. - ANSWER-TRUE
Which of the following queries will use the given columns and column aliases from the PRODUCT table
to determine the total value of inventory held on hand? - ANSWER-"SELECT P_DESCRIPT, P_QOH,
P_PRICE, P_QOH*P_PRICE FROM PRODUCT;"
, A database language enables the user to perform complex queries designed to transform the raw data
into useful information. - ANSWER-TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively. - ANSWER-Oracle
Which of the following queries will output the table contents when the value of the character field
P_CODE is alphabetically less than 1558-QW1? - ANSWER-"SELECT P_CODE, P_DESCRIPT, P_QOH,
P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';"
The ____________________ command is used to restore the database to its previous condition. -
ANSWER-ROLLBACK;
According to the rules of precedence, which of the following computations should be completed first? -
ANSWER-Performing operations within parentheses
Which of the following queries will output the table contents when the value of V_CODE is equal to
21344? - ANSWER-"SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE
= 21344;"
Using the _____________________________ command, SQL indexes can be created on the basis of any
selected attribute. - ANSWER-CREATE INDEX
A specialty field in mathematics, known as ________________ algebra, is dedicated to the use of logical
operators. - ANSWER-Boolean
"The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table
in ascending order by P_PRICE is ___________________________________________________" -
ANSWER-"SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;"
Most SQL implementations yield case-insensitive searches. - ANSWER-FALSE
The _____________ constraint assigns a value to an attribute when a new row is added to a table. -
ANSWER-DEFAULT
The SQL data manipulation command HAVING:
______________________________________________________. - ANSWER-restricts the selection of
grouped rows based on a condition.
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. - ANSWER-
TRUE
The basic SQL vocabulary has fewer than ______ words. - ANSWER-100
The special operator used to check whether an attribute value is within a range of values is
____________ - ANSWER-BETWEEN
"The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial
is __________________________________________________ - ANSWER-"SELECT EMP_LNAME,
EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME,
EMP_FNAME, EMP_INITIAL;"
In a 1:M relationship, a user must always create the table for the ___ side first. - ANSWER-1
A table can be deleted from the database by using the ___________________________ command. -
ANSWER-DROP TABLE
Which of the following queries will list all the rows in which the inventory stock dates occur on or after
January 20, 2010? - ANSWER-"SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= '20-JAN-2010';"
To remove a row from the PRODUCT table, one must use the ___________________ command. -
ANSWER-DELETE
When a user issues the DELETE FROM tablename command without specifying a WHERE condition,
__________________________. - ANSWER-all rows will be deleted
SQL BASED QUESTIONS AND
ANSWERS
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. -
ANSWER-recursive
The ___________ condition is generally composed of an equality comparison between the foreign key
and the primary key of related tables. - ANSWER-join
A database language enables the user to create database and table structures to perform basic data
management chores. - ANSWER-TRUE
______________________ is the process the DBMS uses to verify that only registered users access the
database. - ANSWER-Authentication
Only numeric data types can be added and subtracted in SQL. - ANSWER-FALSE
A table can be deleted from the database by using the _______________________ command. -
ANSWER-DROP TABLE
To list all the contents of the PRODUCT table, a user would use ________________________________ -
ANSWER-SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. - ANSWER-FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. - ANSWER-
FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query. - ANSWER-
subquery
"The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME,
V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE
match is ________________________________________________ - ANSWER-"SELECT P_DESCRIPT,
P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE
PRODUCT.V_CODE = VENDOR.V_CODE;"
In the SQL environment, the word ___________ covers both questions and actions. - ANSWER-query
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is
_______ - ANSWER-SUM
String comparisons are made from left to right. - ANSWER-TRUE
Date procedures are often more software-specific than other SQL procedures. - ANSWER-TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in a
_____________ statement. - ANSWER-SELECT
A(n) _________________ order sequence is a multilevel ordered sequence that can be created easily by
listing several attributes, separated by commas, after the ORDER BY clause. - ANSWER-cascading
Data type selection is usually dictated by the nature of the data and by the intended use. - ANSWER-
TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07. - ANSWER-
FALSE
The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often
used in conjunction with the DISTINCT clause. - ANSWER-TRUE
Which of the following queries will use the given columns and column aliases from the PRODUCT table
to determine the total value of inventory held on hand? - ANSWER-"SELECT P_DESCRIPT, P_QOH,
P_PRICE, P_QOH*P_PRICE FROM PRODUCT;"
, A database language enables the user to perform complex queries designed to transform the raw data
into useful information. - ANSWER-TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively. - ANSWER-Oracle
Which of the following queries will output the table contents when the value of the character field
P_CODE is alphabetically less than 1558-QW1? - ANSWER-"SELECT P_CODE, P_DESCRIPT, P_QOH,
P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE <'1558-QW1';"
The ____________________ command is used to restore the database to its previous condition. -
ANSWER-ROLLBACK;
According to the rules of precedence, which of the following computations should be completed first? -
ANSWER-Performing operations within parentheses
Which of the following queries will output the table contents when the value of V_CODE is equal to
21344? - ANSWER-"SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE
= 21344;"
Using the _____________________________ command, SQL indexes can be created on the basis of any
selected attribute. - ANSWER-CREATE INDEX
A specialty field in mathematics, known as ________________ algebra, is dedicated to the use of logical
operators. - ANSWER-Boolean
"The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table
in ascending order by P_PRICE is ___________________________________________________" -
ANSWER-"SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;"
Most SQL implementations yield case-insensitive searches. - ANSWER-FALSE
The _____________ constraint assigns a value to an attribute when a new row is added to a table. -
ANSWER-DEFAULT
The SQL data manipulation command HAVING:
______________________________________________________. - ANSWER-restricts the selection of
grouped rows based on a condition.
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. - ANSWER-
TRUE
The basic SQL vocabulary has fewer than ______ words. - ANSWER-100
The special operator used to check whether an attribute value is within a range of values is
____________ - ANSWER-BETWEEN
"The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial
is __________________________________________________ - ANSWER-"SELECT EMP_LNAME,
EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME,
EMP_FNAME, EMP_INITIAL;"
In a 1:M relationship, a user must always create the table for the ___ side first. - ANSWER-1
A table can be deleted from the database by using the ___________________________ command. -
ANSWER-DROP TABLE
Which of the following queries will list all the rows in which the inventory stock dates occur on or after
January 20, 2010? - ANSWER-"SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT
WHERE P_INDATE >= '20-JAN-2010';"
To remove a row from the PRODUCT table, one must use the ___________________ command. -
ANSWER-DELETE
When a user issues the DELETE FROM tablename command without specifying a WHERE condition,
__________________________. - ANSWER-all rows will be deleted