WGU D426 Data Management Foundations Final Exam (New 2023/ 2023 Update) | Grade A | Questions and Verified Answers|100% Correct
WGU D426 Data Management Foundations
Final Exam (New 2023/ 2023 Update) | Grade
A | Questions and Verified Answers|100%
Correct
QUESTION
One-to-Many
Answer:
This is the most common relationship. Associates ONE record in ONE table with MULTIPLE
records in another table.
QUESTION
One-to-One
Answer:
Associates only ONE record on one table with ONE record on another table.
QUESTION
Data Manipulation Language (DML)
Answer:
What language am I?
Allows users to access and modify the data to MAKE queries, and GENERATE reports.
Interacting with the data.
QUESTION
Data Definition Language (DDL)
Answer:
What language am I?
Allows a database administrator to DEFINE the database structure, schema, and subschema.
QUESTION
Data Control Language (DCL)
Answer:
What language am I?
Commands that CONTROL a database. Includes administering privileges and committing data.
QUESTION
MySQL Community/MySQL Server
Answer:
Is a FREE EDITION. Includes a complete set of database services and tools, and is suitable for
non-commercial applications such as education.
QUESTION
MySQL Enterprise
Answer:
PAID EDITION for managing commercial databases. Includes MySQL Server AND additional
administrative applications.
QUESTION
MySQL Command-Line Client
Answer:
A text interface included in the MySQL Server download. Allows developers to connect to the
database server, perform administrative functions, and execute SQL statements.
QUESTION
MySQL Workbench
Answer:
Installed with MySQL Server AND allows developers to EXECUTE SQL commands using an
editor.
QUESTION
Database Model
Answer:
A conceptual framework for database software containing 3 parts:
Data Structures
Operations
Rules
QUESTION
Relational Model
Answer:
A database model based on mathematical principles with three parts:
Data Structures
Operations
Rules
QUESTION
Set
Answer:
A collection of values or elements with NO INHERENT order / unordered. Denoted with braces
{}.
QUESTION
Domain
Answer:
A named set of possible database values, such as integers, dictionary words, or logical values
(TRUE and FALSE).
QUESTION
Tuple
Answer:
A finite sequence of values, each drawn from a fixed domain. Ordered in parentheses.
QUESTION
Relation
Answer:
A NAMED set of tuples, all drawn from the same sequence of domains.
QUESTION
Relational Rules/Integrity Rules
Answer:
Logical constraints that ensure data is valid and conforms to business policy. Governs the data.
QUESTION
Structural Rules
Powered by https://learnexams.com/search/study?query=