Foundations of Coding WGU Preassessment UPDATED
ACTUAL EXAM QUESTIONS AND CORRECT ANSWERS
Question 1.
Which type of SQL statement lets a user access information about a database?
A. FIND
B. LIST
C. SET
D. SHOW
ANSWER
A
Question 2.
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
Question 3.
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 4.
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 5.
What is the component of Python that indicates where a given block of code ends?
A. The "#" symbol
B. Indentation
C. Conditional statement
D. Try-except block
ANSWER
B
Question 6.
A user needs to name the table to be searched. Which SQL keyword is needed?
A. WHERE
B. MARK
C. SHOW
D. FROM
ANSWER
D
Question 7.
Which goal represents a primary objective of code review?
A. Eliminating randomness
B. Consolidating modules
C. Consolidating modules
D. Sharing knowledge
ANSWER
D
, Question 8.
What is a strategy to make hypothesis testing more efficient?
A. Create a hypothesis for each program function
B. Create hypotheses that are likely and easy to test
C. Use the same conditions to test each hypothesis
D. Test a hypothesis asymmetrically when possible
ANSWER
D
Question 9.
How do basic SQL and Python differ?
A. SQL focuses on web applications, but Python does not.
B. SQL is a high-level language, but Python is not.
C. SQL requires data type declarations, but Python does not.
D. SQL supports dynamic typing, but Python does not.
ANSWER
C
Question 10.
What is the name of the architectural component of a database that contains a directory of tables,
columns, indices, and other objects?
A. The transaction manager
B. The query processor
C. The catalog
D. The log
ANSWER
C
Question 11.
Which statement describes how compiled and interpreted languages differ?
A. Compiled languages show results from changes faster.
B. Compiled languages require more frequent translation.
C. Compiled languages require a greater effort to edit.
D. Compiled languages require more memory usage.
ANSWER
C
ACTUAL EXAM QUESTIONS AND CORRECT ANSWERS
Question 1.
Which type of SQL statement lets a user access information about a database?
A. FIND
B. LIST
C. SET
D. SHOW
ANSWER
A
Question 2.
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
Question 3.
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 4.
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 5.
What is the component of Python that indicates where a given block of code ends?
A. The "#" symbol
B. Indentation
C. Conditional statement
D. Try-except block
ANSWER
B
Question 6.
A user needs to name the table to be searched. Which SQL keyword is needed?
A. WHERE
B. MARK
C. SHOW
D. FROM
ANSWER
D
Question 7.
Which goal represents a primary objective of code review?
A. Eliminating randomness
B. Consolidating modules
C. Consolidating modules
D. Sharing knowledge
ANSWER
D
, Question 8.
What is a strategy to make hypothesis testing more efficient?
A. Create a hypothesis for each program function
B. Create hypotheses that are likely and easy to test
C. Use the same conditions to test each hypothesis
D. Test a hypothesis asymmetrically when possible
ANSWER
D
Question 9.
How do basic SQL and Python differ?
A. SQL focuses on web applications, but Python does not.
B. SQL is a high-level language, but Python is not.
C. SQL requires data type declarations, but Python does not.
D. SQL supports dynamic typing, but Python does not.
ANSWER
C
Question 10.
What is the name of the architectural component of a database that contains a directory of tables,
columns, indices, and other objects?
A. The transaction manager
B. The query processor
C. The catalog
D. The log
ANSWER
C
Question 11.
Which statement describes how compiled and interpreted languages differ?
A. Compiled languages show results from changes faster.
B. Compiled languages require more frequent translation.
C. Compiled languages require a greater effort to edit.
D. Compiled languages require more memory usage.
ANSWER
C
