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
00:59
01:12
A database...
an alias is especially useful when a table must be joined to itself in an query
the condition is generally composed of an equality comp
Written for
WGU C170
All documents for this subject (500)
Seller
Follow
EvaTee
Reviews received
Content preview
WGU C170 Basic SQL
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller EvaTee. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
