WGU D426 Complete Exam OA (New 2023/ 2023 Update) Data Management Foundations | Grade A | Questions and Verified Answers|100% Correct
WGU D426 Complete Exam OA (New 2023/
2023 Update) Data Management Foundations
| Grade A | Questions and Verified
Answers|100% Correct
QUESTION
Requirements are represented as
Answer:
entities, relationships, and attributes. An entity is a person, place, activity, or thing
QUESTION
A relationship is a link
Answer:
between entities, and an attribute is a descriptive property of an entity.
QUESTION
Analysis has many alternative names, such as
Answer:
conceptual design, entity-re- lationship modeling, and requirements definition.
QUESTION
Rectangles represent
Answer:
entities
QUESTION
Entity names appear
Answer:
at the top of rectangles
QUESTION
The logical design phase implements
Answer:
database requirements in a specific database system
QUESTION
. For relational database systems, logical design
Answer:
converts entities, relation- ships, and attributes into tables, keys, and columns.
QUESTION
The physical design phase adds
Answer:
indexes and specifies how tables are orga- nized on storage media.
QUESTION
Physical design affects
Answer:
query processing speed but never affects the query result
QUESTION
The principle that physical design never affects query results is called
Answer:
–
data independence.
QUESTION
Data independence allows
Answer:
database designers to tune query performance without changes to application programs.
QUESTION
To simplify the use of SQL with a general-purpose language
Answer:
database programs typically use an application programming interface
QUESTION
An application programming interface, or API
Answer:
is a library of procedures or classes that links a host programming language to a database.
QUESTION
The MySQL Command-Line Client is
Answer:
a text interface included in the MySQL Server download.
QUESTION
the ‘world’ database
Answer:
a database that is usually installed with MySQL.
QUESTION
MySQL Server returns an error code and description when an
Answer:
SQL state- ment is syntactically incorrect or the database cannot execute the statement.
QUESTION
Data structures
Answer:
that prescribe how data is organized.
QUESTION
Rules
Answer:
govern valid data.
QUESTION
. A tuple is
Answer:
an ordered collection of elements enclosed in parentheses.
QUESTION
A table has a
Answer:
name, a fixed tuple of columns, and a varying set of rows.
Powered by https://learnexams.com/search/study?query=