WGU D426 Objective Assessment Study Guide - Study Answer Collection

WGU D426 Objective Assessment Study Guide - Study Answer Collection Data - answer - Data is numeric, textual, visual or audio information that describes real-world systems. Analog - answer - Historically, data was mostly analog, encoded as continuous variations on various physical media digital - answer - today, data is mostly digital, encoded as zeros and ones on electronic and magnetic medai Database - answer - a collection of data in a structured format database system - answer - also known as DBMS, is software that reads and writes data in a database. ensures data is secure, consistent and available at all times query language - answer - a specialized programming language, designed specifically for database systems. database application - answer - software that helps business users interact with database systems. database administrator - answer - responsible for securing the database system against unauthorized users database designer - answer - determines the format of each data element and the overall database structure. database programmer - answer - develops computer programs that utilize a database database user - answer - a consumer of data in a database. transaction - answer - A group of queries that must be either completed or rejected as a whole architecture - answer - describes the internal components and the relationship between components. query processor - answer - interprets queries, creates a plan to modify the databse or retrieve data, and returns query results to the application. query optimization - answer - performed by the query processor to ensure the most efficient instructions are executed on the data. storage manager - answer - translates the query processor instructions into low-level file-system commands that modify or retrieve data. indexes - answer - used by storage manager to quickly locate data transaction manager - answer - ensures transactions are properly executed log - answer - a file containing a complete record of all inserts, updates and deletes processed by the database. catalog / data dictionary - answer - a directory of tables, columns, indexes and other database objects relational database - answer - stores data in tables, columns, and rows, similar to a spreadsheet SQL - answer - Stands for structured query language. Includes statements that read and write data, create and delete tables, and administer the database system. big data - answer - massive volumes of online data. often poorly structured or missing information. NoSQL - answer - Newer non-relational systems (Not Only SQL). Optimized for big data. Open source - answer - Software that anyone can inspect, copy and modify with no licensing fee query - answer - a command for a database that typically inserts new data, retrieves data, updates data, or deletes data from a database CRUD - answer - The four common queries: Create, Read, Update and Delete statement - answer - A SQL statement is a database command, such as a query that inserts, that inserts, selects, updates, or deletes data INSERT - answer - command that inserts rows into a table SELECT - answer - command that retrieves data from a table UPDATE - answer - command that modifies data in a table DELETE - answer - command that deletes data in a table CREATE TABLE - answer - command that creates a new table by specifying the table and column names data type - answer - indicates the format of column values. can b e numeric, textual or complex database design - answer - specification of database objects such as tables, columns, data types and indexes. also refers to the process used to develop the specification analysis - answer - specifies database requirements without regard to a specific database system. develops ERD. ER diagrams - answer - entities, relationships and attributes are depicted in these diagrams logical design - answer - implements database requirements in a specific database system. converts the ERD into tables, column