D426 Data Management - Foundations Pre-Assessment
Study online at https://quizlet.com/_eq6h86
1. Authorization Which requirement within large, complex databases en-
sures users have limited access to the database?
2. Conceptual design Which design type specifi es database requirements with-
out regard to a specifi c database system?
3. They are logical constraints that What characterizes the rules of relational databases?
ensure the data is valid.
4. When an SQL statement is syn- Which event will result in an error code and error descrip-
tactically incorrect tion when using MySQL Server?
5. INT Which data type should be used to store whole integer
values, such as age?
6. MySQL Command-Line Client Which text-based interface is included in the MySQL Server
Download?
7. MySQL Which database system includes the World database dur-
ing its installation?
8. Structured Query Language What is the standardized language of relational database
systems?
9. Data Control Language (DCL) Which SQL sublanguage is used to manage database ac-
cess?
10. Data Transaction Language Which SQL sublanguage is used to roll back database
(DTL) changes?
11. hh:mm:ss Which format is used by the TIME data type in MySQL?
12. OR Which MySQL operator is the last in the order of operator
precedence?
, D426 Data Management - Foundations Pre-Assessment
Study online at https://quizlet.com/_eq6h86
13. <= Which operator is used to compare columns from the left
and right tables in MySQL?
14. CROSS Which type of join combines two tables without comparing
columns?
15. Equijoin Which type of join compares columns using only the =
operator?
16. EQUIJOIN Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
17. In a nested query, the outer What is another name for a subquery?
query is evaluated first.
18. IN Which operator is used to compare against a list of values
when determining a match in a WHERE clause?
19. % Which wildcard character is used to represent zero or more
characters when searching for a specified pattern using a
LIKE operator?
20. MIN Which function is considered an aggregating function in
SQL?
21. GROUP BY Which clause or function is used with aggregate functions
to produce summary rows?
22. Inner Join Which type of join returns only the matching values when
selecting rows from two or more tables?
23. Inner Join
Study online at https://quizlet.com/_eq6h86
1. Authorization Which requirement within large, complex databases en-
sures users have limited access to the database?
2. Conceptual design Which design type specifi es database requirements with-
out regard to a specifi c database system?
3. They are logical constraints that What characterizes the rules of relational databases?
ensure the data is valid.
4. When an SQL statement is syn- Which event will result in an error code and error descrip-
tactically incorrect tion when using MySQL Server?
5. INT Which data type should be used to store whole integer
values, such as age?
6. MySQL Command-Line Client Which text-based interface is included in the MySQL Server
Download?
7. MySQL Which database system includes the World database dur-
ing its installation?
8. Structured Query Language What is the standardized language of relational database
systems?
9. Data Control Language (DCL) Which SQL sublanguage is used to manage database ac-
cess?
10. Data Transaction Language Which SQL sublanguage is used to roll back database
(DTL) changes?
11. hh:mm:ss Which format is used by the TIME data type in MySQL?
12. OR Which MySQL operator is the last in the order of operator
precedence?
, D426 Data Management - Foundations Pre-Assessment
Study online at https://quizlet.com/_eq6h86
13. <= Which operator is used to compare columns from the left
and right tables in MySQL?
14. CROSS Which type of join combines two tables without comparing
columns?
15. Equijoin Which type of join compares columns using only the =
operator?
16. EQUIJOIN Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
17. In a nested query, the outer What is another name for a subquery?
query is evaluated first.
18. IN Which operator is used to compare against a list of values
when determining a match in a WHERE clause?
19. % Which wildcard character is used to represent zero or more
characters when searching for a specified pattern using a
LIKE operator?
20. MIN Which function is considered an aggregating function in
SQL?
21. GROUP BY Which clause or function is used with aggregate functions
to produce summary rows?
22. Inner Join Which type of join returns only the matching values when
selecting rows from two or more tables?
23. Inner Join
