Free WGU Data-Management-Foundations Exam Dumps Questions & Answers

Which property of an entity can become a column in a table?

• A.Attribute
• B.Non-null values
• C.Modality
• D.Uniqueness

Which relationship exists between occurrences of the same entity types?

• A.Modality
• B.Cardinality
• C.Binary
• D.Unary

Which function is considered an aggregate function?

• A.ABS
• B.MAX
• C.DESC
• D.TRIM

Which clause is used to specify the join columns when performing a join in MySQL?

• A.JOIN
• B.AS
• C.AND
• D.ON

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

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