WGU - D426 Study Guide Questions With 100% Verified Solutions 2026
1. Database Man- software that helps business users interact with database systems
agement System
(DBMS)
2. Database Admin- Secures database against unauthorized users
istrator (DBA)
3. Authorization Database systems authorize individual users
4. query processor interprets queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
5. Storage Manager Translates query processor's instructions into file-level data operations. Uses
indexes to quickly location data.
6. Transaction Man- Prevents conflicts between transactions
ager
7. ISUD -INSERT -inserts rows
-SELECT - retrieves data
-UPDATE - modifies data
-DELETE - deletes rows
8. INT stores integers (whole numbers), without decimals, such as 123 or -123
9. DECIMAL stores fractional numeric values
10. VARCHAR values with 0 to N characters
11. DATE stores year, month, day
12. Analysis Specification of database requirements-gathering info for database
13. Database Design Process of determining and implementing database requirements. Covers 3
phases: Analysis, Logical design, Physical Design
, WGU - D426 Study Guide Questions With 100% Verified Solutions 2026
14. Logical Design Implementation of database as tables, keys, columns
15. MySQL Com- a text interface included in the MySQL Server download. MySQL Server returns an
mand-Line Client error code and description when an SQL statement is syntactically incorrect or the
database cannot execute the statement.
16. Tuple ordered set of values in parenthesis Ex: (a,b,c) or (c, b, a)
17. Table Synonyms file, relation
18. Row Synonyms Record, Tuple
19. Column Field, Attribute
20. Business Rules based on business policy and specific to a particular database
21. Literals -Values that are string, numeric or binary
-Strings must be surrounded by single or double quotes
-Binary values are represented with x'0' where 0 is any hex value
Ex: 'String' or "String" or 123 or x'0fa2'
22. DDL Data definition language - defines structure
CREATE, DROP, ALTER, TRUNCATE, RENAME
23. DQL Data Query Language - retrieves data
24. DML Data Manipulation Language - manipulates data stored in a database
25. DCL Data control language - control access to data
26. DTL Data Transaction Language - transaction management used to roll back changes
27. A structured database containing tables that are related to each other
1. Database Man- software that helps business users interact with database systems
agement System
(DBMS)
2. Database Admin- Secures database against unauthorized users
istrator (DBA)
3. Authorization Database systems authorize individual users
4. query processor interprets queries, creates a plan to modify the database or retrieve data, and
returns query results to the application.
5. Storage Manager Translates query processor's instructions into file-level data operations. Uses
indexes to quickly location data.
6. Transaction Man- Prevents conflicts between transactions
ager
7. ISUD -INSERT -inserts rows
-SELECT - retrieves data
-UPDATE - modifies data
-DELETE - deletes rows
8. INT stores integers (whole numbers), without decimals, such as 123 or -123
9. DECIMAL stores fractional numeric values
10. VARCHAR values with 0 to N characters
11. DATE stores year, month, day
12. Analysis Specification of database requirements-gathering info for database
13. Database Design Process of determining and implementing database requirements. Covers 3
phases: Analysis, Logical design, Physical Design
, WGU - D426 Study Guide Questions With 100% Verified Solutions 2026
14. Logical Design Implementation of database as tables, keys, columns
15. MySQL Com- a text interface included in the MySQL Server download. MySQL Server returns an
mand-Line Client error code and description when an SQL statement is syntactically incorrect or the
database cannot execute the statement.
16. Tuple ordered set of values in parenthesis Ex: (a,b,c) or (c, b, a)
17. Table Synonyms file, relation
18. Row Synonyms Record, Tuple
19. Column Field, Attribute
20. Business Rules based on business policy and specific to a particular database
21. Literals -Values that are string, numeric or binary
-Strings must be surrounded by single or double quotes
-Binary values are represented with x'0' where 0 is any hex value
Ex: 'String' or "String" or 123 or x'0fa2'
22. DDL Data definition language - defines structure
CREATE, DROP, ALTER, TRUNCATE, RENAME
23. DQL Data Query Language - retrieves data
24. DML Data Manipulation Language - manipulates data stored in a database
25. DCL Data control language - control access to data
26. DTL Data Transaction Language - transaction management used to roll back changes
27. A structured database containing tables that are related to each other
