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

WGU C175 Data Management – Foundations Final Exam (Latest 2023/ 2024) Questions and Verified Answers- Grade A Q: A one-to-many unary relationship allows an occurrence of the entity type on the "one side" of the relationship to be associated with . a) a single occurrence of the same entity type b) multiple occurrences of the same entity type c) a single occurrence of the different entity type on the "many side" of the relationship d) multiple occurrences of the different entity type on the "many side" of the relationship e) multiple occur Answer: B Q: A many-to-many unary relationship allows an occurrence of one entity type to be associated with . a) a single occurrence of the same entity type b) multiple occurrences of the same entity type(e.g. Bill-of-Material, "Compo- nent" as a table). c) a single occurrence of another entity type d) multiple occurrences of another entity type e) multiple occurrences of three entity types Answer: B Q: In a university setting, every professor reports to another professor who is the department chair. This is a relationship. a) one-to-one binary b) one-to-many binary c) many-to-many binary d)one-to-one unary e) one-to-many unary Answer: E Q: A single piece of data is the business environment. a) a fact about (data can be any form, not necessary be a record) b) a record describing an object in c) the same thing as an object in d) a file describing an object in e) an event in Answer: A Q: An entity is in the business environment. a) a fact about an object b) a record in a file c) an object or event d) an attribute e) a file Answer: C Q: An attribute is . a) a collection of objects of the same type b) a characteristic of an entity c) a record of a file d) a collection of records of the same type e) an event Answer: B Q: Which of the following is the unique identifier of an entity? a) field b) key c) record type d) record occurrence e) file Answer: B Q: Which of the following does not change the contents of a table? a) retrieve b) insert c) delete d) update e) all of the above Answer: A Q: All of the following are basic principles of the database concept, except . a) maintaining redundant data that does not cause data integrity problems b) the ability to store data in a non-redundant fashion c) the ability to store data representing entities involved in multiple relation- ships d) striving to achieve a high degree of data independence e) data integration Answer: A Q: All of the following are problems caused by redundant data, except . a) wasted disk space b) additional processing time for data updates c) wasted network transmission time d) potential data integrity problems e) the possibility of having what should be the same data value in two different files having different values. Answer: C Q: Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of . a) computer security b) backup and recovery c) concurrency control d) integration control e) access control Answer: C Q: Rebuilding a database after it is destroyed by a natural disaster is an aspect of . a) computer security b) backup and recovery c) concurrency control d) integration control e) access control Answer: B Q: When data structures can be modified without affecting the programs that use the data, we say that the environment is highly . a) secure b) recoverable c) data structured d) data independent e) data dependent Answer: D Q: A data definition language (DDL) . a) is the same as a data manipulation language b) is limited to defining the size and type of attributes c) specifies what tables will be in the database, what attributes will be in the tables, and which attributes will be indexed d) specifies the programming language statements that will be used to access the data in a relational database e) specifies the operating system parameters that will permit the relational DBMS to function within its environment Answer: C Q: A data manipulation language (DML) is capable of . a) inserting new records or rows into a relation b) deleting records or rows of a relation c) retrieving data from a relation d) a and b above e) a, b, and c above Answer: E