WGU D311 MICROBIOLOGY
OBJECTIVE ASSESSMENT
PRACTICE EXAM QUESTIONS
WITH CORRECT DETAILED
ANSWERS | ALREADY GRADED
A+<RECENT VERSION>
1) prokaryotic cell - ANSWER lacks a nucleus and membrane bound organelles
2) MySQL - ANSWER 'World' database, a database that is usually installed with
______.
3) Error Code - ANSWER MySQL Server returns an _____ ____ and description
when an SQL statement is syntactically incorrect or the database cannot execute the
statement.
4) Database Model - ANSWER Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
5) Tuple - ANSWER An ORDERED collection of elements enclosed in parentheses.
6) Table - ANSWER A _____ has a name, a fixed tuple of columns, and a varying
set of rows.
7) Column - ANSWER A ______ has a name and a data type.
,8) Row - ANSWER Is an unnamed tuple of values. Each value corresponds to a
column and belongs to the column's data type.
9) Data Type - ANSWER A ____ _____ is a named set of values, from which
column values are drawn.
10) Union - ANSWER Selects all rows of two tables.
11) Aggregate - ANSWER Computes functions over multiple table rows, such as sum
and count.
12) Relational Rules - ANSWER Rules that are logical constraints and ensure data is
valid.
13) The standard language for Relational Databases... - ANSWER SQL is the
standard language for relational databases, and is commonly supported in non-
relational databases.
14) Literals (SQL Syntax) - ANSWER Explicit values that are string, numeric, or
binary. Strings must be surrounded by single quotes or double quotes. Binary values
are represented with x'0' where the 0 is any hex value.
15) Keywords (SQL Syntax) - ANSWER Words with special meaning.
ex. SELECT, FROM, WHERE
16) Identifiers (SQL Syntax) - ANSWER Objects from the database like tables,
columns, etc.
ex. City, Name, Population
17) SQL Sublanguages - ANSWER 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.
18) Cell - ANSWER A single column of a single row.
19) Not Ordered - ANSWER Rows
20) Data Independence - ANSWER Rule 7. Allows database administrators to
improve query performance by changing the organization of data on storage devices,
without affecting query results.
21) DROP TABLE - ANSWER Statement that deletes a table, along with all the
table's rows, from a database.
22) ALTER TABLE - ANSWER Statement that adds, deletes, or modifies columns on
an existing table.
23) INT - ANSWER 4 bytes
24) SMALLINT - ANSWER 2 bytes
25) BIGINT - ANSWER 8 bytes
26) TINYINT - ANSWER 1 byte
27) MEDIUMINT - ANSWER 3 bytes
28) % (Modulo) - ANSWER Divides one numeric value by another and returns the
integer remainder
OBJECTIVE ASSESSMENT
PRACTICE EXAM QUESTIONS
WITH CORRECT DETAILED
ANSWERS | ALREADY GRADED
A+<RECENT VERSION>
1) prokaryotic cell - ANSWER lacks a nucleus and membrane bound organelles
2) MySQL - ANSWER 'World' database, a database that is usually installed with
______.
3) Error Code - ANSWER MySQL Server returns an _____ ____ and description
when an SQL statement is syntactically incorrect or the database cannot execute the
statement.
4) Database Model - ANSWER Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
5) Tuple - ANSWER An ORDERED collection of elements enclosed in parentheses.
6) Table - ANSWER A _____ has a name, a fixed tuple of columns, and a varying
set of rows.
7) Column - ANSWER A ______ has a name and a data type.
,8) Row - ANSWER Is an unnamed tuple of values. Each value corresponds to a
column and belongs to the column's data type.
9) Data Type - ANSWER A ____ _____ is a named set of values, from which
column values are drawn.
10) Union - ANSWER Selects all rows of two tables.
11) Aggregate - ANSWER Computes functions over multiple table rows, such as sum
and count.
12) Relational Rules - ANSWER Rules that are logical constraints and ensure data is
valid.
13) The standard language for Relational Databases... - ANSWER SQL is the
standard language for relational databases, and is commonly supported in non-
relational databases.
14) Literals (SQL Syntax) - ANSWER Explicit values that are string, numeric, or
binary. Strings must be surrounded by single quotes or double quotes. Binary values
are represented with x'0' where the 0 is any hex value.
15) Keywords (SQL Syntax) - ANSWER Words with special meaning.
ex. SELECT, FROM, WHERE
16) Identifiers (SQL Syntax) - ANSWER Objects from the database like tables,
columns, etc.
ex. City, Name, Population
17) SQL Sublanguages - ANSWER 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.
18) Cell - ANSWER A single column of a single row.
19) Not Ordered - ANSWER Rows
20) Data Independence - ANSWER Rule 7. Allows database administrators to
improve query performance by changing the organization of data on storage devices,
without affecting query results.
21) DROP TABLE - ANSWER Statement that deletes a table, along with all the
table's rows, from a database.
22) ALTER TABLE - ANSWER Statement that adds, deletes, or modifies columns on
an existing table.
23) INT - ANSWER 4 bytes
24) SMALLINT - ANSWER 2 bytes
25) BIGINT - ANSWER 8 bytes
26) TINYINT - ANSWER 1 byte
27) MEDIUMINT - ANSWER 3 bytes
28) % (Modulo) - ANSWER Divides one numeric value by another and returns the
integer remainder
