WGU - D426: OBJECTIVE ASSESSMENT |DATABASE MANAGEMENT CONCEPTS | 180 QUESTIONS
WITH ACCURATE SOLUTIONS
1. Normalization is a process for evaluating and correcting table structures
to minimize___.
data redundancy and anomalies
data redundancy and
security data anomalies and
integrity data integrity and
security
2. Describe why heap tables are particularly efficient for bulk loading
of rows in a database.
Heap tables are efficient for bulk loading because rows are
stored in the order they are loaded, minimizing the need
for reorganization.
Heap tables automatically create indexes for faster access.
Heap tables require less memory than indexed tables.
Heap tables are designed to enforce data integrity constraints.
3. Which SQL statement is used to remove rows from a table?
SELECT
DELETE
UPDATE
INSERT
4. Describe the role of keywords in SQL statements and how they
contribute to database queries.
,Keywords help in normalizing database tables.
, Keywords in SQL statements define the structure and
commands for querying the database.
Keywords are irrelevant to database management.
Keywords are used to store data in the
database.
5. It is the component of a database system that provides the
interface between the low-level data stored in the database and the
application programs and queries submitted to the system.
Database Engine
Transaction Manager
Storage Manager
Query Processing
6. If you have a table of employees and you want to retrieve their names
sorted by their hire date in descending order, which SQL
statement would you use?
SELECT name FROM employees SORT BY hire_date;
SELECT name FROM employees WHERE hire_date DESC;
SELECT name FROM employees ORDER BY hire_date DESC;
SELECT name FROM employees ORDER BY hire_date ASC;
7. What aggregate function is used to return the number of records in a
group.
Min
Sum
Avg
Count
, 8. In a scenario where a parent record is deleted from a database, how
would using the RESTRICT option affect the deletion process if there are
dependent child records?
The deletion would be logged for future reference but allowed
to proceed.
The deletion would proceed, but child records would be set to
NULL.
The deletion would proceed, and child records would be
deleted automatically.
The deletion would be rejected if there are dependent child
records.
9. What is a composite key in database management?
A key that consists of multiple columns and is denoted with
parentheses.
A single-column key that uniquely identifies a record.
A key that is used to enforce referential integrity.
A key that is automatically generated by the database.
10. Describe the characteristics of an artificial key and its purpose in
database design.
An artificial key is a composite key made from multiple attributes
that have meaningful values.
An artificial key is a single-column primary key created by the
database designer when no suitable primary key exists,
typically consisting of meaningless integer values.
An artificial key is a natural key derived from the data itself.
An artificial key is a foreign key that references a primary key in
another table.
WITH ACCURATE SOLUTIONS
1. Normalization is a process for evaluating and correcting table structures
to minimize___.
data redundancy and anomalies
data redundancy and
security data anomalies and
integrity data integrity and
security
2. Describe why heap tables are particularly efficient for bulk loading
of rows in a database.
Heap tables are efficient for bulk loading because rows are
stored in the order they are loaded, minimizing the need
for reorganization.
Heap tables automatically create indexes for faster access.
Heap tables require less memory than indexed tables.
Heap tables are designed to enforce data integrity constraints.
3. Which SQL statement is used to remove rows from a table?
SELECT
DELETE
UPDATE
INSERT
4. Describe the role of keywords in SQL statements and how they
contribute to database queries.
,Keywords help in normalizing database tables.
, Keywords in SQL statements define the structure and
commands for querying the database.
Keywords are irrelevant to database management.
Keywords are used to store data in the
database.
5. It is the component of a database system that provides the
interface between the low-level data stored in the database and the
application programs and queries submitted to the system.
Database Engine
Transaction Manager
Storage Manager
Query Processing
6. If you have a table of employees and you want to retrieve their names
sorted by their hire date in descending order, which SQL
statement would you use?
SELECT name FROM employees SORT BY hire_date;
SELECT name FROM employees WHERE hire_date DESC;
SELECT name FROM employees ORDER BY hire_date DESC;
SELECT name FROM employees ORDER BY hire_date ASC;
7. What aggregate function is used to return the number of records in a
group.
Min
Sum
Avg
Count
, 8. In a scenario where a parent record is deleted from a database, how
would using the RESTRICT option affect the deletion process if there are
dependent child records?
The deletion would be logged for future reference but allowed
to proceed.
The deletion would proceed, but child records would be set to
NULL.
The deletion would proceed, and child records would be
deleted automatically.
The deletion would be rejected if there are dependent child
records.
9. What is a composite key in database management?
A key that consists of multiple columns and is denoted with
parentheses.
A single-column key that uniquely identifies a record.
A key that is used to enforce referential integrity.
A key that is automatically generated by the database.
10. Describe the characteristics of an artificial key and its purpose in
database design.
An artificial key is a composite key made from multiple attributes
that have meaningful values.
An artificial key is a single-column primary key created by the
database designer when no suitable primary key exists,
typically consisting of meaningless integer values.
An artificial key is a natural key derived from the data itself.
An artificial key is a foreign key that references a primary key in
another table.
