WGU - D426: OBJECTIVE ASSESSMENT / REAL
ACTUAL EXAM STUDY GUIDE | ACCURATE
EXPERT VERIFIED FOR GUARANTEED PASS |
LATEST UPDATE
Database Application Software that helps business users interact with database
systems.
Responsible for securing the database system against
unauthorized users. A database administrator enforces
Database Administrator
procedures for user access and database system
availability.
Practice questions for this set
Learn
Studied terms
Nice work, you're crushing it
Continue studying in Learn
Terms in this set (151)
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.
Performs query optimization to ensure the most efficient
instructions are executed on the data.
Storage Manager Translates the query processor instructions into lowlevel file-
system commands that modify or retrieve data. Database
sizes range from megabytes to many terabytes, so the storage
manager uses indexes to quickly locate data.
Transaction Manager Ensures transactions are properly executed. The transaction
manager prevents conflicts between concurrent
transactions. The transaction manager also restores the
database to a consistent state in the event of a transaction
or system failure.
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.
The newer non-relational systems are called NoSQL, for 'not
MongoDB (NoSQL)
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 A statement that creates a new table by specifying the table
(Statement) 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.
DATE stores year, month, and day.
Database Design Analysis
Logical design
Physical design
Analysis Phase, This phase specifies database requirements without regard
Conceptual Design, to a specific database system. Requirements are
represented as entities, relationships, and attributes. An
Entity-Relationship
entity is a person, place, activity, or thing. A relationship is a
Modeling (Database link between entities, and an attribute is a descriptive
Design) property of an entity.
Logical Design (Database This phase implements database requirements in a specific
Design) database system. For relational database systems, _________
design converts entities, relationships, and attributes into
tables, keys, and columns.
Physical Design Specifies indexes, table structures, and partitions. This
phase adds indexes and specifies how tables are organized
on storage media. Affects query processing speed but never
affects the query result.
Allows database designers to tune query performance
Data Independence
without changes to application programs.
ACTUAL EXAM STUDY GUIDE | ACCURATE
EXPERT VERIFIED FOR GUARANTEED PASS |
LATEST UPDATE
Database Application Software that helps business users interact with database
systems.
Responsible for securing the database system against
unauthorized users. A database administrator enforces
Database Administrator
procedures for user access and database system
availability.
Practice questions for this set
Learn
Studied terms
Nice work, you're crushing it
Continue studying in Learn
Terms in this set (151)
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.
Performs query optimization to ensure the most efficient
instructions are executed on the data.
Storage Manager Translates the query processor instructions into lowlevel file-
system commands that modify or retrieve data. Database
sizes range from megabytes to many terabytes, so the storage
manager uses indexes to quickly locate data.
Transaction Manager Ensures transactions are properly executed. The transaction
manager prevents conflicts between concurrent
transactions. The transaction manager also restores the
database to a consistent state in the event of a transaction
or system failure.
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.
The newer non-relational systems are called NoSQL, for 'not
MongoDB (NoSQL)
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 A statement that creates a new table by specifying the table
(Statement) 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.
DATE stores year, month, and day.
Database Design Analysis
Logical design
Physical design
Analysis Phase, This phase specifies database requirements without regard
Conceptual Design, to a specific database system. Requirements are
represented as entities, relationships, and attributes. An
Entity-Relationship
entity is a person, place, activity, or thing. A relationship is a
Modeling (Database link between entities, and an attribute is a descriptive
Design) property of an entity.
Logical Design (Database This phase implements database requirements in a specific
Design) database system. For relational database systems, _________
design converts entities, relationships, and attributes into
tables, keys, and columns.
Physical Design Specifies indexes, table structures, and partitions. This
phase adds indexes and specifies how tables are organized
on storage media. Affects query processing speed but never
affects the query result.
Allows database designers to tune query performance
Data Independence
without changes to application programs.
