WGU D426 EXAM NEWEST WITH WELL NARRATED
ANSWERS,UPGRADED 2024-2025
1. database application: software that helps business users interact with database
systems.
2. database administrator: responsible for securing the database system against
unauthorized users. and enforces procedures for user access and database system
availability.
3. authorization: Many database users should have limited access to specific ta-
bles, columns, or rows of a database. Database systems authorize individual users
to access specific data.
4. rules: Database systems ensure data is consistent with structural and business
rules
5. query processor: interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
6. query optimization: ensure the most efficient instructions are executed on the
data.
7. storage manager: translates the query processor instructions into low-level
file-system commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the storage manager uses indexes to quickly
locate data.
8. transaction manager: ensures transactions are properly executed. The transac-
tion manager prevents conflicts between concurrent transactions. The transaction
manager also restores the database to a consistent state in the event of a transaction
or system failure.
9. INSERT: inserts rows into a table
10. SELECT: retrieves data from a table
11. UPDATE: modifies data in a table
12. DELETE: deletes rows in a table
13. CREATE TABLE: creates a new table by specifying the table and column names.
Each column is assigned a data type that indicates the format of column values.
Data types can be numeric, textual, or complex.
14. INT: stores integer values
15. DECIMAL: Stores fractional numeric values
16. VARCHAR: stores textual values
17. DATE: stores year, month, day
18. analysis phase: specifies database requirements without regard to a specific
database system. Requirements are represented as entities, relationships, and at-
tributes. An entity is a person, place, activity, or thing. A relationship is a link between
entities, and an attribute is a descriptive property of an entity. AKA conceptual
design, entity-relationship modeling, and requirements definition.
, D426 WGU
Study online at https://quizlet.com/_fcu9gv
19. logical design phase: implements database requirements in a specific data-
base system. For relational database systems, logical design converts entities,
relationships, and attributes into tables, keys, and columns.
20. physical design: adds indexes and specifies how tables are organized on
storage media. Physical design affects query processing speed but never affects
the query result.
21. Data independence: allows database administrators to improve query perfor-
mance by changing the organization of data on storage devices, without affecting
query results.
22. application programming interface (API): To simplify the use of SQL with
a general-purpose language, database programs typically use an application pro-
gramming interface.
23. MySQL Command-Line Client: a text interface included in the MySQL Server
download. MySQL Server returns an error code and description when an SQL
statement is syntactically incorrect or the database cannot execute the statement.
24. tuple: an ordered collection of elements enclosed in parentheses
25. a table has...: a name, a fixed tuple of columns, and a varying set of rows.
26. A column has...: a name and a data type.
27. a row is...: an unnamed tuple of values. Each value corresponds to a column
and belongs to the column's data type.
28. a data-type is...: a named set of values, from which column values are drawn.
29. Business rules: based on business policy and specific to a particular database
30. literals: 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.
31. keywords: Words with special meaning.
32. identifiers: Objects from the database like tables, columns, etc.
33. comments: Statement intended only for humans and ignored by the database
when parsing an SQL statement.
34. Data Definition Language (DDL): defines the structure of the database.
35. Data Query Language (DQL): retrieves data from the database.
36. Data Manipulation language (DML): manipulates data stored in a database
37. Data Control Language (DCL): controls database user access
38. Data Transaction Language (DTL): manages database transactions.
39. empty table: table without rows
40. ALTER TABLE: adds, deletes, or modifies columns on an existing table.
41. BIGINT: 8 bytes
42. INTEGER / INT: 4 bytes
43. MEDIUMINT: 3 bytes.
ANSWERS,UPGRADED 2024-2025
1. database application: software that helps business users interact with database
systems.
2. database administrator: responsible for securing the database system against
unauthorized users. and enforces procedures for user access and database system
availability.
3. authorization: Many database users should have limited access to specific ta-
bles, columns, or rows of a database. Database systems authorize individual users
to access specific data.
4. rules: Database systems ensure data is consistent with structural and business
rules
5. query processor: interprets queries, creates a plan to modify the database or
retrieve data, and returns query results to the application.
6. query optimization: ensure the most efficient instructions are executed on the
data.
7. storage manager: translates the query processor instructions into low-level
file-system commands that modify or retrieve data. Database sizes range from
megabytes to many terabytes, so the storage manager uses indexes to quickly
locate data.
8. transaction manager: ensures transactions are properly executed. The transac-
tion manager prevents conflicts between concurrent transactions. The transaction
manager also restores the database to a consistent state in the event of a transaction
or system failure.
9. INSERT: inserts rows into a table
10. SELECT: retrieves data from a table
11. UPDATE: modifies data in a table
12. DELETE: deletes rows in a table
13. CREATE TABLE: creates a new table by specifying the table and column names.
Each column is assigned a data type that indicates the format of column values.
Data types can be numeric, textual, or complex.
14. INT: stores integer values
15. DECIMAL: Stores fractional numeric values
16. VARCHAR: stores textual values
17. DATE: stores year, month, day
18. analysis phase: specifies database requirements without regard to a specific
database system. Requirements are represented as entities, relationships, and at-
tributes. An entity is a person, place, activity, or thing. A relationship is a link between
entities, and an attribute is a descriptive property of an entity. AKA conceptual
design, entity-relationship modeling, and requirements definition.
, D426 WGU
Study online at https://quizlet.com/_fcu9gv
19. logical design phase: implements database requirements in a specific data-
base system. For relational database systems, logical design converts entities,
relationships, and attributes into tables, keys, and columns.
20. physical design: adds indexes and specifies how tables are organized on
storage media. Physical design affects query processing speed but never affects
the query result.
21. Data independence: allows database administrators to improve query perfor-
mance by changing the organization of data on storage devices, without affecting
query results.
22. application programming interface (API): To simplify the use of SQL with
a general-purpose language, database programs typically use an application pro-
gramming interface.
23. MySQL Command-Line Client: a text interface included in the MySQL Server
download. MySQL Server returns an error code and description when an SQL
statement is syntactically incorrect or the database cannot execute the statement.
24. tuple: an ordered collection of elements enclosed in parentheses
25. a table has...: a name, a fixed tuple of columns, and a varying set of rows.
26. A column has...: a name and a data type.
27. a row is...: an unnamed tuple of values. Each value corresponds to a column
and belongs to the column's data type.
28. a data-type is...: a named set of values, from which column values are drawn.
29. Business rules: based on business policy and specific to a particular database
30. literals: 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.
31. keywords: Words with special meaning.
32. identifiers: Objects from the database like tables, columns, etc.
33. comments: Statement intended only for humans and ignored by the database
when parsing an SQL statement.
34. Data Definition Language (DDL): defines the structure of the database.
35. Data Query Language (DQL): retrieves data from the database.
36. Data Manipulation language (DML): manipulates data stored in a database
37. Data Control Language (DCL): controls database user access
38. Data Transaction Language (DTL): manages database transactions.
39. empty table: table without rows
40. ALTER TABLE: adds, deletes, or modifies columns on an existing table.
41. BIGINT: 8 bytes
42. INTEGER / INT: 4 bytes
43. MEDIUMINT: 3 bytes.
