WGU C182 OBJECTIVE ASSESSMENT
COMPLETE STUDY GUIDE WITH SOLVED
QUESTIONS
◉ Database Administrator.
Answer: Responsible for securing the database system against
unauthorized users. A database administrator enforces procedures
for user access and database system availability.
◉ Authorization.
Answer: 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.
Answer: Database systems ensure data is consistent with structural
and business rules.
◉ Query Processor.
Answer: 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.
Answer: 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.
◉ Transaction Manager.
Answer: 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.
Answer: Data about the database, such as column names and the
number of rows in each table.
◉ Relational Database.
Answer: Stores data in tables, columns, and rows, similar to a
spreadsheet.
◉ Relational Database.
Answer: All _________ ________ systems support the SQL query
language.
,◉ Relational Database.
Answer: Relational systems are ideal for databases that require an
accurate record of every transaction, such as banking, airline
reservation systems, and student records.
◉ MongoDB (NoSQL).
Answer: The newer non-relational systems are called NoSQL, for
'not only SQL', and are optimized for big data.
◉ SQL Statements.
Answer: 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 (Statement).
Answer: 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.
◉ Data Type.
, Answer: INT stores integer values.
DECIMAL stores fractional numeric values.
VARCHAR stores textual values.
DATE stores year, month, and day.
◉ Database Design.
Answer: Analysis
Logical design
Physical design
◉ Analysis Phase, Conceptual Design, Entity-Relationship Modeling
(Database Design).
Answer: This phase specifies database requirements without regard
to a specific database system. Requirements are represented as
entities, relationships, and attributes. An entity is a person, place,
activity, or thing. A relationship is a link between entities, and an
attribute is a descriptive property of an entity.
◉ Logical Design (Database Design).
Answer: This phase implements database requirements in a specific
database system. For relational database systems, _________ design
converts entities, relationships, and attributes into tables, keys, and
columns.
COMPLETE STUDY GUIDE WITH SOLVED
QUESTIONS
◉ Database Administrator.
Answer: Responsible for securing the database system against
unauthorized users. A database administrator enforces procedures
for user access and database system availability.
◉ Authorization.
Answer: 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.
Answer: Database systems ensure data is consistent with structural
and business rules.
◉ Query Processor.
Answer: 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.
Answer: 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.
◉ Transaction Manager.
Answer: 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.
Answer: Data about the database, such as column names and the
number of rows in each table.
◉ Relational Database.
Answer: Stores data in tables, columns, and rows, similar to a
spreadsheet.
◉ Relational Database.
Answer: All _________ ________ systems support the SQL query
language.
,◉ Relational Database.
Answer: Relational systems are ideal for databases that require an
accurate record of every transaction, such as banking, airline
reservation systems, and student records.
◉ MongoDB (NoSQL).
Answer: The newer non-relational systems are called NoSQL, for
'not only SQL', and are optimized for big data.
◉ SQL Statements.
Answer: 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 (Statement).
Answer: 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.
◉ Data Type.
, Answer: INT stores integer values.
DECIMAL stores fractional numeric values.
VARCHAR stores textual values.
DATE stores year, month, and day.
◉ Database Design.
Answer: Analysis
Logical design
Physical design
◉ Analysis Phase, Conceptual Design, Entity-Relationship Modeling
(Database Design).
Answer: This phase specifies database requirements without regard
to a specific database system. Requirements are represented as
entities, relationships, and attributes. An entity is a person, place,
activity, or thing. A relationship is a link between entities, and an
attribute is a descriptive property of an entity.
◉ Logical Design (Database Design).
Answer: This phase implements database requirements in a specific
database system. For relational database systems, _________ design
converts entities, relationships, and attributes into tables, keys, and
columns.
