WGU C175 Exam Bundle Questions and Answers with complete solutions

What is a determining characteristic of unstructured data? - ANSWER-It does not follow a data model. Which is true about flat files? - ANSWER-They contain no internal hierarchical organization. Which technology has no internal hierarchy? - ANSWER-Flat files How were data retrieved before da...

cloud database - ANSWER-A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS data - ANSWER-Raw facts, or facts that have not yet been processed to reveal their meaning to the end user data anomaly - ANSWER-An abnormality of the data in which inc...

Candidate Key - ANSWER-Is any column or a combination of columns that can qualify as unique key in database. Cardinality - ANSWER-Cardinality represents the maximum number of entities that can be involved in a particular relationship. Cartesian product - ANSWER-Usually the result of a missing ...

What are data? A) Facts that have been organized in a meaningful way B) Facts that are the result of a query of a database system C) Facts that are collected and stored in a database system D) Facts that have been processed and used for decision making - ANSWER-Facts that are collected and st...

What is a determining characteristic of unstructured data? - ANSWER-It does not follow a data model. Which is true about flat files? - ANSWER-They contain no internal hierarchical organization. Which technology has no internal hierarchy? - ANSWER-Flat files How were data retrieved before da...

1890-Herman Hollerith - ANSWER-tabulator/sorter punch cards Amercian census-ABM 1911-James Powers - ANSWER-automatic feeders Powers tabulators machine comp>UNIVAC>UnisysCorp 1930's - ANSWER-Erasable magnetic tape for storage 1940's - ANSWER-magnetic drum's begin prototype Flat F...

_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed. - ANSWER-Performance tuning The response of the DBMS to a query is the ______. - ANSWER-query result set Field refers to a collection of related records. - ANSWER-...

ad hoc query - ANSWER-A "spur-of-the-moment" question. alias - ANSWER-An alternative name for a column or table in a SQL statement. ALTER TABLE - ANSWER-The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or chang...

centralized database - ANSWER-A database located at a single site. cloud database - ANSWER-A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS. data - ANSWER-Raw facts, or facts that have not yet been processed to reveal their meaning to the en...

What is the name of this relationship? - ANSWER-One-to-many binary relationship "A salesperson is authorized to sell many products, and a product can be sold by many salespersons." What is the name of this relationship? - ANSWER-Many-to-many binary relationship What is the positioning and...