WGU C170 Basic SQL, Top Exam
Questions and answers, 100% Accurate,
graded A+
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query.
recursive
The ___________ conditi
...
WGU C170 Basic SQL, Top Exam
Questions and answers, 100% Accurate,
graded A+
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query.
recursive
The ___________ condition is generally composed of an equality comparison between the foreign key
and the primary key of related tables.
join
A database language enables the user to create database and table structures to perform basic data
management chores.
TRUE
______________________ is the process the DBMS uses to verify that only registered users access the
database.
Authentication
Only numeric data types can be added and subtracted in SQL.
FALSE
A table can be deleted from the database by using the _______________________ command.
DROP TABLE
To list all the contents of the PRODUCT table, a user would use ________________________________
SELECT * FROM PRODUCT
All SQL commands must be issued on a single line.
FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes.
FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query.
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 ________________________________________________
"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.
query
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is
_______
SUM
String comparisons are made from left to right.
TRUE
Date procedures are often more software-specific than other SQL procedures.
TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in a
_____________ statement.
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.
cascading
Data type selection is usually dictated by the nature of the data and by the intended use.
TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07.
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.
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?
"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.
TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively.
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?
"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.
ROLLBACK;
According to the rules of precedence, which of the following computations should be completed first?
Performing operations within parentheses
Which of the following queries will output the table contents when the value of V_CODE is equal to
21344?
"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.
CREATE INDEX
A specialty field in mathematics, known as ________________ algebra, is dedicated to the use of logical
operators.
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 ___________________________________________________"
"SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;"
Most SQL implementations yield case-insensitive searches.
FALSE
The _____________ constraint assigns a value to an attribute when a new row is added to a table.
DEFAULT
The SQL data manipulation command HAVING:
______________________________________________________.
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.
TRUE
The basic SQL vocabulary has fewer than ______ words.
100
The special operator used to check whether an attribute value is within a range of values is
____________
BETWEEN
"The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and
initial is __________________________________________________
"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
[Show More]
.png)
.png)
