WGU Data Management - Foundations - D426

WGU Data Management - Foundations - gi gi gi gi gi


D426 gi


1.Which requirement within large, complex databases ensures users hav
gi gi gi gi gi gi gi gi

e limited access to the database?
gi gi gi gi gi




Recovery Per gi

formance Au gi

thorization
Confidentiality: Authorization gi

2.Which design type specifies database requirements without regard to
gi gi gi gi gi gi gi gi gi

a specific database system?
gi gi gi




Physical design Conce gi gi

ptual design Logical de
gi gi gi

sign
Abstract design: Conceptual design gi gi gi

3.3. What characterizes the rules of relational databases?
gi gi gi gi gi gi gi




-They are logical constraints that ensure the data is valid.
gi gi gi gi gi gi gi gi gi

-They are based on business policy and specific databases.
gi gi gi gi gi gi gi gi

-They represent data volumes and rapidly changing data structures.
gi gi gi gi gi gi gi gi

-
They embody the theoretical foundation of the SQL language.: They are logic
gi gi gi gi gi gi gi gi gi gi gi

l constraints that ensure the data is valid.
gi gi gi gi gi gi gi


4.4. Which event will result in an error code and error description when usin
gi gi gi gi gi gi gi gi gi gi gi gi gi

g MySQL Server?
gi gi




When the server or updates are incorrectly installed
gi gi gi gi gi gi gi

When an SQL statement is entered to locate errors in the database Wh
gi gi gi gi gi gi gi gi gi gi gi gi

en an SQL statement is syntactically incorrect
gi gi gi gi gi gi

When a Mac OS shortcut code is used on a Windows OS: When an SQL sta
gi gi gi gi gi gi gi gi gi gi gi gi gi gi gi

ement is syntactically incorrect
gi gi gi


5.5. Which data type should be used to store whole integer values, such
gi gi gi gi gi gi gi gi gi gi gi gi gi

as age?
gi




NUM VAR gi

CHAR DA gi

TE
INT: INT gi

6.6. Which text-based interface is included in the MySQL Server Download?
gi gi gi gi gi gi gi gi gi gi




MySQL Command-Line Client gi gi
1gi/
gi16

, WGU Data Management - Foundations - gi gi gi gi gi


D426 gi


MySQL Workbench MyS gi gi

QL Enterprise gi

MySQL Community: MySQL Command-Line Client
gi gi gi gi

7.7. Which database system includes the World database during its install
gi gi gi gi gi gi gi gi gi gi

a- tion? gi




MySQL
MongoDB
Oracle
gi

PostgreSQL: MySQL gi

8.8. What is the standardized language of relational database systems?
gi gi gi gi gi gi gi gi gi




Contextual Query Language gi gi

Structured Query Languag
gi gi gi

e Select Query Language
gi gi gi

Object Query Language: Structured Query Language
gi gi gi gi gi

9.9. Which SQL sublanguage is used to manage database access?
gi gi gi gi gi gi gi gi gi




Data Definition Language (DDL) Da
gi gi gi gi

ta Query Language (DQL)
gi gi gi

Data Manipulation Language (DML)
gi gi gi

Data Control Language (DCL): Data Control Language (DCL)
gi gi gi gi gi gi gi


10.10. Which SQL sublanguage is used to roll back database changes?
gi gi gi gi gi gi gi gi gi gi




Data Transaction Language (DTL)
gi gi gi gi

Data Manipulation Language (DML)
gi gi gi g

Data Query Language (DQL)
i gi gi gi

Data Control Language (DCL): Data Transaction Language (DTL)
gi gi gi gi gi gi gi

11.11. Which format is used by the TIME data type in MySQL?
gi gi gi gi gi gi gi gi gi gi gi




YYYY-MM-DD
YYYY-MM-
DD hh:mm:sshh:mm:ss hh:mm:ss
gi gi gi

YYYY-MM-DD: hh:mm:ss gi

12.12. Which MySQL operator is the last in the order of operator precedence
gi gi gi gi gi gi gi gi gi gi gi gi




-
O
g i

RN gi

OT
2gi/
gi16

, WGU Data Management - Foundations -
gi gi gi gi gi


D426
gi

=: OR gi




3gi/
gi16