FOUNDATIONS OF CODING WGU PREASSESSMENT
FREQUENTLY TESTED ACTUAL EXAM QUESTIONS WITH
CORRECT ANSWERS
Question 1.
Relational Operations
ANSWER
Columns:
Project: Selects columns of a table Join: Combines two tables by joining columns
Rows:
Select: Selects a subset or all rows Difference: Selects rows in 1 table and not the other
Intersect: Selects rows common to 2 tables
Union: Selects all rows of 2 tables Product: List all combos of rows of 2 tables
Aggregate: Computes functions over multiple table rows (SUM, COUNT)
Question 2.
Storage Manager
ANSWER
Translates instructions into low-level file-system commands that modify or retrieve data.
Question 3.
What is the part of a database that translates request instructions into low-level, file-system
commands?
A. The log
B. The query processor
C. The transaction manager
D. The storage manager
ANSWER
D
,Question 4.
Compiled Language
ANSWER
Faster to write, but harder to edit (have to recompile the entire thing after changes). Not
portable.
Question 5.
Catalog
ANSWER
AKA Data dictionary (tables, columns, indexes, etc.)
Question 6.
What is the relationship between programming and scripting languages?
A. Scripting languages are compiled forms of programming languages.
B. Scripting languages represent a subgroup of programming languages.
C. Scripting languages form the basis of programming languages.
D. Scripting languages interpret programming language instructions.
ANSWER
B
Question 7.
What is the part of a database that stores information about updates, removals, and insertions that
have been processed?
A. The storage manager
B. The log
C. The transaction manager
D. The query processor
ANSWER
C
, Question 8.
DML
ANSWER
Data Manipulation Language (DML). Manipulates data stored i a database.
"INSERT,"-Add new data to table (row)
UPDATE,"-modify data in a table (column)
"DELETE"-rows
Question 9.
DDL
ANSWER
Data Definition Language (DDL) describes the structure of a database. ("CREATE," "ALTER,"
"DROP")
Question 10.
Which purpose does a class have in Python?
A. It represents an ordered collection of items. B. It represents a template for the creation of an object.
C. It stores a collection of key-value pairs.
D. It stores a single data value, such as an integer.
ANSWER
B
Question 11.
What should be done to avoid introducing new problems when troubleshooting?
A. Test changes iteratively
B. Conduct testing with limited inputs
C. Develop multiple hypotheses
D. Use symmetric and asymmetric tests
ANSWER
A
FREQUENTLY TESTED ACTUAL EXAM QUESTIONS WITH
CORRECT ANSWERS
Question 1.
Relational Operations
ANSWER
Columns:
Project: Selects columns of a table Join: Combines two tables by joining columns
Rows:
Select: Selects a subset or all rows Difference: Selects rows in 1 table and not the other
Intersect: Selects rows common to 2 tables
Union: Selects all rows of 2 tables Product: List all combos of rows of 2 tables
Aggregate: Computes functions over multiple table rows (SUM, COUNT)
Question 2.
Storage Manager
ANSWER
Translates instructions into low-level file-system commands that modify or retrieve data.
Question 3.
What is the part of a database that translates request instructions into low-level, file-system
commands?
A. The log
B. The query processor
C. The transaction manager
D. The storage manager
ANSWER
D
,Question 4.
Compiled Language
ANSWER
Faster to write, but harder to edit (have to recompile the entire thing after changes). Not
portable.
Question 5.
Catalog
ANSWER
AKA Data dictionary (tables, columns, indexes, etc.)
Question 6.
What is the relationship between programming and scripting languages?
A. Scripting languages are compiled forms of programming languages.
B. Scripting languages represent a subgroup of programming languages.
C. Scripting languages form the basis of programming languages.
D. Scripting languages interpret programming language instructions.
ANSWER
B
Question 7.
What is the part of a database that stores information about updates, removals, and insertions that
have been processed?
A. The storage manager
B. The log
C. The transaction manager
D. The query processor
ANSWER
C
, Question 8.
DML
ANSWER
Data Manipulation Language (DML). Manipulates data stored i a database.
"INSERT,"-Add new data to table (row)
UPDATE,"-modify data in a table (column)
"DELETE"-rows
Question 9.
DDL
ANSWER
Data Definition Language (DDL) describes the structure of a database. ("CREATE," "ALTER,"
"DROP")
Question 10.
Which purpose does a class have in Python?
A. It represents an ordered collection of items. B. It represents a template for the creation of an object.
C. It stores a collection of key-value pairs.
D. It stores a single data value, such as an integer.
ANSWER
B
Question 11.
What should be done to avoid introducing new problems when troubleshooting?
A. Test changes iteratively
B. Conduct testing with limited inputs
C. Develop multiple hypotheses
D. Use symmetric and asymmetric tests
ANSWER
A
