WGU D426 Data Management Foundations Final Exam (Latest 2023\/ 2023 Update) | Questions and Verified Answers|100% Correct| Grade A<\/p>\n\n\n\n
WGU D426 Data Management Foundations
Final Exam (Latest 2023\/ 2023 Update) |
Questions and Verified Answers|100%
Correct| Grade A
Q: Architecture
Answer:
Describes the internal components AND the relationships between components.
Q: Query Processor
Answer:
Interprets queries, creates a plan to modify the database or retrieve the data, and returns query
results to the application. Performs query optimization.
Q: Query Optimization
Answer:
Ensures efficient instructions are executed on the data from the Query Processor.
Q: Storage Manager
Answer:
Translates the query processor instructions into low-level file-system commands that modify OR
retrieve data. Uses indexes to quickly locate data.<\/p>\n\n\n\n
Q: Transaction Manager
Answer:
Ensures transactions are properly executed. Prevents conflicts between concurrent transactions.
Also restores the database to a consistent state in the event of a failure.
Q: Log
Answer:
A file containing a complete record of ALL inserts, updates, and deletes processed by the
database. The records can be used to restore a database.
Q: Catalog\/Data Dictionary\/Repository
Answer:
A directory of tables, columns, indexes, and other database objects.
Q: Relational Database
Answer:
Stores data in tables, columns, and rows, SIMILAR to a spreadsheet. It also supports SQL. Made
up of relations.
Q: NoSQL
Answer:
A new generation of DBMS that is NOT based on the traditional relational database model.
Q: CRUD<\/p>\n\n\n\n
Answer:
Acronym for actions that can be performed by a query.
Q: SQL Statement
Answer:
A database command such as a query that inserts, retrieves, updates, or deletes data. Composed
of one or more clauses.
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.<\/p>\n\n\n\n
Q: CREATE TABLE
Answer:
Creates a new table by specifying the table and column names.
Q: Data Type
Answer:
Indicates the TYPE of data that can be stored in a field of a column.
Q: Data Independence
Answer:
Allows database administrators to improve query performance by changing the organization of
data on storage devices, without affecting query results or changes to programs.
Q: Database Design
Answer:
A specification of database objects such as tables, columns data types, and indexes. Also refers
to the process used to develop the specifications.
Q: Metadata
Answer:
Data ABOUT the database, such as column names and the number of rows in each table.
Powered by https:\/\/learnexams.com\/search\/study?query=<\/a><\/p>\n\n\n\n