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...
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
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 Layer. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.99. You're not tied to anything after your purchase.
