WGU
WGU Data Management - Foundations
Q1:
Which capability should databases maintain to simplify the use of SQL with a general-purpose language?
○
A
The storage manager to interpret low-level file-system commands○
B
The ability to reverse results if needed○
C
The query processor to deliver results○
D
The use of an application programming interface
WGU
WGU Data Management - Foundations
Q2:
Which statement uses valid syntax for the DELETE statement in SQL?
○
A
DELETE table_name WHERE condition;○
B
DELETE FROM table_name WHERE condition;○
C
DELETE FROM table_name;○
D
DELETE * FROM table_name WHERE condition;
WGU
WGU Data Management - Foundations
Q3:
Which statement is associated with two separate entities?
○
A
Reflexive relationship○
B
Entity type○
C
Relationship○
D
Attribute
WGU
WGU Data Management - Foundations
Q4:
Which syntax feature classifies the explicit string, numeric, or binary values used in SQL queries?
○
A
Literals○
B
Comments○
C
Identifiers○
D
Keywords
WGU
WGU Data Management - Foundations
Q5:
Which optional clause is used to reject inserts and updates that do not satisfy the WHERE clause of a view query?
○
A
WITH CHECK OPTION○
B
JOIN VIEWS○
C
MATERIALIZED VIEW○
D
BASE TABLE