WGU C175 Data Management – Foundations Exam Review (Latest 2023/ 2024) Complete with Questions and Verified Answers- 100% Correct

WGU C175 Data Management – Foundations Exam Review (Latest 2023/ 2024) Complete with Questions and Verified Answers- 100% Correct Q: What are the five basic principles of The Database Concept? Answer: 1. The creation of a datacentric environment that is a significant company resource, which can be shared inside and outside the company. 2. The ability to achieve data integration while storing data in a non-redundant fashion. 3. The ability to store data representing entities involved in multiple relationships w/o introducing data redundancy. 4. Managing data control issues such as data security, backup and recovery, and concurrency control. 5. High degree of data independence. Q: What are the four major DBMS approaches? Answer: - Hierarchical - Network - Relational - Object-oriented Q: What are four key differences between a RELATION and a FILE? Answer: - The columns of a relation can be arranged in any order w/o affecting the meaning of the data. That is not true of a file. - Similarly, the rows of a relation can be arranged in any order, which is not true of a file. - Every row/column position, sometimes referred to as a "cell", can have only a single value, which is not necessarily true in a file. - No two rows of a relation are identical, which is not necessarily true in a file. Q: * in the SELECT clause Answer: - It indicates that all attributes of the selected row are to be retrieved Q: AND operator Answer: - It displays a record if more than one condition is true Q: AVG() function Answer: - It returns the average value of a numeric column. Q: BETWEEN operator Answer: - It allows you to specify a range of numeric values in a search. Q: DISTINCT operator Answer: - It is used to eliminate duplicate rows in a query result. Q: IN operator Answer: - It allows you to specify a list of character strings to be included in a search Q: JOIN clause Answer: - It is used to combine rows from more than one table, based on a common field between them. Sometimes it is done by using the '=' symbol. Q: LIKE operator Answer: - It allows you to specify partial character strings in a "wildcard" sense. Q: OR operator Answer: - It displays a record it either the first condition OR the second condition is true. Q: ORDER BY clause Answer: - It simply takes the result of a SQL query and orders them by one or more specified attributes. Q: SELECT command