NEWEST WGU D426 DATA MANAGEMENT FOUNDATION LATEST EXAM 2025 COMPLETE TEST REAL QUESTIONS AND CORRECT VERIFIED SOLUTIONS A NEW UPDATED VERSION 2025)

WGU D426 - Data Management Foundations
b b b b b


Studybonlinebatbhttps://quizlet.com/_evoyts

1. Data numeric, textual, visual, or audio information that de- b b b b b b b


scribes real-world systems.
b b b




2. analog Historically, data was mostly , encod- b b b b b


ed as continuous variations on various physical media.
b b b b b b b




3. digital Today, data is mostly , encoded as
b b b b b b


zeros and ones on electronic and magnetic media.
b b b b b b b




4. database a collection of data in a structured format. In principle,
b b b b b b b b b


can be stored on paper or even clay tablets. In practice, h
b b b b b b b b b b b


owever, modern ones are invariably stored on com-
b b b b b b b


puters.
b




5. database system b software that reads and writes data in a database. en-
b b b b b b b b b


/ database man-
b b bsure data is secure, internally consistent, and available
b b b b b b b b


bagement system / b b at all times. These functions are challenging for large da
b b b b b b b b b


bDBMS tabases with many users, so data base systems are com
b b b b b b b b b


plex.

6. database applica- b software that helps business users interact with data-
b b b b b b b


tion
b base systems.
b b




7. database adminis- - responsible for securing the database system against u
b b b b b b b b


trator
b nauthorized users. b


- enforces procedures for user access and database s b b b b b b b


ystem availability. b




8. database designer determines the format of each data element and the
b b b b b b b b b b


overall database structure. Must balance several prior- b b b b b b


ities, including storage, response time, and support for r
b b b b b b b b b


ules that govern the data. Since these priorities often co
b b b b b b b b b


nflict, database design is technically challenging. b b b b b




9. database program- develops computer programs that utilize a database.
b b b b b b b


mer
b




10. database user b - a consumer of data in a database.
b b b b b b b


request, update, or use stored data to generate reports o
b b b b b b b b b


r information.
b



1b/b51

, WGU D426 - Data Management Foundations
b b b b b


Studybonlinebatbhttps://quizlet.com/_evoyts
- usually access the database via applications but can a
b b b b b b b b


lso submit queries directly to the database system.
b b b b b b b




11. transaction a group of queries that must be either completed or
b b b b b b b b b


rejected as a whole. Execution of some, but not all, queries
b b b b b b b b b b


bresults in inconsistent or incorrect data.
b b b b b




12. query processor
b bbb - interprets queries, creates a plan to modify the data-
b b b b b b b b b


base or retrieve data, and returns query results to the a
b b b b b b b b b b


pplication.
- manages connections from multiple users and com- b b b b b b


piles queries into low-
b b b b


level instructions for the storage engine.
b b b b b




13. query optimization The query processor performs
b b b to en- b b b b


sure the most efficient instructions are executed on the d
b b b b b b b b b


ata.

14. indexes used by the storage manager to quickly locate data.
b b b b b b b b




15. transaction manag- ensures transactions are properly executed.
b b b b b


ber

16. log a file containing a complete record of all inserts, up-
b b b b b b b b b


dates, and deletes processed by the database.
b b b b b b b




17. relational database stores data in tables, columns, and rows, similar to a
b b b b b b b b b b b


spreadsheet.

18. SQL
includes statements that read and write data, create b b b b b b b b


and delete tables, and administer the database system.
b b b b b b b




19. big data
b The growth of the internet in the 1990s generated mas-
b b b b b b b b b


sive volumes of online data, often with poorly structured o
b b b b b b b b b


r missing information.
b b




20. NoSQL The newer non-relational systems, for 'not only SQL',
b b b b b b b


and are optimized for big data.
b b b b b




21. Open source
b



2b/b51

, WGU D426 - Data Management Foundations
b b b b b


Studybonlinebatbhttps://quizlet.com/_evoyts
software that anyone can inspect, copy, and modify with n
b b b b b b b b b


o licensing fee.
b b




22. query a command for a database that typically inserts new
b b b b b b b b


data, retrieves data, updates data, or deletes data from a
b b b b b b b b b b


database.

23. query language b a computer programming language for writing data-
b b b b b b


base queries.b




24. CRUD The four common queries are an acronym for Create,
b b b b b b b b


Read, Update, and Delete data.
b b b b




25. SELECT retrieves data from a table. b b b b




26. UPDATE modifies data in a table. b b b b




27. CREATE TABLE b creates a new table by specifying the table and column
b b b b b b b b b


names.

28. data type
b Each column is assigned a
b that indi- b b b b b


cates the format of column values and can be numeric, text
b b b b b b b b b b


ual, or complex.
b b




29. database design b a specification of database objects such as tables,
b b b b b b b


columns, data types, and indexes. Also refers to the proce
b b b b b b b b b


ss used to develop the specification.
b b b b b




30. analysis
specifies database requirements without regard to b b b b b b


a specific database system.
b b b




31. ER diagrams
b depicts entities, relationships, and attributes.
b b b b




32. logical design b implements database requirements in a specific data- b b b b b b


base system. specifies tables, columns, and keys.
b b b b b b




33. key a column used to identify individual rows of a table.
b b b b b b b b b




34. table diagram
b depicts the logical design.
b b b




3b/b51

, WGU D426 - Data Management Foundations
b b b b b


Studybonlinebatbhttps://quizlet.com/_evoyts
35. schema The logical design, as specified in SQL and depicted in
b b b b b b b b b


a table diagram.
b b




36. data independence The principle that physical design never affects query
b b b b b b b b b


results.

37. application pro- b a library of procedures or classes that links a host progra
b b b b b b b b b b


bgramming inter b mming language to a database. b b b b


- face / API
b b b




38. MySQL a leading relational database system sponsored by
b b b b b b


Oracle.

39. MySQL Community a free edition.
b b b


/MySQL Server b




40. MySQL Enterprise a paid edition for managing commercial databases,
b b b b b b b


includes MySQL Server and additional administrative app b b b b b b


ications.
41. root account
b the administrative account that has full control of
b b b b b b b


MySQL.

42. MySQL Com- b a text interface included in the MySQL Server down-
b b b b b b b b


mand-Line Client b load. allows developers to connect to the database serv
b b b b b b b b b


er, perform administrative functions, and execute SQL st
b b b b b b b


atements.

43. error code b returned by MySQL Server with a description when an
b b b b b b b b


SQL statement is syntactically incorrect or the data-
b b b b b b b


bbase cannot execute the statement.
b b b b




44. MySQL Workbench is installed with MySQL Server and allows developers
b b b b b b b b b


to execute SQL commands using an editor. b b b b b b




45. database model b a conceptual framework for database systems, with
b b b b b b


three parts: b


- Data structures: that prescribe how data is organized.
b b b b b b b


- Operations: that manipulate data structures. b b b b


- Rules: that govern valid data. b b b b




4b/b51