WGU PRE-ASSESSMENT: DATA MANAGEMENT -
APPLICATIONS (FJO1) (PFJO) | 2025/2026
Western Governors University Pre-Assessment Exam with Complete Questions & Verified
Answers | Performance Assessment Aligned
Overview
This 2025/2026 updated resource contains the actual WGU Data Management -
Applications (FJO1/PFJO) Pre-Assessment Exam with the exact 65 questions and
verified answers, following current WGU Computer Science/Data Management curriculum,
Oracle Database standards, and SQL competency requirements.
Key Features
● Actual WGU pre-assessment format with the official 65 questions
● Complete coverage of database design, SQL programming, and data applications
● Performance assessment alignment for FJO1/PFJO course objectives
● Updated 2025/2026 WGU competency requirements and Oracle/SQL standards
● Practical SQL queries and database problem-solving scenarios
Core Content Areas (65 Total Questions)
Database Design & Normalization (15 Qs)
SQL Data Definition Language (DDL) & Data Manipulation Language (DML)
(20 Qs)
Advanced SQL Queries & Functions (12 Qs)
Transaction Management & Concurrency Control (8 Qs)
Database Security & Administration (6 Qs)
Data Warehousing & Business Intelligence Concepts (4 Qs)
Answer Format
,Correct answers are marked in bold green and include:
● Complete SQL code solutions with syntax explanations
● ERD to relational schema conversion examples
● Normalization process demonstrations (1NF through BCNF)
● Transaction ACID property applications
● Query optimization techniques and indexing strategies
Updates for 2025/2026
Reflects 2025-2026 WGU Data Management curriculum revisions
Updated Oracle Database 21c/23c features and syntax
Enhanced NoSQL and cloud database integration concepts
New GDPR/CCPA compliance requirements for data management
Revised SQL performance tuning and optimization standards
Added emphasis on data ethics and responsible AI/data practices
Updated data visualization and reporting requirements
Question 1
Which normal form eliminates partial functional dependencies?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Rationale: Second Normal Form (2NF) requires that a table be in 1NF and that all non-key
attributes are fully functionally dependent on the entire primary key, eliminating partial
dependencies. This is essential when the primary key is composite.
,Question 2
Which SQL statement correctly creates a table named EMPLOYEE with columns ID (integer,
primary key), NAME (varchar, not null), and DEPT_ID (integer)?
A. CREATE TABLE EMPLOYEE (ID INT, NAME VARCHAR(50), DEPT_ID INT PRIMARY
KEY);
B. CREATE TABLE EMPLOYEE (ID INT PRIMARY KEY, NAME VARCHAR(50)
NOT NULL, DEPT_ID INT);
C. CREATE EMPLOYEE TABLE (ID INTEGER PRIMARY KEY, NAME VARCHAR(50) NOT
NULL, DEPT_ID INTEGER);
D. CREATE TABLE EMPLOYEE AS (ID INT PRIMARY KEY, NAME VARCHAR(50),
DEPT_ID INT);
Rationale: The correct DDL syntax is CREATE TABLE table_name (column definitions). Option
B correctly defines ID as the primary key, NAME as NOT NULL, and uses standard SQL data
types. Option A incorrectly places PRIMARY KEY on DEPT_ID. Option C uses invalid syntax
("CREATE EMPLOYEE TABLE"). Option D uses "AS", which is for CTAS (Create Table As
Select), not for defining structure from scratch.
Question 3
What is the result of the following SQL query?
SELECT COUNT(*) FROM Orders WHERE OrderDate IS NULL;
A. 0
B. An error
C. The number of orders with missing OrderDate
D. NULL
, Rationale: The COUNT(*) function counts all rows, including those with NULL values in any
column. The WHERE clause filters rows where OrderDate IS NULL, so the query returns the
number of orders that have a NULL OrderDate. It does not return NULL or cause an error.
Question 4
Which of the following best describes a foreign key constraint?
A. Ensures all values in a column are unique
B. Prevents NULL values in a column
C. Enforces referential integrity between two tables
D. Automatically increments a numeric value
Rationale: A foreign key constraint enforces referential integrity by ensuring that values in a
column (or set of columns) in one table match values in the primary key or unique key of
another table. This maintains consistency and prevents orphaned records.
Question 5
Which SQL clause is used to filter groups after aggregation?
A. WHERE
B. HAVING
C. HAVING
D. FILTER
APPLICATIONS (FJO1) (PFJO) | 2025/2026
Western Governors University Pre-Assessment Exam with Complete Questions & Verified
Answers | Performance Assessment Aligned
Overview
This 2025/2026 updated resource contains the actual WGU Data Management -
Applications (FJO1/PFJO) Pre-Assessment Exam with the exact 65 questions and
verified answers, following current WGU Computer Science/Data Management curriculum,
Oracle Database standards, and SQL competency requirements.
Key Features
● Actual WGU pre-assessment format with the official 65 questions
● Complete coverage of database design, SQL programming, and data applications
● Performance assessment alignment for FJO1/PFJO course objectives
● Updated 2025/2026 WGU competency requirements and Oracle/SQL standards
● Practical SQL queries and database problem-solving scenarios
Core Content Areas (65 Total Questions)
Database Design & Normalization (15 Qs)
SQL Data Definition Language (DDL) & Data Manipulation Language (DML)
(20 Qs)
Advanced SQL Queries & Functions (12 Qs)
Transaction Management & Concurrency Control (8 Qs)
Database Security & Administration (6 Qs)
Data Warehousing & Business Intelligence Concepts (4 Qs)
Answer Format
,Correct answers are marked in bold green and include:
● Complete SQL code solutions with syntax explanations
● ERD to relational schema conversion examples
● Normalization process demonstrations (1NF through BCNF)
● Transaction ACID property applications
● Query optimization techniques and indexing strategies
Updates for 2025/2026
Reflects 2025-2026 WGU Data Management curriculum revisions
Updated Oracle Database 21c/23c features and syntax
Enhanced NoSQL and cloud database integration concepts
New GDPR/CCPA compliance requirements for data management
Revised SQL performance tuning and optimization standards
Added emphasis on data ethics and responsible AI/data practices
Updated data visualization and reporting requirements
Question 1
Which normal form eliminates partial functional dependencies?
A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
Rationale: Second Normal Form (2NF) requires that a table be in 1NF and that all non-key
attributes are fully functionally dependent on the entire primary key, eliminating partial
dependencies. This is essential when the primary key is composite.
,Question 2
Which SQL statement correctly creates a table named EMPLOYEE with columns ID (integer,
primary key), NAME (varchar, not null), and DEPT_ID (integer)?
A. CREATE TABLE EMPLOYEE (ID INT, NAME VARCHAR(50), DEPT_ID INT PRIMARY
KEY);
B. CREATE TABLE EMPLOYEE (ID INT PRIMARY KEY, NAME VARCHAR(50)
NOT NULL, DEPT_ID INT);
C. CREATE EMPLOYEE TABLE (ID INTEGER PRIMARY KEY, NAME VARCHAR(50) NOT
NULL, DEPT_ID INTEGER);
D. CREATE TABLE EMPLOYEE AS (ID INT PRIMARY KEY, NAME VARCHAR(50),
DEPT_ID INT);
Rationale: The correct DDL syntax is CREATE TABLE table_name (column definitions). Option
B correctly defines ID as the primary key, NAME as NOT NULL, and uses standard SQL data
types. Option A incorrectly places PRIMARY KEY on DEPT_ID. Option C uses invalid syntax
("CREATE EMPLOYEE TABLE"). Option D uses "AS", which is for CTAS (Create Table As
Select), not for defining structure from scratch.
Question 3
What is the result of the following SQL query?
SELECT COUNT(*) FROM Orders WHERE OrderDate IS NULL;
A. 0
B. An error
C. The number of orders with missing OrderDate
D. NULL
, Rationale: The COUNT(*) function counts all rows, including those with NULL values in any
column. The WHERE clause filters rows where OrderDate IS NULL, so the query returns the
number of orders that have a NULL OrderDate. It does not return NULL or cause an error.
Question 4
Which of the following best describes a foreign key constraint?
A. Ensures all values in a column are unique
B. Prevents NULL values in a column
C. Enforces referential integrity between two tables
D. Automatically increments a numeric value
Rationale: A foreign key constraint enforces referential integrity by ensuring that values in a
column (or set of columns) in one table match values in the primary key or unique key of
another table. This maintains consistency and prevents orphaned records.
Question 5
Which SQL clause is used to filter groups after aggregation?
A. WHERE
B. HAVING
C. HAVING
D. FILTER
