WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA EXAM
ACTUAL EXAM 2 LATEST VERSIONS 200 QUESTIONS AND CORRECT
VERIFIED ANSWERS)/ALREADY GRADED A
1.Which requirement within large, complex databases ensures users have
H H H H H H H H
limited access to the database?
H H H H H
Recovery
Performance
H
Authorizatio
H
n
Confidentiality: Authorization H
2.Which design type specifies database requirements without regard to a
H H H H H H H H H
specific database system?
H H H
Physical design H
Conceptual design
H H
Logical design
H H
Abstract design: Conceptual design H H H
3.3. What characterizes the rules of relational databases?
H H H H H H H
-They are logical constraints that ensure the data is valid.
H H H H H H H H H
-They are based on business policy and specific databases.
H H H H H H H H
-They represent data volumes and rapidly changing data structures.
H H H H H H H H
-They embody the theoretical foundation of the SQL language.: They are logical
H H H H H H H H H H H
constraints that ensure the data is valid.
H H H H H H H
4.4. Which event will result in an error code and error description when using
H H H H H H H H H H H H H
MySQL Server?
H H
When the server or updates are incorrectly installed
H H H H H H H
When an SQL statement is entered to locate errors in the database When an
H H H H H H H H H H H H H
SQL statement is syntactically incorrect
H H H H H
When a Mac OS shortcut code is used on a Windows OS: When an SQL statemen
H H H H H H H H H H H H H H H
is syntactically incorrect
H H H
5.5. Which data type should be used to store whole integer values, such as
H H H H H H H H H H H H H
age?
H
H H
, NUM
VARCHA
H
R DATE H
INT: INT H
6.6. Which text-based interface is included in the MySQL Server Download?
H H H H H H H H H H
MySQL Command-Line Client
H H
H H
ACTUAL EXAM 2 LATEST VERSIONS 200 QUESTIONS AND CORRECT
VERIFIED ANSWERS)/ALREADY GRADED A
1.Which requirement within large, complex databases ensures users have
H H H H H H H H
limited access to the database?
H H H H H
Recovery
Performance
H
Authorizatio
H
n
Confidentiality: Authorization H
2.Which design type specifies database requirements without regard to a
H H H H H H H H H
specific database system?
H H H
Physical design H
Conceptual design
H H
Logical design
H H
Abstract design: Conceptual design H H H
3.3. What characterizes the rules of relational databases?
H H H H H H H
-They are logical constraints that ensure the data is valid.
H H H H H H H H H
-They are based on business policy and specific databases.
H H H H H H H H
-They represent data volumes and rapidly changing data structures.
H H H H H H H H
-They embody the theoretical foundation of the SQL language.: They are logical
H H H H H H H H H H H
constraints that ensure the data is valid.
H H H H H H H
4.4. Which event will result in an error code and error description when using
H H H H H H H H H H H H H
MySQL Server?
H H
When the server or updates are incorrectly installed
H H H H H H H
When an SQL statement is entered to locate errors in the database When an
H H H H H H H H H H H H H
SQL statement is syntactically incorrect
H H H H H
When a Mac OS shortcut code is used on a Windows OS: When an SQL statemen
H H H H H H H H H H H H H H H
is syntactically incorrect
H H H
5.5. Which data type should be used to store whole integer values, such as
H H H H H H H H H H H H H
age?
H
H H
, NUM
VARCHA
H
R DATE H
INT: INT H
6.6. Which text-based interface is included in the MySQL Server Download?
H H H H H H H H H H
MySQL Command-Line Client
H H
H H
