WGU D427 Data Management – Applications Practice Questions
https://www.stuvia.com/user/stuviaun
_ Complete 1https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
Study Guide _ OA Prep _ SQL Questions & Answershttps://www.stuvia.com/user/stu
https://www.stuvia.com/user/stuviaun
WGU D427 Data Management – Applications Practice Questions |
Complete Study Guide | OA Prep | SQL Questions & Answers
https://www.stuvia.com/user/stuviaun
D427 Data
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
Management – Applications Practice Questions _ Complete
https://www.stuvia.com/user/stuviaun
Study Guide _ OA Prep _ SQL Questions & Answershttps://www.stuvia.com/user/stuviaun
, WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
2https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU D427 Practice Questions
Study online at https://quizlet.com/_en5ui3
1. What is a datbase? A structured collection of data
2. Which component is responsible for executing in- Storage engine
structions from the query processor?
3. The BETWEEN operator checks if a value is: Between an inclusive range of
two values
4. Which relationship involves a salesperson and prod- Binary
ucts they sell?
5. What does the 'many' in a 1-M relationship imply? No exact numerical limit but
more than one
6. MySQL architecture is organized into how many lay- Four
ers?
7. In a unary relationship, what kind of relationship is A relationship where an entity
described? is related to itself
8. What does modality represent in an ER Diagram? The minimum number of enti-
ty occurrences that can be in-
volved in a relationship
9. Which storage media has the fastest access time? Main memory (RAM)
10. Which of the following is NOT a characteristic of a Stores data in an unstructured
database system? format
11. Which SQL command is used to delete a table? DROP TABLE
12. MySQL Workbench is designed for: Both database administrators
and users
13.
1/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
, WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
3https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU D427 Practice Questions
Study online at https://quizlet.com/_en5ui3
What is a primary function of a Database Manage- Managing database security
ment System (DBMS)? and access
14. What is an associative entity? An entity that is used to rep-
resent a many-to-many rela-
tionship with attributes
15. The IN operator is used in a WHERE clause to: Check if a value matches any
value in a list
16. What does CRUD stand for in the context of data- Create, Read, Update, Delete
base operations?
17. What is an entity in an ER model? A person, place, product, con-
cept, or activity
18. What does a unique attribute signify in ER modeling? An attribute that identifies
each entity instance uniquely
19. What is a composite attribute? An attribute that can be di-
vided into smaller parts, each
representing a more basic at-
tribute
20. Which of the following best represents a ternary A relationship involving three
relationship? different entity types
21. Which operation combines rows from two tables JOIN
based on related columns?
22. What characterizes a table cluster? Interleaves rows of two or
more tables in the same stor-
age area.
2/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
, WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
4https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU D427 Practice Questions
Study online at https://quizlet.com/_en5ui3
23. Who introduced the relational model? E.F. Codd
24. What is the term for a row in a relational database? Tuple
25. _______________ ensures the consistency and validity Referential integrity
of relationships between tables. It dictates that for-
eign key values in one table must either be null or
match primary key values in another table (or the
same table in the case of self-referencing relation-
ships)
26. In SQL, which command is used to add a row of new INSERT INTO
data into a table?
27. To convert a string to lower case in SQL, which func- LOWER()
tion is used?
28. What describes the 'heap table' structure's approach Tracks free space as a linked
to managing free space after row deletion? list for future inserts
29. What is the purpose of an ER Diagram? To visually represent the data
model of a system
30. What is the main advantage of a sorted table? Optimal for queries that read
data in sort order
31. What does the cardinality of a relationship indicate? The maximum and minimum
number of entity instances
that can be involved in a rela-
tionship
32. What is a primary feature of relational databases? Tables
33. PRIMARY KEY
3/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
_ Complete 1https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
Study Guide _ OA Prep _ SQL Questions & Answershttps://www.stuvia.com/user/stu
https://www.stuvia.com/user/stuviaun
WGU D427 Data Management – Applications Practice Questions |
Complete Study Guide | OA Prep | SQL Questions & Answers
https://www.stuvia.com/user/stuviaun
D427 Data
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
Management – Applications Practice Questions _ Complete
https://www.stuvia.com/user/stuviaun
Study Guide _ OA Prep _ SQL Questions & Answershttps://www.stuvia.com/user/stuviaun
, WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
2https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU D427 Practice Questions
Study online at https://quizlet.com/_en5ui3
1. What is a datbase? A structured collection of data
2. Which component is responsible for executing in- Storage engine
structions from the query processor?
3. The BETWEEN operator checks if a value is: Between an inclusive range of
two values
4. Which relationship involves a salesperson and prod- Binary
ucts they sell?
5. What does the 'many' in a 1-M relationship imply? No exact numerical limit but
more than one
6. MySQL architecture is organized into how many lay- Four
ers?
7. In a unary relationship, what kind of relationship is A relationship where an entity
described? is related to itself
8. What does modality represent in an ER Diagram? The minimum number of enti-
ty occurrences that can be in-
volved in a relationship
9. Which storage media has the fastest access time? Main memory (RAM)
10. Which of the following is NOT a characteristic of a Stores data in an unstructured
database system? format
11. Which SQL command is used to delete a table? DROP TABLE
12. MySQL Workbench is designed for: Both database administrators
and users
13.
1/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
, WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
3https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU D427 Practice Questions
Study online at https://quizlet.com/_en5ui3
What is a primary function of a Database Manage- Managing database security
ment System (DBMS)? and access
14. What is an associative entity? An entity that is used to rep-
resent a many-to-many rela-
tionship with attributes
15. The IN operator is used in a WHERE clause to: Check if a value matches any
value in a list
16. What does CRUD stand for in the context of data- Create, Read, Update, Delete
base operations?
17. What is an entity in an ER model? A person, place, product, con-
cept, or activity
18. What does a unique attribute signify in ER modeling? An attribute that identifies
each entity instance uniquely
19. What is a composite attribute? An attribute that can be di-
vided into smaller parts, each
representing a more basic at-
tribute
20. Which of the following best represents a ternary A relationship involving three
relationship? different entity types
21. Which operation combines rows from two tables JOIN
based on related columns?
22. What characterizes a table cluster? Interleaves rows of two or
more tables in the same stor-
age area.
2/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
, WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
4https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
WGU D427 Practice Questions
Study online at https://quizlet.com/_en5ui3
23. Who introduced the relational model? E.F. Codd
24. What is the term for a row in a relational database? Tuple
25. _______________ ensures the consistency and validity Referential integrity
of relationships between tables. It dictates that for-
eign key values in one table must either be null or
match primary key values in another table (or the
same table in the case of self-referencing relation-
ships)
26. In SQL, which command is used to add a row of new INSERT INTO
data into a table?
27. To convert a string to lower case in SQL, which func- LOWER()
tion is used?
28. What describes the 'heap table' structure's approach Tracks free space as a linked
to managing free space after row deletion? list for future inserts
29. What is the purpose of an ER Diagram? To visually represent the data
model of a system
30. What is the main advantage of a sorted table? Optimal for queries that read
data in sort order
31. What does the cardinality of a relationship indicate? The maximum and minimum
number of entity instances
that can be involved in a rela-
tionship
32. What is a primary feature of relational databases? Tables
33. PRIMARY KEY
3/7
https://www.stuvia.com/user/stuviaunhttps://www.stuvia.com/user/stuviaun
https://www.stuvia.com/user/stuviaun
WGU D427 Practice Questionshttps://www.stuvia.com/user/stuviaun
