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

What is the last step in the logical design process for designing a database?

• A.Analyze data requirements
• B.Determine cardinality
• C.Apply a normal form
• D.Discover entities

Which function is considered an aggregate function?

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

Which optional clause is used to reject inserts and updates that do not satisfy the WHERE clause of a view query?

• A.MATERIALIZED VIEW
• B.BASE TABLE
• C.JOIN VIEWS
• D.WITH CHECK OPTION

What is the role of the database administrator?

• A.The database administrator is responsible for securing the database system against unauthorized users.
• B.The database administrator determines the format of each data element and the overall database structure.
• C.The database administrator develops computer programs that utilize a database.
• D.The database administrator is a consumer of data in a database.

Where does a primary key traditionally appear in a table?

• A.In the table header
• B.In the first column
• C.In the last visible column
• D.In the top row