WGU C175 Pre-Assessment Data Management – Foundations Exam (Latest 2023/ 2024) Questions and Verified Answers- Grade A

WGU C175 Pre-Assessment Data Management – Foundations Exam (Latest 2023/ 2024) Questions and Verified Answers- Grade A Q: Which data classification is an entity? A) Event B) Duration C) Directions D) Attendance Answer: Event Q: A salesperson is authorized to sell 12 products; a product can be sold by 10 salespersons. Which kind of binary relationship is described in this example? A) One-to-one B) One-to-many C) Many-to-many D) Associative Answer: Many-to-many Q: Which three kinds of rules for referential integrity are provided by modern relational database management systems? Choose 3 answers A) Sort B) Insert C) Query D) Delete E) Update F) Retrieve Answer: Insert, Delete, Update Q: (3) examples of a relation in 1NF Answer: 1. It has multiple candidate keys 2. All of the key attributes are defined 3. All attributes are dependent on the primary key Q: The SQL command that enables you to make changes in the data is ____. Answer: UPDATE Q: Which command would be used to delete the table row where the P_Code = '2238/QPD'? Answer: DELETE FROM PRODUCT WHERE P_CODE = '2238/QPD'; Q: Which command is used to select partial table contents? Answer: SELECT <column(s)> FROM <Table name> WHERE <Conditions>; Q: A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values. Answer: full outer Q: A relational operator that allows for the *combination* of information from two or more tables is known as the ____ operator. Answer: JOIN Q: The entity integrity rule requires that ____.* Answer: All primary key entries are *unique* Q: We can describe a link by observing that ____. Answer: A primary key (PK) of one table *appears again as a foreign key* in a related table Q: An attribute (or combination of attributes) that *uniquely identifies each entity* in a table is called a ____. Answer: SuperKey Q: A foreign key must ____. Answer: