D426 Study Guide – Complete With Correct Solutions
Database Application Right Ans - software that helps business users
interact with database systems
Database Administrator Right Ans - Responsible for securing the database
system against unauthorized users. Enforces procedures for user access and
database system availability.
Authorization Right Ans - 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 Right Ans - Database systems ensure data is consistent with
structural and business rules.
Query Processor Right Ans - interprets queries, creates a plan to modify
the database or retrieve data, and returns query results to the application.
Query Optimization Right Ans - ensures the most efficient instructions are
executed on the data
Storage Manager Right Ans - translates the query processor instructions
into low-level file-system commands that modify or retrieve data.
Transaction Manager Right Ans - Ensures transactions are properly
executed. Prevents conflicts between concurrent transactions. Restores the
database to a consistent state in the event of a transaction or system failure.
INSERT Right Ans - Inserts rows into a table
SELECT Right Ans - Retrieves data from a table.
UPDATE Right Ans - Modifies data in a table.
DELETE Right Ans - Deletes rows from a table.
CREATE TABLE Right Ans - Creates a new table by specifying the table and
column names.
, Data Type Right Ans - Indicates the format of column values. Can be
numeric, textual, or complex.
INT Right Ans - Stores integer values
DECIMAL Right Ans - Stores fractional numeric values.
VARCHAR Right Ans - Stores textual values
DATE Right Ans - Stores year, month, and day.
Analysis Phase Right Ans - Specifies database requirements without regard
to a specific database system. Requirements are represented as entities,
relationships, and attributes. An entity is a person, place, or thing. A
relationship is a link between entities, and a attribute is a descriptive property
of an entity.
Analysis Right Ans - Has many names, such as conceptual design, entity-
relationship modeling, and requirements definition.
Logical Design Phase Right Ans - Implements database requirements in a
specific database system. Converts the entity-relationship model into tables,
columns, and keys for a particular database system.
Physical Design Phase Right Ans - Adds indexes and specifies how tables
are organized on storage media. Affects query processing speed but never
affects the query result.
Data Independence Right Ans - The principle that physical design never
affects query results. Allows database designers to tune query performance
without changes to application programs.
Tuple Right Ans - an ordered collection of elements enclosed in
parentheses. Ex: (a, b, b) and (c, b, a).
Table Right Ans - Has a name, a fixed tuple of columns, and a varying set of
rows.
Database Application Right Ans - software that helps business users
interact with database systems
Database Administrator Right Ans - Responsible for securing the database
system against unauthorized users. Enforces procedures for user access and
database system availability.
Authorization Right Ans - 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 Right Ans - Database systems ensure data is consistent with
structural and business rules.
Query Processor Right Ans - interprets queries, creates a plan to modify
the database or retrieve data, and returns query results to the application.
Query Optimization Right Ans - ensures the most efficient instructions are
executed on the data
Storage Manager Right Ans - translates the query processor instructions
into low-level file-system commands that modify or retrieve data.
Transaction Manager Right Ans - Ensures transactions are properly
executed. Prevents conflicts between concurrent transactions. Restores the
database to a consistent state in the event of a transaction or system failure.
INSERT Right Ans - Inserts rows into a table
SELECT Right Ans - Retrieves data from a table.
UPDATE Right Ans - Modifies data in a table.
DELETE Right Ans - Deletes rows from a table.
CREATE TABLE Right Ans - Creates a new table by specifying the table and
column names.
, Data Type Right Ans - Indicates the format of column values. Can be
numeric, textual, or complex.
INT Right Ans - Stores integer values
DECIMAL Right Ans - Stores fractional numeric values.
VARCHAR Right Ans - Stores textual values
DATE Right Ans - Stores year, month, and day.
Analysis Phase Right Ans - Specifies database requirements without regard
to a specific database system. Requirements are represented as entities,
relationships, and attributes. An entity is a person, place, or thing. A
relationship is a link between entities, and a attribute is a descriptive property
of an entity.
Analysis Right Ans - Has many names, such as conceptual design, entity-
relationship modeling, and requirements definition.
Logical Design Phase Right Ans - Implements database requirements in a
specific database system. Converts the entity-relationship model into tables,
columns, and keys for a particular database system.
Physical Design Phase Right Ans - Adds indexes and specifies how tables
are organized on storage media. Affects query processing speed but never
affects the query result.
Data Independence Right Ans - The principle that physical design never
affects query results. Allows database designers to tune query performance
without changes to application programs.
Tuple Right Ans - an ordered collection of elements enclosed in
parentheses. Ex: (a, b, b) and (c, b, a).
Table Right Ans - Has a name, a fixed tuple of columns, and a varying set of
rows.