WGU C170 Basic SQL and Advanced SQL| WITH COMPLETE SOLUTIONS
4 keer bekeken 0 keer verkocht
Vak
WGU C170
Instelling
Western Governors University
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. Correct Answer: recursive
The ___________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. Correct Answer: join
A da...
wgu c170 basic sql and advanced sql| with complete solutions
Geschreven voor
Western Governors University
WGU C170
Alle documenten voor dit vak (87)
Verkoper
Volgen
Classroom
Ontvangen beoordelingen
Voorbeeld van de inhoud
WGU C170 Basic SQL and Advanced SQL| WITH
COMPLETE SOLUTIONS
An alias is especially useful when a table must be joined to itself in a(n) ___________________
query. Correct Answer: recursive
The ___________ condition is generally composed of an equality comparison between the
foreign key and the primary key of related tables. Correct Answer: join
A database language enables the user to create database and table structures to perform basic
data management chores. Correct Answer: TRUE
______________________ is the process the DBMS uses to verify that only registered users
access the database. Correct Answer: Authentication
Only numeric data types can be added and subtracted in SQL. Correct Answer: FALSE
A table can be deleted from the database by using the _______________________ command.
Correct Answer: DROP TABLE
To list all the contents of the PRODUCT table, a user would use
________________________________ Correct Answer: SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. Correct Answer: FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. Correct
Answer: FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query.
Correct 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
________________________________________________ Correct 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. Correct
Answer: query
The SQL aggregate function that gives the total of all values for a selected attribute in a given
column is _______ Correct Answer: SUM
String comparisons are made from left to right. Correct Answer: TRUE
, Date procedures are often more software-specific than other SQL procedures. Correct Answer:
TRUE
To make the output more readable, the SQL standard permits the use of aliases for any column in
a _____________ statement. Correct 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. Correct
Answer: cascading
Data type selection is usually dictated by the nature of the data and by the intended use. Correct
Answer: TRUE
The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07.
Correct 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. Correct 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? Correct 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. Correct Answer: TRUE
DATE() and SYSDATE are special functions that return today's date in MS Access and
__________________, respectively. Correct 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? Correct 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.
Correct Answer: ROLLBACK;
According to the rules of precedence, which of the following computations should be completed
first? Correct 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? Correct Answer: "SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT WHERE V_CODE = 21344;"
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
√ Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, Bancontact of creditcard voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper Classroom. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €8,05. Je zit daarna nergens aan vast.
