WGU D426 Final Exam Review
1. What Is a software that reads and writes data in a
database?: Database management system or DBMS
2. What is a computer programming language for writing
database queries?-
: Query language
3. What is a command for a database that typically inserts
new data, retrieves data, updates data, or deletes data from a
database: Query
4. What is a group of queries that must be either completed
or rejected as a whole?: A transaction
5. What Interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the
application?: A query processor
6. What translates the query processor instructions into low-
level file-system commands that modify or retrieve data?:
Store Manager
7. What ensures transactions are properly executed?:
Transaction Manager
8. What is a file containing a complete record of all inserts,
updates, and deletes processed by the database?: The log
,9. What is a directory of tables, columns, indexes, and other
database ob- jects?: Catalog
10. What is a column, used to identify individual rows of a
table?: A key
11. Which phase implements database requirements in a
specific database system?: Database Logical design phase
12. Which phase specifies database objects such as tables,
columns, data types, and indexes?: Database design phase
13. Which phase specifies database requirements without
regard to a specific database system?: Database analysis
phase
14. Which phase adds indexes and specifies how tables are
organized on storage media?: Database physical design phase
15. What is the name of a leading relational database system
that sponsored by Oracle?: MySQL
16. What is a conceptual framework for database systems,
with three parts?-
: Database model
17. In a database model, what prescribes how data is
organized?: Data struc- tures
18. In a database mode, what manipulates data structures?:
Operations
19. In a database mode, what governs valid data?: Rules
, 20. What command selects a subset of rows of a table?:
Select
21. What command eliminates one or more columns of a
table?: Project
22. What command lists all combination of rows of two
tables?: Product
23. What command combines two tables by comparing related
columns?: Join
24. What command selects all rows of two tables?: Union
1. What Is a software that reads and writes data in a
database?: Database management system or DBMS
2. What is a computer programming language for writing
database queries?-
: Query language
3. What is a command for a database that typically inserts
new data, retrieves data, updates data, or deletes data from a
database: Query
4. What is a group of queries that must be either completed
or rejected as a whole?: A transaction
5. What Interprets queries, creates a plan to modify the
database or retrieve data, and returns query results to the
application?: A query processor
6. What translates the query processor instructions into low-
level file-system commands that modify or retrieve data?:
Store Manager
7. What ensures transactions are properly executed?:
Transaction Manager
8. What is a file containing a complete record of all inserts,
updates, and deletes processed by the database?: The log
,9. What is a directory of tables, columns, indexes, and other
database ob- jects?: Catalog
10. What is a column, used to identify individual rows of a
table?: A key
11. Which phase implements database requirements in a
specific database system?: Database Logical design phase
12. Which phase specifies database objects such as tables,
columns, data types, and indexes?: Database design phase
13. Which phase specifies database requirements without
regard to a specific database system?: Database analysis
phase
14. Which phase adds indexes and specifies how tables are
organized on storage media?: Database physical design phase
15. What is the name of a leading relational database system
that sponsored by Oracle?: MySQL
16. What is a conceptual framework for database systems,
with three parts?-
: Database model
17. In a database model, what prescribes how data is
organized?: Data struc- tures
18. In a database mode, what manipulates data structures?:
Operations
19. In a database mode, what governs valid data?: Rules
, 20. What command selects a subset of rows of a table?:
Select
21. What command eliminates one or more columns of a
table?: Project
22. What command lists all combination of rows of two
tables?: Product
23. What command combines two tables by comparing related
columns?: Join
24. What command selects all rows of two tables?: Union
