1|Page
WGU D426-OBJECTIVE ASSESSMENT
2026|WELL REVISED EXAM WITH
PERFECTLY ANSWERED QUESTIONS
Data Independence - correct-answer - Rule 7. Allows database administrators to
improve query performance by changing the organization of data on storage
devices, without affecting query results.
DROP TABLE - correct-answer - Statement that deletes a table, along with all the
table's rows, from a database.
ALTER TABLE - correct-answer - Statement that adds, deletes, or modifies
columns on an existing table.
INT - correct-answer - 4 bytes
,2|Page
SMALLINT - correct-answer - 2 bytes
BIGINT - correct-answer - 8 bytes
TINYINT - correct-answer - 1 byte
MEDIUMINT - correct-answer - 3 bytes
% (Modulo) - correct-answer - Divides one numeric value by another and returns
the integer remainder
^ - correct-answer - Raises one numeric value to the power of another.
,3|Page
= - correct-answer - Compares two values for equality.
!= - correct-answer - Compares two values for inequality.
NULL - correct-answer - A special value that represents either unknown or
inapplicable data.
INSERT Statement (Clauses) - correct-answer - INTO clause names the table and
columns where data is to be added. The keyword INTO is optional.
VALUES clause specifies the column values to be added.
, 4|Page
INSERT Statement (Syntax) - correct-answer - INSERT [INTO] TableName
(Column1, Column2, ...)VALUES (Value1, Value2, ...);
UPDATE Statement (Clauses) - correct-answer - Uses the SET clause to specify the
new column values.
An optional WHERE clause specifies which rows are updated.
Omitting the WHERE clause results in all rows being updated.
DELETE Statement (Keywords/Clauses) - correct-answer - The FROM keyword is
followed by the table name whose rows are to be deleted.
An optional WHERE clause specifies which rows should be deleted.
Omitting the WHERE clause results in all rows in the table being deleted.
TRUNCATE Statement - correct-answer - Deletes all rows from a table.
WGU D426-OBJECTIVE ASSESSMENT
2026|WELL REVISED EXAM WITH
PERFECTLY ANSWERED QUESTIONS
Data Independence - correct-answer - Rule 7. Allows database administrators to
improve query performance by changing the organization of data on storage
devices, without affecting query results.
DROP TABLE - correct-answer - Statement that deletes a table, along with all the
table's rows, from a database.
ALTER TABLE - correct-answer - Statement that adds, deletes, or modifies
columns on an existing table.
INT - correct-answer - 4 bytes
,2|Page
SMALLINT - correct-answer - 2 bytes
BIGINT - correct-answer - 8 bytes
TINYINT - correct-answer - 1 byte
MEDIUMINT - correct-answer - 3 bytes
% (Modulo) - correct-answer - Divides one numeric value by another and returns
the integer remainder
^ - correct-answer - Raises one numeric value to the power of another.
,3|Page
= - correct-answer - Compares two values for equality.
!= - correct-answer - Compares two values for inequality.
NULL - correct-answer - A special value that represents either unknown or
inapplicable data.
INSERT Statement (Clauses) - correct-answer - INTO clause names the table and
columns where data is to be added. The keyword INTO is optional.
VALUES clause specifies the column values to be added.
, 4|Page
INSERT Statement (Syntax) - correct-answer - INSERT [INTO] TableName
(Column1, Column2, ...)VALUES (Value1, Value2, ...);
UPDATE Statement (Clauses) - correct-answer - Uses the SET clause to specify the
new column values.
An optional WHERE clause specifies which rows are updated.
Omitting the WHERE clause results in all rows being updated.
DELETE Statement (Keywords/Clauses) - correct-answer - The FROM keyword is
followed by the table name whose rows are to be deleted.
An optional WHERE clause specifies which rows should be deleted.
Omitting the WHERE clause results in all rows in the table being deleted.
TRUNCATE Statement - correct-answer - Deletes all rows from a table.
