Actual WGU Data Management - Foundations - D426 2024

Actual WGU Data Management -
Foundations - D426 2024
1 .Which property is enforced by a primary key field?



Not Null

Null

Duplicate

Numeric

Not Null




2 . Which property or function allows SQL to insert a field value?



Composite

Simple

Auto-increment

Numeric

Auto-increment




3. Which property specifies an expression on one or more columns of a table?



CHECK

RESTRICT

CASCADE

UNIQUE

CHECK

,4. Which type of key is a single column in a table used to identify a row?



Super key

Simple primary key

Foreign key

Composite primary key

Simple primary key




5. Which type of key is often represented by parentheses to show multiple columns?



Composite

Simple

Unique

Foreign

Composite




6. Which primary key characteristic means it includes information that is easy to type and store?



Non-null

Meaningless

Stable

Simple

Simple

,7 . Which part of a junction table in a relational database establishes a many-to-many relationship
between two tables?



Primary key

Foreign key

Composite key

Candidate key

Foreign key




8. Which type of relationship is established by a foreign key in a relational database?



Aggregation

Composition

One-to-many

Many-to-many

One-to-many




9. Which statements may be rejected when a foreign key constraint is specified?



INSERT

CHECK

SELECT

ORDER BY

INSERT




42. Which key describes the unique columns in a table that do not contain a primary key?

, Foreign key

Simple key

Candidate key

Composite key

Candidate key




43. Which index stores column values and row pointers in a hierarchy?



Dense index

Sparse index

Multi-level index

Secondary index

Multi-level index




44. Which type of index refers to entries that are assigned to buckets?



Bitmap index

Logical index

Hash index

Secondary index

Hash index




45. Which type of index is a grid of bits where each index row corresponds to a unique row in a table?



Multi-level index