WGU C170 BASIC SQL QUESTIONS AND ANSWERS

WGU C170 BASIC SQL 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

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

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

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