WGU D426 Pre- Assessment (Latest 2023/ 2023 Update) Data Management Foundations Exam| Questions and Verified Answers|100% Correct| Grade A

WGU D426 Pre- Assessment (Latest 2023/

2023 Update) Data Management Foundations

Exam| Questions and Verified Answers|100%

Correct| Grade A

Q: What is another name for a subquery?

Answer:

Nested query

Q: Which operator is used to compare against a list of values when determining a match in a

WHERE clause?

Answer:

IN

Q: Which wildcard character is used to represent zero or more characters when searching for a

specified pattern using a LIKE operator?

Answer:

%

Q: Which function is considered an aggregating function in SQL?

Answer:

MIN

Q: Which clause or function is used with aggregate functions to produce summary rows?

Answer:

GROUP BY

Q: Which type of join returns only the matching values when selecting rows from two or more

tables?

Answer:

Inner Join

Q: Which join type selects only matching left and right table rows?

Answer:

Inner Join

Q: Which phrase refers to the view in which data is persisted and is automatically changed as

the underlying data is changed?

Answer:

Materialized View

Q: Which SQL command uses the correct syntax to update the salary of an employee in the

Employee table?

Answer:

UPDATE Employee SET Salary = 50000 WHERE ID = 1;

Q: What describes elements such as column name and data type?