Pre-Assessment: Data Management - Foundations
1. Which requirement within large, complex databases ensures users have
limited access to the database?: Authorization
2. Which design type specifies database requirements without regard to a
specific database system?: Conceptual design
3. What characterizes the rules of relational databases?: 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 an SQL statement is syntactically incorrect
5. Which data type should be used to store whole integer values, such as
age?: INT
6. Which text-based interface is included in the MySQL Server Download?: -
MySQL Command-Line Client
7. Which database system includes the World database during its installation?:
MySQL
8. What is the standardized language of relational database systems?: Structured
Query Language
9. Which SQL sublanguage is used to manage database access?: Data Control
Language (DCL)
10. Which SQL sublanguage is used to roll back database changes?: Data
Transaction Language (DTL)
11. Which format is used by the TIME data type in MySQL?: hh:mm:ss
12. Which MySQL operator is the last in the order of operator precedence?: OR
13. Which operator is used to compare columns from the left and right tables
1
, in MySQL?: =
14. Which type of join combines two tables without comparing columns?: -
CROSS
15. Which type of join compares columns using only the = operator?: Inner join
16. Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.AddressFROM Dog, KennelWHERE Dog.KennelID
= Kennel.ID: EQUIJOIN
17. What is another name for a subquery?: Nested query
18. Which operator is used to compare against a list of values when determining
a match in a WHERE clause?: IN
19. Which wildcard character is used to represent zero or more characters
when searching for a specified pattern using a LIKE operator?: %
20. Which function is considered an aggregating function in SQL?: MIN
21. Which clause or function is used with aggregate functions to produce
summary rows?: GROUP BY
22. Which type of join returns only the matching values when selecting rows
from two or more tables?: Inner Join
23. Which join type selects only matching left and right table rows?: Inner Join
24. Which phrase refers to the view in which data is persisted and is automatically
changed as the underlying data is changed?: Materialized View
25. Which SQL command uses the correct syntax to update the salary of
an employee in the Employee table?: UPDATE Employee SET Salary = 50000
WHERE ID = 1;
26. What describes elements such as column name and data type?: Metadata
27. Which term identifies an ordered collection of elements enclosed in parenthesis
2
1. Which requirement within large, complex databases ensures users have
limited access to the database?: Authorization
2. Which design type specifies database requirements without regard to a
specific database system?: Conceptual design
3. What characterizes the rules of relational databases?: 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 an SQL statement is syntactically incorrect
5. Which data type should be used to store whole integer values, such as
age?: INT
6. Which text-based interface is included in the MySQL Server Download?: -
MySQL Command-Line Client
7. Which database system includes the World database during its installation?:
MySQL
8. What is the standardized language of relational database systems?: Structured
Query Language
9. Which SQL sublanguage is used to manage database access?: Data Control
Language (DCL)
10. Which SQL sublanguage is used to roll back database changes?: Data
Transaction Language (DTL)
11. Which format is used by the TIME data type in MySQL?: hh:mm:ss
12. Which MySQL operator is the last in the order of operator precedence?: OR
13. Which operator is used to compare columns from the left and right tables
1
, in MySQL?: =
14. Which type of join combines two tables without comparing columns?: -
CROSS
15. Which type of join compares columns using only the = operator?: Inner join
16. Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.AddressFROM Dog, KennelWHERE Dog.KennelID
= Kennel.ID: EQUIJOIN
17. What is another name for a subquery?: Nested query
18. Which operator is used to compare against a list of values when determining
a match in a WHERE clause?: IN
19. Which wildcard character is used to represent zero or more characters
when searching for a specified pattern using a LIKE operator?: %
20. Which function is considered an aggregating function in SQL?: MIN
21. Which clause or function is used with aggregate functions to produce
summary rows?: GROUP BY
22. Which type of join returns only the matching values when selecting rows
from two or more tables?: Inner Join
23. Which join type selects only matching left and right table rows?: Inner Join
24. Which phrase refers to the view in which data is persisted and is automatically
changed as the underlying data is changed?: Materialized View
25. Which SQL command uses the correct syntax to update the salary of
an employee in the Employee table?: UPDATE Employee SET Salary = 50000
WHERE ID = 1;
26. What describes elements such as column name and data type?: Metadata
27. Which term identifies an ordered collection of elements enclosed in parenthesis
2
