D426 - Data Management Foundations Questions
and Correct Answers
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.
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);
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
INT, DECIMAL, VARCHAR, DATE
stores integer values
stores fractional numeric values
stores textual values
stores year, month, and day
Analysis Phase
specifies database requirements without regard to a specific database system. Requirements are
represented as entities, relationships, and attributes.
entity
Is a person, place, activity, or thing. Singular.
relationship
is a link between entities, and an attribute is a descriptive property of an entity.
Analysis alternate names
and Correct Answers
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.
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);
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
INT, DECIMAL, VARCHAR, DATE
stores integer values
stores fractional numeric values
stores textual values
stores year, month, and day
Analysis Phase
specifies database requirements without regard to a specific database system. Requirements are
represented as entities, relationships, and attributes.
entity
Is a person, place, activity, or thing. Singular.
relationship
is a link between entities, and an attribute is a descriptive property of an entity.
Analysis alternate names
