1
D427
D 427 / D427 Pre - Assessment V1 (Latest
Update ) Data Management –
Applications | Questions and Answers | Grade
A | 100% Correct (Verified Answers). WGU
1. set: A set is an unordered collection of elements enclosed in braces.
2. tuple: A tuple is an ordered collection of elements enclosed in parentheses.
3. table: A table has a name, a fixed tuple of columns, and a varying set of
rows.
4. column: A column has a name and a data type.
5. row: A row is an unnamed tuple of values. Each value corresponds to a
column and belongs to the column's data type.
6. data type: A data type is a named set of values, from which column values
are drawn.
7. relational algebra: These operations are collectively called relational
algebra and are the theoretical foundation of the SQL language.
,8. Relational rules: Relational rules are part of the relational model and
govern data in every relational database.
9. Business rules: Business rules are based on business policy and specific to
a particular database.
10. constraints: Relational rules are implemented as SQL constraints and
enforced by the database system.
11. Structured Query Language / SQL: Structured Query Language (SQL)
is a high-level computer language for storing, manipulating, and retrieving
data.
12. statement: An SQL statement is a complete command composed of one or
more clauses.
13. clause: A clause groups SQL keywords like SELECT, FROM, and
WHERE with table names like City, column names like Name, and
conditions like Population > 100000.
14. Data Definition Language: Data Definition Language (DDL)
defines the structure of the database.
15. Data Query Language: Data Query Language (DQL) retrieves data from
the database.
,16. Data Manipulation Language: Data Manipulation Language (DML)
manipulates data stored in a database.
17. Data Control Language: Data Control Language (DCL) controls database
user access.
18. Data Transaction Language: Data Transaction Language (DTL) manages
database transactions.
19. CREATE DATABASE DatabaseName: CREATE DATABASE
DatabaseName creates a new database.
20. DROP DATABASE DatabaseName: DROP DATABASE DatabaseName
deletes a database, including all tables in the database.
21. USE DatabaseName: USE DatabaseName selects a default database for
use in subsequent SQL statements.
22. SHOW DATABASES: SHOW DATABASES lists all databases in the
database system instance.
23. SHOW TABLES: SHOW TABLES lists all tables in the default database.
24. SHOW COLUMNS FROM TableName: SHOW COLUMNS FROM
TableName lists all columns in the TableName table of the default database.
, 25. SHOW CREATE TABLE TableName: SHOW CREATE TABLE
TableName
shows the CREATE TABLE statement for the TableName table of the default
database.
26. table: A table has a name, a fixed sequence of columns, and a varying set
of rows.
27. row: A row is an unnamed sequence of values. Each value corresponds to
a column and belongs to the column's data type.
28. cell: A cell is a single column of a single row.
29. empty table: A table without rows is called an empty table.
30. data independence: Rule 4 is called data independence.
31. CREATE TABLE: The CREATE TABLE statement creates a new table
by specifying the table name, column names, and column data types.
32. DROP TABLE: The DROP TABLE statement deletes a table, along with
all the table's rows, from a database.
40 ALTER TABLE: The ALTER TABLE statement adds, deletes, or modifies
columns on an existing table.
D427
D 427 / D427 Pre - Assessment V1 (Latest
Update ) Data Management –
Applications | Questions and Answers | Grade
A | 100% Correct (Verified Answers). WGU
1. set: A set is an unordered collection of elements enclosed in braces.
2. tuple: A tuple is an ordered collection of elements enclosed in parentheses.
3. table: A table has a name, a fixed tuple of columns, and a varying set of
rows.
4. column: A column has a name and a data type.
5. row: A row is an unnamed tuple of values. Each value corresponds to a
column and belongs to the column's data type.
6. data type: A data type is a named set of values, from which column values
are drawn.
7. relational algebra: These operations are collectively called relational
algebra and are the theoretical foundation of the SQL language.
,8. Relational rules: Relational rules are part of the relational model and
govern data in every relational database.
9. Business rules: Business rules are based on business policy and specific to
a particular database.
10. constraints: Relational rules are implemented as SQL constraints and
enforced by the database system.
11. Structured Query Language / SQL: Structured Query Language (SQL)
is a high-level computer language for storing, manipulating, and retrieving
data.
12. statement: An SQL statement is a complete command composed of one or
more clauses.
13. clause: A clause groups SQL keywords like SELECT, FROM, and
WHERE with table names like City, column names like Name, and
conditions like Population > 100000.
14. Data Definition Language: Data Definition Language (DDL)
defines the structure of the database.
15. Data Query Language: Data Query Language (DQL) retrieves data from
the database.
,16. Data Manipulation Language: Data Manipulation Language (DML)
manipulates data stored in a database.
17. Data Control Language: Data Control Language (DCL) controls database
user access.
18. Data Transaction Language: Data Transaction Language (DTL) manages
database transactions.
19. CREATE DATABASE DatabaseName: CREATE DATABASE
DatabaseName creates a new database.
20. DROP DATABASE DatabaseName: DROP DATABASE DatabaseName
deletes a database, including all tables in the database.
21. USE DatabaseName: USE DatabaseName selects a default database for
use in subsequent SQL statements.
22. SHOW DATABASES: SHOW DATABASES lists all databases in the
database system instance.
23. SHOW TABLES: SHOW TABLES lists all tables in the default database.
24. SHOW COLUMNS FROM TableName: SHOW COLUMNS FROM
TableName lists all columns in the TableName table of the default database.
, 25. SHOW CREATE TABLE TableName: SHOW CREATE TABLE
TableName
shows the CREATE TABLE statement for the TableName table of the default
database.
26. table: A table has a name, a fixed sequence of columns, and a varying set
of rows.
27. row: A row is an unnamed sequence of values. Each value corresponds to
a column and belongs to the column's data type.
28. cell: A cell is a single column of a single row.
29. empty table: A table without rows is called an empty table.
30. data independence: Rule 4 is called data independence.
31. CREATE TABLE: The CREATE TABLE statement creates a new table
by specifying the table name, column names, and column data types.
32. DROP TABLE: The DROP TABLE statement deletes a table, along with
all the table's rows, from a database.
40 ALTER TABLE: The ALTER TABLE statement adds, deletes, or modifies
columns on an existing table.
