D426 - Data Management Foundations D426 - Data Management Foundations 2/18/2026
joins a table to itself
Give this one a go later!
1 database application 2 Data Type
self-join 4 query processor
Press any key to
Don't know?Continue
continue
Terms in this set (139)
database application software that helps business users interact with database systems
database administrator responsible for securing the database system against unauthorized
users. A _____ enforces procedures for user access and database
system availability.
Authorization Many database users should have limited access to specific tables,
columns, or rows of a database. Database systems authorize
individual users to access specific data.
Page 1 D426 - Data Management Foundations.pdf
,D426 - Data Management Foundations D426 - Data Management Foundations 2/18/2026
Rules Database systems ensure data is consistent with structural and
business rules
query processor interprets queries, creates a plan to modify the database or retrieve
data, and returns query results to the application.
Storage Manager translates the query processor instructions into low-level file-system
commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the _____ uses indexes to quickly
locate data.
Transaction Manager ensures transactions are properly executed. The ______ prevents
conflicts between concurrent transactions. The _______ also restores
the database to a consistent state in the event of a transaction or
system failure.
INSERT inserts rows into a table.
INSERT INTO table_name (column_name1, column_name2, ...) VALUES
(DEFAULT, 'bob', 30, 150);
Page 2 D426 - Data Management Foundations.pdf
, D426 - Data Management Foundations D426 - Data Management Foundations 2/18/2026
SELECT retrieves data from a table
SELECT column1, column2, ... FROM table_name; -- return all data
from those columns.
UPDATE modifies data in a table
UPDATE table_name SET column_name = 2 WHERE column_id = 3;
Delete deletes rows from a table
DELETE FROM table_name; -- all rows deleted! DELETE FROM
table_name WHERE column_name = 'value'; -- delete row
CREATE TABLE creates a new table by specifying the table and column names.
DDL
Data Type Each column is assigned a ____ that indicates the format of column
values. ____ can be numeric, textual, or complex
Page 3 D426 - Data Management Foundations.pdf
joins a table to itself
Give this one a go later!
1 database application 2 Data Type
self-join 4 query processor
Press any key to
Don't know?Continue
continue
Terms in this set (139)
database application software that helps business users interact with database systems
database administrator responsible for securing the database system against unauthorized
users. A _____ enforces procedures for user access and database
system availability.
Authorization Many database users should have limited access to specific tables,
columns, or rows of a database. Database systems authorize
individual users to access specific data.
Page 1 D426 - Data Management Foundations.pdf
,D426 - Data Management Foundations D426 - Data Management Foundations 2/18/2026
Rules Database systems ensure data is consistent with structural and
business rules
query processor interprets queries, creates a plan to modify the database or retrieve
data, and returns query results to the application.
Storage Manager translates the query processor instructions into low-level file-system
commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the _____ uses indexes to quickly
locate data.
Transaction Manager ensures transactions are properly executed. The ______ prevents
conflicts between concurrent transactions. The _______ also restores
the database to a consistent state in the event of a transaction or
system failure.
INSERT inserts rows into a table.
INSERT INTO table_name (column_name1, column_name2, ...) VALUES
(DEFAULT, 'bob', 30, 150);
Page 2 D426 - Data Management Foundations.pdf
, D426 - Data Management Foundations D426 - Data Management Foundations 2/18/2026
SELECT retrieves data from a table
SELECT column1, column2, ... FROM table_name; -- return all data
from those columns.
UPDATE modifies data in a table
UPDATE table_name SET column_name = 2 WHERE column_id = 3;
Delete deletes rows from a table
DELETE FROM table_name; -- all rows deleted! DELETE FROM
table_name WHERE column_name = 'value'; -- delete row
CREATE TABLE creates a new table by specifying the table and column names.
DDL
Data Type Each column is assigned a ____ that indicates the format of column
values. ____ can be numeric, textual, or complex
Page 3 D426 - Data Management Foundations.pdf
