WGU D426 Objective Assessment

Metadata - Data about the database, such as column names and the number of rows in each table. Relational Database - Stores data in tables, columns, and rows, similar to a spreadsheet. Relational Database - All _________ ________ systems support the SQL query language. Relational Database - Relational systems are ideal for databases that require an accurate record of every transaction, such as banking, airline reservation systems, and student records. MongoDB (NoSQL) - The newer non-relational systems are called NoSQL, for 'not only SQL', and are optimized for big data. SQL Statements - INSERT inserts rows into a table. SELECT retrieves data from a table. UPDATE modifies data in a table. DELETE deletes rows from a table. CREATE TABLE (Statement) - A statement that creates a new table by specifying the table and column names. Each column is assigned a data type that indicates the format of column values. Data types can be numeric, textual, or complex. Data Type - INT stores integer values. DECIMAL stores fractional numeric values. VARCHAR stores textual values.