Western Governors University D 426
D426 - Data Management Foundations (Pre-Assessment)
Questions and answer 100% correct
Terms in this set (61)
Which requirement within large, complex C) Authorization
databases ensures users have limited access
to the database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality
Which design type specifies database B) Conceptual Design
requirements without regard to a specific
database system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design
What characterizes the rules of relational They are logical constraints that ensure the data is valid.
databases?
Which event will result in an error code and When an SQL statement is syntactically incorrect
error description when using MySQL
Server?
Which data type should be used to store INT
whole integer values, such as age?
Which text-based interface is included in MySQL Command-Line Client
the MySQL Server Download?
True or False: MySQL includes the World True
database during its installation.
What is the standardized language of Structured Query Language (SQL)
relational database systems?
Which SQL sublanguage is used to manage Data Control Language (DCL)
database access?
Which SQL sublanguage is used to roll back Data Transaction Language (DTL)
database changes?
, Which format is used by the TIME data type hh:mm:ss
in MySQL?
Which MySQL operator is the last in the OR
order of operator precedence?
A) -
B) OR
C) NOT
D) =
Which operator is used to compare columns =
from the left and right tables in MySQL?
Which type of join combines two tables CROSS
without comparing columns?
Which type of join compares columns using Equijoin
only the = operator?
Which type of join is demonstrated by the EQUIJOIN
following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
What is another name for a subquery? Nested Query
Which operator is used to compare against IN
a list of values when determining a match
in a WHERE clause?
Which wildcard character is used to %
represent zero or more characters when
searching for a specified pattern using a
LIKE operator?
Which function is considered an C) MIN
aggregating function in SQL?
A) TRIM
B) REPLACE
C) MIN
D) SUBSTRING
Which clause or function is used with GROUP BY
aggregate functions to produce summary
rows?
D426 - Data Management Foundations (Pre-Assessment)
Questions and answer 100% correct
Terms in this set (61)
Which requirement within large, complex C) Authorization
databases ensures users have limited access
to the database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality
Which design type specifies database B) Conceptual Design
requirements without regard to a specific
database system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design
What characterizes the rules of relational They are logical constraints that ensure the data is valid.
databases?
Which event will result in an error code and When an SQL statement is syntactically incorrect
error description when using MySQL
Server?
Which data type should be used to store INT
whole integer values, such as age?
Which text-based interface is included in MySQL Command-Line Client
the MySQL Server Download?
True or False: MySQL includes the World True
database during its installation.
What is the standardized language of Structured Query Language (SQL)
relational database systems?
Which SQL sublanguage is used to manage Data Control Language (DCL)
database access?
Which SQL sublanguage is used to roll back Data Transaction Language (DTL)
database changes?
, Which format is used by the TIME data type hh:mm:ss
in MySQL?
Which MySQL operator is the last in the OR
order of operator precedence?
A) -
B) OR
C) NOT
D) =
Which operator is used to compare columns =
from the left and right tables in MySQL?
Which type of join combines two tables CROSS
without comparing columns?
Which type of join compares columns using Equijoin
only the = operator?
Which type of join is demonstrated by the EQUIJOIN
following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID
What is another name for a subquery? Nested Query
Which operator is used to compare against IN
a list of values when determining a match
in a WHERE clause?
Which wildcard character is used to %
represent zero or more characters when
searching for a specified pattern using a
LIKE operator?
Which function is considered an C) MIN
aggregating function in SQL?
A) TRIM
B) REPLACE
C) MIN
D) SUBSTRING
Which clause or function is used with GROUP BY
aggregate functions to produce summary
rows?
