WGU D426 - Data Management Foundations FINAL
EXAM ACTUAL EXAM COMPLETE QUESTIONS
AND CORRECT DETAILED ANSWERS (100%
CORRECT VERIFIED SOLUTIONS) A NEW
UPDATED VERSION |ALREADY GRADED A+
Business rules
based on business policy and specific to a particular database.
Structured Query Language / SQL
a high-level computer language for storing, manipulating, and
retrieving data.
statement
a complete command composed of one or more clauses. An SQL
______________ is a database command, such as a query that
inserts, selects, updates, or deletes data.
clause
groups SQL keywords like SELECT, FROM, and WHERE with table names like City,
column names like Name, and conditions like Population > 100000.
,Data Definition Language
defines the structure of the database.
Data Query Language
retrieves data from the database.
SHOW DATABASES
lists all databases in the database system instance.
SHOW TABLES
lists all tables in the default database.
SHOW COLUMNS FROM TableName
lists all columns in the TableName table of the default database.
SHOW CREATE TABLE TableName
shows the CREATE TABLE statement for the TableName table of the
default database.
,table
has a name, a fixed sequence of columns, and a varying set of rows.
column
has a name and a data type.
row
an unnamed sequence of values. Each value corresponds to a column
and belongs to the column's data type.
cell
a single column of a single row.
empty table
A table without row.
DROP TABLE
deletes a table, along with all the table's rows, from a database.
, ALTER TABLE
adds, deletes, or modifies columns on an existing table.
EXAM ACTUAL EXAM COMPLETE QUESTIONS
AND CORRECT DETAILED ANSWERS (100%
CORRECT VERIFIED SOLUTIONS) A NEW
UPDATED VERSION |ALREADY GRADED A+
Business rules
based on business policy and specific to a particular database.
Structured Query Language / SQL
a high-level computer language for storing, manipulating, and
retrieving data.
statement
a complete command composed of one or more clauses. An SQL
______________ is a database command, such as a query that
inserts, selects, updates, or deletes data.
clause
groups SQL keywords like SELECT, FROM, and WHERE with table names like City,
column names like Name, and conditions like Population > 100000.
,Data Definition Language
defines the structure of the database.
Data Query Language
retrieves data from the database.
SHOW DATABASES
lists all databases in the database system instance.
SHOW TABLES
lists all tables in the default database.
SHOW COLUMNS FROM TableName
lists all columns in the TableName table of the default database.
SHOW CREATE TABLE TableName
shows the CREATE TABLE statement for the TableName table of the
default database.
,table
has a name, a fixed sequence of columns, and a varying set of rows.
column
has a name and a data type.
row
an unnamed sequence of values. Each value corresponds to a column
and belongs to the column's data type.
cell
a single column of a single row.
empty table
A table without row.
DROP TABLE
deletes a table, along with all the table's rows, from a database.
, ALTER TABLE
adds, deletes, or modifies columns on an existing table.
