WGU Data Management - Foundations -
D426||questions with correct answers
Which`requirement`within`large,`complex`databases`ensures`users`have`limited`access`to`the
`database?
Recovery
Performance
Authorization
Confidentiality`-`correct`answers`-`Authorization
Which`design`type`specifies`database`requirements`without`regard`to`a`specific`database`sys
tem?
Physical`design
Conceptual`design
Logical`design
Abstract`design`-`correct`answers`-`Conceptual`design
3.`What`characterizes`the`rules`of`relational`databases?
-They`are`logical`constraints`that`ensure`the`data`is`valid.
-They`are`based`on`business`policy`and`specific`databases.
-They`represent`data`volumes`and`rapidly`changing`data`structures.
-They`embody`the`theoretical`foundation`of`the`SQL`language.`-`correct`answers`-
`They`are`logical`constraints`that`ensure`the`data`is`valid.
,4.`Which`event`will`result`in`an`error`code`and`error`description`when`using`MySQL`Server?
When`the`server`or`updates`are`incorrectly`installed
When`an`SQL`statement`is`entered`to`locate`errors`in`the`database
When`an`SQL`statement`is`syntactically`incorrect
When`a`Mac`OS`shortcut`code`is`used`on`a`Windows`OS`-`correct`answers`-
`When`an`SQL`statement`is`syntactically`incorrect
5.`Which`data`type`should`be`used`to`store`whole`integer`values,`such`as`age?
NUM
VARCHAR
DATE
INT`-`correct`answers`-`INT
6.`Which`text-based`interface`is`included`in`the`MySQL`Server`Download?
MySQL`Command-Line`Client
MySQL`Workbench
MySQL`Enterprise
MySQL`Community`-`correct`answers`-`MySQL`Command-Line`Client
7.`Which`database`system`includes`the`World`database`during`its`installation?
MySQL
, MongoDB
Oracle
PostgreSQL`-`correct`answers`-`MySQL
8.`What`is`the`standardized`language`of`relational`database`systems?
Contextual`Query`Language
Structured`Query`Language
Select`Query`Language
Object`Query`Language`-`correct`answers`-`Structured`Query`Language
9.`Which`SQL`sublanguage`is`used`to`manage`database`access?
Data`Definition`Language`(DDL)
Data`Query`Language`(DQL)
Data`Manipulation`Language`(DML)
Data`Control`Language`(DCL)`-`correct`answers`-`Data`Control`Language`(DCL)
10.`Which`SQL`sublanguage`is`used`to`roll`back`database`changes?
Data`Transaction`Language`(DTL)
Data`Manipulation`Language`(DML)
Data`Query`Language`(DQL)
Data`Control`Language`(DCL)`-`correct`answers`-`Data`Transaction`Language`(DTL)
D426||questions with correct answers
Which`requirement`within`large,`complex`databases`ensures`users`have`limited`access`to`the
`database?
Recovery
Performance
Authorization
Confidentiality`-`correct`answers`-`Authorization
Which`design`type`specifies`database`requirements`without`regard`to`a`specific`database`sys
tem?
Physical`design
Conceptual`design
Logical`design
Abstract`design`-`correct`answers`-`Conceptual`design
3.`What`characterizes`the`rules`of`relational`databases?
-They`are`logical`constraints`that`ensure`the`data`is`valid.
-They`are`based`on`business`policy`and`specific`databases.
-They`represent`data`volumes`and`rapidly`changing`data`structures.
-They`embody`the`theoretical`foundation`of`the`SQL`language.`-`correct`answers`-
`They`are`logical`constraints`that`ensure`the`data`is`valid.
,4.`Which`event`will`result`in`an`error`code`and`error`description`when`using`MySQL`Server?
When`the`server`or`updates`are`incorrectly`installed
When`an`SQL`statement`is`entered`to`locate`errors`in`the`database
When`an`SQL`statement`is`syntactically`incorrect
When`a`Mac`OS`shortcut`code`is`used`on`a`Windows`OS`-`correct`answers`-
`When`an`SQL`statement`is`syntactically`incorrect
5.`Which`data`type`should`be`used`to`store`whole`integer`values,`such`as`age?
NUM
VARCHAR
DATE
INT`-`correct`answers`-`INT
6.`Which`text-based`interface`is`included`in`the`MySQL`Server`Download?
MySQL`Command-Line`Client
MySQL`Workbench
MySQL`Enterprise
MySQL`Community`-`correct`answers`-`MySQL`Command-Line`Client
7.`Which`database`system`includes`the`World`database`during`its`installation?
MySQL
, MongoDB
Oracle
PostgreSQL`-`correct`answers`-`MySQL
8.`What`is`the`standardized`language`of`relational`database`systems?
Contextual`Query`Language
Structured`Query`Language
Select`Query`Language
Object`Query`Language`-`correct`answers`-`Structured`Query`Language
9.`Which`SQL`sublanguage`is`used`to`manage`database`access?
Data`Definition`Language`(DDL)
Data`Query`Language`(DQL)
Data`Manipulation`Language`(DML)
Data`Control`Language`(DCL)`-`correct`answers`-`Data`Control`Language`(DCL)
10.`Which`SQL`sublanguage`is`used`to`roll`back`database`changes?
Data`Transaction`Language`(DTL)
Data`Manipulation`Language`(DML)
Data`Query`Language`(DQL)
Data`Control`Language`(DCL)`-`correct`answers`-`Data`Transaction`Language`(DTL)
