WGU C170 Database Management Test Exam Review Questions with all Answers verified for accuracy Updated 2024/2025
5 keer bekeken 0 keer verkocht
Vak
WGU 170
Instelling
WGU 170
WGU C170 Database Management Test Exam Review Questions with all Answers verified for accuracy Updated 2024/2025
The ................ operator could be used in place of INTERSECT if the DBMS does not support it. - correct answer IN
The ................__ operator could be used in place of MIN...
WGU C170 Database Management Test Exam
Review Questions with all Answers verified for
accuracy Updated 2024/2025
The ................ operator could be used in place of INTERSECT if the DBMS does not
support it. - correct answer IN
The ................__ operator could be used in place of MINUS if the DBMS does not
support it. - correct answer NOT IN
The ................................___ statement combines the output of two SELECT queries
and returns all results common to both queries. - correct answer INTERSECT
A(n) ................................................_ query can be used to produce a relation that
retains the duplicate rows. - correct answer UNION ALL
The ................................................ statement can be used to combine rows from two
queries, returning only the rows that appear in both sets. - correct answer INTERSECT
The syntax of the MINUS statement in Oracle is ................................___. - correct
answer query MINUS query
If the DBMS does not support the INTERSECT statement, one can use
a(n) ................__ subquery to achieve the same result. - correct answer IN
UNION, INTERSECT, and MINUS work properly only if relations are intersect-
compatible, which means that the names of the relation attributes and their data types
must be different. - correct answer False
A(n) ................................................__ view is a view that can be used to update
attributes in the base tables that are used in the view. - correct answer updatable
, A(n) ................................................___ routine pools multiple transactions into a single
batch to update a master table field in a single operation. - correct answer batch
update
In which two ways can data redundancy affect managing disk space and calculation
speed? - correct answer Additional proccessing time is needed to udate redundant
data
Redundant data takes up disk space
With which command can a database admin allow a user named Mary to query the
Patient table by executing SELECT commands on it - correct answer GRANT SELECT
ON PATIENT TO 'Mary' @ 'localhost'
What does the WHERE identify in basic SQL SELECT statement - correct answer The
rows to be included in the result set
Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an
INSERT statement - correct answer The VALUES list must contain a value for each
attribute/column in the table
Which method creates an empty copy of a table and then populates it from the original
table? - correct answer CREATE TABLE newTableName LIKE tableName INSERT
INTO newTableName SELECT * FROM tableName;
ALTER TABLE tableName action [, action] ...;
What does this syntax allow? - correct answer Changing column types
Dropping indexes
What is the proper command to change a view? - correct answer ALTER VIEW
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, creditcard of Stuvia-tegoed 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 KieranKent55. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor $11.49. Je zit daarna nergens aan vast.