D426 Data Management - Foundations Pre-
Assessment Questions and Correct Answers
Authorization
Which requirement within large, complex databases ensures users have limited access to the
database?
Conceptual design
Which design type specifi es database requirements without regard to a specifi c database
system?
They are logical constraints that ensure the data is valid.
What characterizes the rules of relational databases?
When an SQL statement is syntactically incorrect
Which event will result in an error code and error description when using MySQL Server?
INT
Which data type should be used to store whole integer values, such as age?
MySQL Command-Line Client
Which text-based interface is included in the MySQL Server Download?
MySQL
Which database system includes the World database during its installation?
Structured Query Language
, What is the standardized language of relational database systems?
Data Control Language (DCL)
Which SQL sublanguage is used to manage database access?
Data Transaction Language (DTL)
Which SQL sublanguage is used to roll back database changes?
hh:mm:ss
Which format is used by the TIME data type in MySQL?
OR
Which MySQL operator is the last in the order of operator precedence?
<=
Which operator is used to compare columns from the left and right tables in MySQL?
CROSS
Which type of join combines two tables without comparing columns?
Equijoin
Which type of join compares columns using only the = operator?
EQUIJOIN
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
Assessment Questions and Correct Answers
Authorization
Which requirement within large, complex databases ensures users have limited access to the
database?
Conceptual design
Which design type specifi es database requirements without regard to a specifi c database
system?
They are logical constraints that ensure the data is valid.
What characterizes the rules of relational databases?
When an SQL statement is syntactically incorrect
Which event will result in an error code and error description when using MySQL Server?
INT
Which data type should be used to store whole integer values, such as age?
MySQL Command-Line Client
Which text-based interface is included in the MySQL Server Download?
MySQL
Which database system includes the World database during its installation?
Structured Query Language
, What is the standardized language of relational database systems?
Data Control Language (DCL)
Which SQL sublanguage is used to manage database access?
Data Transaction Language (DTL)
Which SQL sublanguage is used to roll back database changes?
hh:mm:ss
Which format is used by the TIME data type in MySQL?
OR
Which MySQL operator is the last in the order of operator precedence?
<=
Which operator is used to compare columns from the left and right tables in MySQL?
CROSS
Which type of join combines two tables without comparing columns?
Equijoin
Which type of join compares columns using only the = operator?
EQUIJOIN
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
