WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
1. database model A database model is a conceptual framework for data-
base systems, with three parts:
- Data structures that prescribe how data is organized.
- Operations that manipulate data structures.
- Rules that govern valid data.
2. relational model The relational model is a database model based on a
tabular data structure. The model was published in 1970
by E. F. Codd of IBM and released in commercial products
around 1980. The data structure, operations, and rules
are standardized in SQL, the universal query language of
relational databases.
3. big data The rise of the internet in the 1990s generated big data,
characterized by unprecedented data volumes and rapid-
ly changing data structures.
4. set A set is an unordered collection of elements enclosed in
braces.
5. tuple A tuple is an ordered collection of elements enclosed in
parentheses.
6. table A table has a name, a fixed tuple of columns, and a
varying set of rows.
7. column A column has a name and a data type.
8. row A row is an unnamed tuple of values. Each value cor-
responds to a column and belongs to the column's data
type.
9. data type A data type is a named set of values, from which column
values are drawn.
10. relational alge- These operations are collectively called relational algebra
bra and are the theoretical foundation of the SQL language.
11. Relational rules Relational rules are part of the relational model and gov-
ern data in every relational database.
, WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
12. Business rules Business rules are based on business policy and specific
to a particular database.
13. constraints Relational rules are implemented as SQL constraints and
enforced by the database system.
14. Structured Structured Query Language (SQL) is a high-level comput-
Query Language er language for storing, manipulating, and retrieving data.
/ SQL
15. statement An SQL statement is a complete command composed of
one or more clauses.
16. 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.
17. Data Definition Data Definition Language (DDL) defines the structure of
Language the database.
18. Data Query Lan- Data Query Language (DQL) retrieves data from the data-
guage base.
19. Data Manipula- Data Manipulation Language (DML) manipulates data
tion Language stored in a database.
20. Data Control Data Control Language (DCL) controls database user
Language access.
21. Data Transaction Data Transaction Language (DTL) manages database
Language transactions.
22. database system A database system instance is a single executing copy of
instance a database system. Personal computers usually run just
one instance of a database system. Shared computers,
such as computers used for cloud services, usually run
multiple instances of a database system.
23.23.
, CREATE DATA- CREATE DATABASE DatabaseName creates a new
BASE Database- database.
Name
24. DROP DATA- DROP DATABASE DatabaseName deletes a database,
BASE Database- including all tables in the database.
Name
25. USE Database- USE DatabaseName selects a default database for use
Name in subsequent SQL statements.
26. SHOW DATA- SHOW DATABASES lists all databases in the database
BASES system instance.
27. SHOW TABLES SHOW TABLES lists all tables in the default database.
28. SHOW SHOW COLUMNS FROM TableName lists all columns in
COLUMNS the TableName table of the default database.
FROM
TableName
29. SHOW CREATE SHOW CREATE TABLE TableName shows the CREATE
TABLE Table- TABLE statement for the TableName table of the default
Name database.
30. table A table has a name, a fixed sequence of columns, and a
varying set of rows.
31. row A row is an unnamed sequence of values. Each value
corresponds to a column and belongs to the column's
data type.
32. cell A cell is a single column of a single row.
33. empty table A table without rows is called an empty table.
34. data indepen- Rule 4 is called data independence.
dence
35. CREATE TABLE
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
1. database model A database model is a conceptual framework for data-
base systems, with three parts:
- Data structures that prescribe how data is organized.
- Operations that manipulate data structures.
- Rules that govern valid data.
2. relational model The relational model is a database model based on a
tabular data structure. The model was published in 1970
by E. F. Codd of IBM and released in commercial products
around 1980. The data structure, operations, and rules
are standardized in SQL, the universal query language of
relational databases.
3. big data The rise of the internet in the 1990s generated big data,
characterized by unprecedented data volumes and rapid-
ly changing data structures.
4. set A set is an unordered collection of elements enclosed in
braces.
5. tuple A tuple is an ordered collection of elements enclosed in
parentheses.
6. table A table has a name, a fixed tuple of columns, and a
varying set of rows.
7. column A column has a name and a data type.
8. row A row is an unnamed tuple of values. Each value cor-
responds to a column and belongs to the column's data
type.
9. data type A data type is a named set of values, from which column
values are drawn.
10. relational alge- These operations are collectively called relational algebra
bra and are the theoretical foundation of the SQL language.
11. Relational rules Relational rules are part of the relational model and gov-
ern data in every relational database.
, WGU D427 DATA MANAGEMENT APPLICATIONS OA FINAL EXAM MULTIPLE CHOICE &
QUERY BASED QUESTIONS ALL 250 QUESTIONS AND VERIFIED CORRECT ANSWERS
LATEST 2024
12. Business rules Business rules are based on business policy and specific
to a particular database.
13. constraints Relational rules are implemented as SQL constraints and
enforced by the database system.
14. Structured Structured Query Language (SQL) is a high-level comput-
Query Language er language for storing, manipulating, and retrieving data.
/ SQL
15. statement An SQL statement is a complete command composed of
one or more clauses.
16. 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.
17. Data Definition Data Definition Language (DDL) defines the structure of
Language the database.
18. Data Query Lan- Data Query Language (DQL) retrieves data from the data-
guage base.
19. Data Manipula- Data Manipulation Language (DML) manipulates data
tion Language stored in a database.
20. Data Control Data Control Language (DCL) controls database user
Language access.
21. Data Transaction Data Transaction Language (DTL) manages database
Language transactions.
22. database system A database system instance is a single executing copy of
instance a database system. Personal computers usually run just
one instance of a database system. Shared computers,
such as computers used for cloud services, usually run
multiple instances of a database system.
23.23.
, CREATE DATA- CREATE DATABASE DatabaseName creates a new
BASE Database- database.
Name
24. DROP DATA- DROP DATABASE DatabaseName deletes a database,
BASE Database- including all tables in the database.
Name
25. USE Database- USE DatabaseName selects a default database for use
Name in subsequent SQL statements.
26. SHOW DATA- SHOW DATABASES lists all databases in the database
BASES system instance.
27. SHOW TABLES SHOW TABLES lists all tables in the default database.
28. SHOW SHOW COLUMNS FROM TableName lists all columns in
COLUMNS the TableName table of the default database.
FROM
TableName
29. SHOW CREATE SHOW CREATE TABLE TableName shows the CREATE
TABLE Table- TABLE statement for the TableName table of the default
Name database.
30. table A table has a name, a fixed sequence of columns, and a
varying set of rows.
31. row A row is an unnamed sequence of values. Each value
corresponds to a column and belongs to the column's
data type.
32. cell A cell is a single column of a single row.
33. empty table A table without rows is called an empty table.
34. data indepen- Rule 4 is called data independence.
dence
35. CREATE TABLE
