WGU D426 Objective Assessment
Updated Questions And Correct
Answers
◍ Answer: Database Application. Question: Software that helps business
users interact with database systems.
◍ Answer: Database Administrator. Question: Responsible for securing
the database system against unauthorized users. A database administrator
enforces procedures for user access and database system availability.
◍ Answer: Authorization. Question: 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.
◍ Answer: Rules. Question: Database systems ensure data is consistent
with structural and business rules.
◍ Answer: Query Processor. Question: 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.
,◍ Answer: Storage Manager. Question: 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
storage manager uses indexes to quickly locate data.
◍ Answer: Transaction Manager. Question: 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.
◍ Answer: Metadata. Question: Data about the database, such as column
names and the number of rows in each table.
◍ Answer: Relational Database. Question: Stores data in tables,
columns, and rows, similar to a spreadsheet.
◍ Answer: Relational Database. Question: All _________ ________
systems support the SQL query language.
◍ Answer: Relational Database. Question: Relational systems are ideal
for databases that require an accurate record of every transaction, such
as banking, airline reservation systems, and student records.
, ◍ Answer: MongoDB (NoSQL). Question: The newer non-relational
systems are called NoSQL, for 'not only SQL', and are optimized for big
data.
◍ Answer: SQL Statements. Question: INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
◍ Answer: CREATE TABLE (Statement). Question: 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.
◍ Answer: Data Type. Question: INT stores integer values.
DECIMAL stores fractional numeric values.
VARCHAR stores textual values.
DATE stores year, month, and day.
◍ Answer: Database Design. Question: Analysis
Logical design
Physical design
Updated Questions And Correct
Answers
◍ Answer: Database Application. Question: Software that helps business
users interact with database systems.
◍ Answer: Database Administrator. Question: Responsible for securing
the database system against unauthorized users. A database administrator
enforces procedures for user access and database system availability.
◍ Answer: Authorization. Question: 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.
◍ Answer: Rules. Question: Database systems ensure data is consistent
with structural and business rules.
◍ Answer: Query Processor. Question: 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.
,◍ Answer: Storage Manager. Question: 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
storage manager uses indexes to quickly locate data.
◍ Answer: Transaction Manager. Question: 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.
◍ Answer: Metadata. Question: Data about the database, such as column
names and the number of rows in each table.
◍ Answer: Relational Database. Question: Stores data in tables,
columns, and rows, similar to a spreadsheet.
◍ Answer: Relational Database. Question: All _________ ________
systems support the SQL query language.
◍ Answer: Relational Database. Question: Relational systems are ideal
for databases that require an accurate record of every transaction, such
as banking, airline reservation systems, and student records.
, ◍ Answer: MongoDB (NoSQL). Question: The newer non-relational
systems are called NoSQL, for 'not only SQL', and are optimized for big
data.
◍ Answer: SQL Statements. Question: INSERT inserts rows into a table.
SELECT retrieves data from a table.
UPDATE modifies data in a table.
DELETE deletes rows from a table.
◍ Answer: CREATE TABLE (Statement). Question: 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.
◍ Answer: Data Type. Question: INT stores integer values.
DECIMAL stores fractional numeric values.
VARCHAR stores textual values.
DATE stores year, month, and day.
◍ Answer: Database Design. Question: Analysis
Logical design
Physical design
