D426 Data Management - Foundations Pre-Assessment
questions with answers
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
specifi c database system?: Conceptual design
3.What characterizes the rules of relational databases?: They are logical
con- straints 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
installa- tion?: MySQL
8.What is the standardized language of relational database systems?:
Struc- tured 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
1/
11
, 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 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?: Equijoi
16.Which type of join is demonstrated by the following
query? SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID: EQUIJOIN
17.What is another name for a subquery?: In a nested query, the outer
query is evaluated first.
18.Which operator is used to compare against a list of values when
determin- ing 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
2/
11
questions with answers
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
specifi c database system?: Conceptual design
3.What characterizes the rules of relational databases?: They are logical
con- straints 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
installa- tion?: MySQL
8.What is the standardized language of relational database systems?:
Struc- tured 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
1/
11
, 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 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?: Equijoi
16.Which type of join is demonstrated by the following
query? SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID: EQUIJOIN
17.What is another name for a subquery?: In a nested query, the outer
query is evaluated first.
18.Which operator is used to compare against a list of values when
determin- ing 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
2/
11
