,WGUD427/WGU D427 | Data
Management Applications | OA Prep |
2026/2027 Edition (PDF)
**1. What is the definition of a database schema?**
A) The actual data stored in a database
B) The structure and organization of a database, including tables, columns, and relationships
C) A collection of related tables
D) A query that retrieves data from a database
Correct Answer: B) The structure and organization of a database, including tables, columns, and
relationships
Rationale: The schema defines how data in a database will be organized. It includes the tables, columns,
data types, constraints, and relationships. The actual data is the instance, not the schema.
**2. What does the acronym CRUD stand for in database management?**
A) Create, Read, Update, Delete
B) Connect, Retrieve, Upload, Download
C) Code, Run, Utilize, Debug
D) Create, Restore, Update, Destroy
Correct Answer: A) Create, Read, Update, Delete
Rationale: CRUD represents the four basic operations for interacting with a database. These correspond
to SQL commands: INSERT (Create), SELECT (Read), UPDATE, and DELETE.
**3. Which of the following is a characteristic of a relational database?**
A) Data is stored in a hierarchical structure
,B) Data is organized into tables with rows and columns
C) Data is stored as key-value pairs
D) Data is stored in XML format
Correct Answer: B) Data is organized into tables with rows and columns
Rationale: Relational databases organize data into tables (relations) consisting of rows (tuples) and
columns (attributes). Each row represents a record, and each column represents a field.
**4. In a relational database, what is a primary key?**
A) A column that uniquely identifies each row in a table
B) A column that references another table
C) A column that can contain duplicate values
D) A column that is always an integer
Correct Answer: A) A column that uniquely identifies each row in a table
Rationale: A primary key is a column (or set of columns) that uniquely identifies each row in a table. It
must contain unique values and cannot contain NULL values. Foreign keys reference primary keys in
other tables.
**5. What is a foreign key in a relational database?**
A) A column that uniquely identifies each row
B) A column that references the primary key of another table
C) A column that is used for indexing only
D) A column that can never be NULL
Correct Answer: B) A column that references the primary key of another table
, Rationale: A foreign key is a column in one table that references the primary key of another table. It
establishes a relationship between tables and enforces referential integrity.
**6. Which of the following best describes normalization?**
A) The process of denormalizing data for faster queries
B) The process of organizing data to reduce redundancy and improve data integrity
C) The process of encrypting data for security
D) The process of creating indexes on tables
Correct Answer: B) The process of organizing data to reduce redundancy and improve data integrity
Rationale: Normalization is the process of organizing data in a database to reduce data redundancy and
improve data integrity. It involves breaking down large tables into smaller, related tables and defining
relationships between them.
**7. A table is in First Normal Form (1NF) if:**
A) It has no transitive dependencies
B) It has no partial dependencies
C) All columns contain atomic (indivisible) values
D) All non-key columns are fully dependent on the entire primary key
Correct Answer: C) All columns contain atomic (indivisible) values
Rationale: 1NF requires that each column contains atomic values (no repeating groups or arrays). 2NF
requires 1NF plus no partial dependencies (all non-key columns fully dependent on the entire primary
key). 3NF requires 2NF plus no transitive dependencies.
**8. Second Normal Form (2NF) requires:**
A) 1NF plus no transitive dependencies
B) 1NF plus no partial dependencies
Management Applications | OA Prep |
2026/2027 Edition (PDF)
**1. What is the definition of a database schema?**
A) The actual data stored in a database
B) The structure and organization of a database, including tables, columns, and relationships
C) A collection of related tables
D) A query that retrieves data from a database
Correct Answer: B) The structure and organization of a database, including tables, columns, and
relationships
Rationale: The schema defines how data in a database will be organized. It includes the tables, columns,
data types, constraints, and relationships. The actual data is the instance, not the schema.
**2. What does the acronym CRUD stand for in database management?**
A) Create, Read, Update, Delete
B) Connect, Retrieve, Upload, Download
C) Code, Run, Utilize, Debug
D) Create, Restore, Update, Destroy
Correct Answer: A) Create, Read, Update, Delete
Rationale: CRUD represents the four basic operations for interacting with a database. These correspond
to SQL commands: INSERT (Create), SELECT (Read), UPDATE, and DELETE.
**3. Which of the following is a characteristic of a relational database?**
A) Data is stored in a hierarchical structure
,B) Data is organized into tables with rows and columns
C) Data is stored as key-value pairs
D) Data is stored in XML format
Correct Answer: B) Data is organized into tables with rows and columns
Rationale: Relational databases organize data into tables (relations) consisting of rows (tuples) and
columns (attributes). Each row represents a record, and each column represents a field.
**4. In a relational database, what is a primary key?**
A) A column that uniquely identifies each row in a table
B) A column that references another table
C) A column that can contain duplicate values
D) A column that is always an integer
Correct Answer: A) A column that uniquely identifies each row in a table
Rationale: A primary key is a column (or set of columns) that uniquely identifies each row in a table. It
must contain unique values and cannot contain NULL values. Foreign keys reference primary keys in
other tables.
**5. What is a foreign key in a relational database?**
A) A column that uniquely identifies each row
B) A column that references the primary key of another table
C) A column that is used for indexing only
D) A column that can never be NULL
Correct Answer: B) A column that references the primary key of another table
, Rationale: A foreign key is a column in one table that references the primary key of another table. It
establishes a relationship between tables and enforces referential integrity.
**6. Which of the following best describes normalization?**
A) The process of denormalizing data for faster queries
B) The process of organizing data to reduce redundancy and improve data integrity
C) The process of encrypting data for security
D) The process of creating indexes on tables
Correct Answer: B) The process of organizing data to reduce redundancy and improve data integrity
Rationale: Normalization is the process of organizing data in a database to reduce data redundancy and
improve data integrity. It involves breaking down large tables into smaller, related tables and defining
relationships between them.
**7. A table is in First Normal Form (1NF) if:**
A) It has no transitive dependencies
B) It has no partial dependencies
C) All columns contain atomic (indivisible) values
D) All non-key columns are fully dependent on the entire primary key
Correct Answer: C) All columns contain atomic (indivisible) values
Rationale: 1NF requires that each column contains atomic values (no repeating groups or arrays). 2NF
requires 1NF plus no partial dependencies (all non-key columns fully dependent on the entire primary
key). 3NF requires 2NF plus no transitive dependencies.
**8. Second Normal Form (2NF) requires:**
A) 1NF plus no transitive dependencies
B) 1NF plus no partial dependencies
