Data-Management-Foundations Exam Training Practice Tests (WGU Data Management

Question 1

Which expression can be used to create a temporary name for a table?

A. UNION B. ALIAS C. HAVING D. NEW

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

What is the role of the transaction manager within the database system architecture?

A. The transaction manager uses information from the catalog to perform query optimization. B. The transaction manager logs insert, update, and delete queries, and the result is sent back to the application. C. The transaction manager translates the query processor instructions into filesystem commands and uses an index to quickly locate the requested data. D. The transaction manager is composed of a query processor, storage manager, transaction manager, log, and catalog.

Correct Answer: B

Question 3

Which elements are represented by attributes in the database design documents?

A. Synonyms B. Relationships C. Names D. Repositories

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 4

Which entity in a table is a measurable object in the real world?

A. Conceptual entity B. Logical entity C. Tangible entity D. Virtual entity

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

What is information independence?

A. An ability to interchange databases B. An ability to change database type C. An ability to change the organization of data D. An ability to make changes to existing queries

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

What is a common error made while inserting an automatically incrementing primary key?

A. Inserting a value and overriding auto-increment for a primary key B. Failing to set a numeric value in a newly inserted row C. Designating multiple primary keys D. Forgetting to specify which is the auto-increment column

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

Which constraint propagates primary key changes to foreign keys?

A. SET DEFAULT B. RESTRICT C. CASCADE D. SET NULL

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

WGU Data Management – Foundations - Data-Management-Foundations Exam Practice Test