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
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
