D427 WGU Data Management Applications Q& A 2025

D427 WGU Data Management Applications Q& A 2025



1. database system
S A blank is a single executing copy of a database system. Person
S S S S S S S S S S S




al computers usually run just one instance of a database syste
2.
S S S S S S S S S S




m. Shared computers, such as computers used for cloud service
S S S S S S S S S


3.
s, usually run multiple instances of a database system.
S S S S S S S S




4. instance
S




5. Data structures
S that prescribe how data is organized.
S S S S S




6. Operations that manipulate data structures.
S S S




7. Rules that govern valid data.
S S S




8. database model
S




A blank is a conceptual framework for database systems, with t
S S S S S S S S S S




hree parts: S




Data structures that prescribe how data is organized. Operations
S S S S S S S S




that manipulate data structures.
S S S




Rules that govern valid data.
S S S S




9. relational model
S The blank is a database model based on a tabular data
S S S S S S S S S S




structure. The model was published in 1970 by E. F. Codd of IBM
S S S S S S S S S S S S S




1S/S
50

, and released in commercial products around 1980. The data str
S S S S S S S S S




ucture, operations, and rules are standard-
S S S S S




S ized in SQL, the universal query language of relational databas
S S S S S S S S S




es.


10. big data
S




The rise of the internet in the 1990s generated big data, charac
S S S S S S S S S S S




terized by unprecedented data volumes and rapid-
S S S S S S




ly changing data structures.
S S S S




11. set
A blank is an unordered collection of elements enclosed in bra
S S S S S S S S S S




ces.


12. tuple
A blank is an ordered collection of elements enclosed in paren
S S S S S S S S S S




theses.


13. table A blank has a name, a fixed tuple of columns, and a
S S S S S S S S S S S




varying set of rows. S S S




14. column A blank has a name and a data type.
S S S S S S S S




2S/S
50

,15. row A blank is an unnamed tuple of values. Each value cor-
S S S S S S S S S S




responds to a column and belongs to the column's data type.
S S S S S S S S S S




16. data type
S A blank is a named set of values, from which column
S S S S S S S S S S




values are drawn. S S




17. relational alge-
S These operations are collectively called relational algebra and are
S S S S S S S S




Sbra S the theoretical foundation of the SQL language.
S S S S S S




18. Relational rules S Relational rules are part of the relational model and gov-
S S S S S S S S S




S ern data in every relational database.
S S S S S




19. Business rules
S




Business rules are based on business policy and specific to a p
S S S S S S S S S S S




articular database. S




20. constraints
Relational rules are implemented as SQL constraints and enfor
S S S S S S S S




ced by the database system.
S S S S




21. Structured Query S S Structured Query Language (SQL) is a high-level comput-
S S S S S S S




Language er language for storing, manipulating, and retrieving data.
S S S S S S S S




/ SQL
S




3S/S
50

, 22. statement
An SQL statement is a complete command composed of one o
S S S S S S S S S S




r more clauses.
S S




23. clause
A clause groups SQL keywords like SELECT, FROM, and WHERE
S S S S S S S S S




S with table names like City, column names like Name, and con
S S S S S S S S S S




ditions like Population > 100000.
S S S S




24. Data Definition L
S S Data Definition Language (DDL) defines the structure of the datab
S S S S S S S S S




anguage ase.

25. Data Query Lan-
S S Data Query Language (DQL) retrieves data from the data- base.
S S S S S S S S S




S guage
Data Manipulation Language (DML) manipulates data stored in a
S S S S S S S S




26. Data Manipula-
S database.
S tion Language
S




27.




4S/S
50