WGU D426 Objective Assessment (Latest 2023/ 2023 Update) Data Management Foundations | Questions and Verified Answers|100% Correct| Grade A

WGU D426 Objective Assessment (Latest 2023/ 2023 Update) Data Management Foundations | Questions and Verified Answers|100% Correct| Grade A Q: The storage manager translates Answer: the query processor instructions into low-lev- el file-system commands that modify or retrieve data Q: Database sizes range from Answer: from megabytes to many terabytes, Q: the storage manager uses what to quickly locate data Answer: indexes Q: Metadata is Answer: data about the database, such as column names and the number of rows in each table. Q: A relational database stores Answer: data in tables, columns, and rows, similar to a spreadsheet. Q: All relational database systems support what query language model Answer: SQL Q: Relational systems are ideal for Answer: databases that require an accurate record of every transaction, such as banking, airline reservation systems, and student records. Q: The newer non-relational systems are called Answer: NoSQL, for 'not only SQL' Q: NoSQL, for 'not only SQL' is optimized for Answer: big business Q: MongoDB is what type of database Answer: NoSQL Q: An SQL statement is a Answer: database command, such as a query that inserts, selects, updates, or deletes data: Q: INSERT Answer: inserts rows into a table. Q: SELECT Answer: retrieves data from a table. Q: UPDATE Answer: modifies data in a table. Q: DELETE Answer: deletes rows from a table. Q: The SQL CREATE TABLE statement creates Answer: creates a new table by specify- ing the table and column names. Q: Each column is assigned a data type that indicates Answer: the format of column values. Data types can be numeric, textual, or complex Q: INT Answer: stores integer values. Q: DECIMAL Answer: stores fractional numeric values. Q: VARCHAR Answer: stores textual values Q: DATE Answer: stores year, month, and day. Q: For large, complex databases, the process has three phases Answer: 1.Analysis 2.Logical design 3.Physical design Q: The analysis phase specifies Answer: