WGU D426 PAI1 Data Management Foundations
Practice Test Questions and Answers
Status: Passed
1. What does data represent in data management?
YOUR
CORREC
ANSWE
T
R
ANSWE
R
Numeric, textual, visual, or audio information
Unprocessed, arbitrary information
Theoretical models and
abstractions Human
interpretations and opinions
2. What is database system
architecture?
YOUR CORREC
ANSWE T
R ANSWE
R
It describes the components of the system and how those components interact.
It is the set of queries sent to the system that must be either fully
completed or rejected.
It specifically refers to the storage layer of the system.
It specifically refers to the query processor of the system.
3. Which type of theory is the basis for relational data
structure?
YOUR CORREC
ANSWE T
R ANSWE
R
Set theory
Graph theory
Complex design theory
Entity management
theory
4. What is a difference between relational databases and NoSQL ANSWER
databases?
YOUR
, C RECT
O ANSWE
R R
Unlike relational databases, NoSQL databases are optimized for big data.
Relational databases are open-source software, whereas NoSQL
databases are commercial products.
Unlike relational databases, NoSQL databases need a predefined schema to store
data
.
, YOUR
CORREC
ANSWE
T
R
ANSWE
R
Relational databases are used to store sets, whereas NoSQL databases
are used to store tuples.
5. Which statement correctly adds the values 'Strawberry' and 'Red' for the type and color columns,
respectively, in the 'fruits' table?
YOUR
CORREC
ANSWE
T
R
ANSWE
R
INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red');
INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red',
'Seedless'); INSERT INTO fruits (type, color) VALUES ('Red',
'Strawberry');
INSERT INTO fruits (type, 'Strawberry'), (color, 'Red');
6. Which DROP statement deletes a column from an
existing table?
YOUR CORREC
ANSWE T
R ANSWE
R
DROP COLUMN column_name FROM table_name;
DROP table_name COLUMN column_name;
ALTER TABLE DROP COLUMN column_name FROM
table_name; ALTER TABLE table_name DROP COLUMN
column_name;
7. What is an example of an expression in
SQL?
YOUR CORREC
ANSWE T
R ANSWE
R
City = 'Beijing'
134
INSERT
'Welcome'
8. What does the % operator return when using numeric
values?
YOUR CORREC
ANSWE T
R ANSWE
R
Practice Test Questions and Answers
Status: Passed
1. What does data represent in data management?
YOUR
CORREC
ANSWE
T
R
ANSWE
R
Numeric, textual, visual, or audio information
Unprocessed, arbitrary information
Theoretical models and
abstractions Human
interpretations and opinions
2. What is database system
architecture?
YOUR CORREC
ANSWE T
R ANSWE
R
It describes the components of the system and how those components interact.
It is the set of queries sent to the system that must be either fully
completed or rejected.
It specifically refers to the storage layer of the system.
It specifically refers to the query processor of the system.
3. Which type of theory is the basis for relational data
structure?
YOUR CORREC
ANSWE T
R ANSWE
R
Set theory
Graph theory
Complex design theory
Entity management
theory
4. What is a difference between relational databases and NoSQL ANSWER
databases?
YOUR
, C RECT
O ANSWE
R R
Unlike relational databases, NoSQL databases are optimized for big data.
Relational databases are open-source software, whereas NoSQL
databases are commercial products.
Unlike relational databases, NoSQL databases need a predefined schema to store
data
.
, YOUR
CORREC
ANSWE
T
R
ANSWE
R
Relational databases are used to store sets, whereas NoSQL databases
are used to store tuples.
5. Which statement correctly adds the values 'Strawberry' and 'Red' for the type and color columns,
respectively, in the 'fruits' table?
YOUR
CORREC
ANSWE
T
R
ANSWE
R
INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red');
INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red',
'Seedless'); INSERT INTO fruits (type, color) VALUES ('Red',
'Strawberry');
INSERT INTO fruits (type, 'Strawberry'), (color, 'Red');
6. Which DROP statement deletes a column from an
existing table?
YOUR CORREC
ANSWE T
R ANSWE
R
DROP COLUMN column_name FROM table_name;
DROP table_name COLUMN column_name;
ALTER TABLE DROP COLUMN column_name FROM
table_name; ALTER TABLE table_name DROP COLUMN
column_name;
7. What is an example of an expression in
SQL?
YOUR CORREC
ANSWE T
R ANSWE
R
City = 'Beijing'
134
INSERT
'Welcome'
8. What does the % operator return when using numeric
values?
YOUR CORREC
ANSWE T
R ANSWE
R
