WGU D426 Objective Assessment Final with 150
accurate and verified questions covering professional
presence and influence, communication strategies,
emotional intelligence, self-awareness, and the
impact of personal behavior in professional settings.
Words with special meaning.
ex. SELECT, FROM, WHERE <<<correct answer>>>Keywords (SQL
Syntax)
Objects from the database like tables, columns, etc.
ex. City, Name, Population <<<correct answer>>>Identifiers (SQL
Syntax)
Data Definition Language (DDL) defines the structure of the database.
Data Query Language (DQL) retrieves data from the database.
,Data Manipulation Language (DML) manipulates data stored in a
database.
Data Control Language (DCL) controls database user access.
Data Transaction Language (DTL) manages database transactions.
<<<correct answer>>>SQL Sublanguages
A single column of a single row. <<<correct answer>>>Cell
Rows <<<correct answer>>>Not Ordered
Rule 7. Allows database administrators to improve query performance
by changing the organization of data on storage devices, without
affecting query results. <<<correct answer>>>Data Independence
Statement that deletes a table, along with all the table's rows, from a
database. <<<correct answer>>>DROP TABLE
Statement that adds, deletes, or modifies columns on an existing table.
<<<correct answer>>>ALTER TABLE
4 bytes <<<correct answer>>>INT
2 bytes <<<correct answer>>>SMALLINT
, 8 bytes <<<correct answer>>>BIGINT
1 byte <<<correct answer>>>TINYINT
3 bytes <<<correct answer>>>MEDIUMINT
Divides one numeric value by another and returns the integer
remainder <<<correct answer>>>% (Modulo)
Raises one numeric value to the power of another. <<<correct
answer>>>^
Compares two values for equality. <<<correct answer>>>=
Compares two values for inequality. <<<correct answer>>>!=
A special value that represents either unknown or inapplicable data.
<<<correct answer>>>NULL
INTO clause names the table and columns where data is to be added.
The keyword INTO is optional.
accurate and verified questions covering professional
presence and influence, communication strategies,
emotional intelligence, self-awareness, and the
impact of personal behavior in professional settings.
Words with special meaning.
ex. SELECT, FROM, WHERE <<<correct answer>>>Keywords (SQL
Syntax)
Objects from the database like tables, columns, etc.
ex. City, Name, Population <<<correct answer>>>Identifiers (SQL
Syntax)
Data Definition Language (DDL) defines the structure of the database.
Data Query Language (DQL) retrieves data from the database.
,Data Manipulation Language (DML) manipulates data stored in a
database.
Data Control Language (DCL) controls database user access.
Data Transaction Language (DTL) manages database transactions.
<<<correct answer>>>SQL Sublanguages
A single column of a single row. <<<correct answer>>>Cell
Rows <<<correct answer>>>Not Ordered
Rule 7. Allows database administrators to improve query performance
by changing the organization of data on storage devices, without
affecting query results. <<<correct answer>>>Data Independence
Statement that deletes a table, along with all the table's rows, from a
database. <<<correct answer>>>DROP TABLE
Statement that adds, deletes, or modifies columns on an existing table.
<<<correct answer>>>ALTER TABLE
4 bytes <<<correct answer>>>INT
2 bytes <<<correct answer>>>SMALLINT
, 8 bytes <<<correct answer>>>BIGINT
1 byte <<<correct answer>>>TINYINT
3 bytes <<<correct answer>>>MEDIUMINT
Divides one numeric value by another and returns the integer
remainder <<<correct answer>>>% (Modulo)
Raises one numeric value to the power of another. <<<correct
answer>>>^
Compares two values for equality. <<<correct answer>>>=
Compares two values for inequality. <<<correct answer>>>!=
A special value that represents either unknown or inapplicable data.
<<<correct answer>>>NULL
INTO clause names the table and columns where data is to be added.
The keyword INTO is optional.
