D426 WGU - Practice Assesment Multiple Choice Questions
and Verified Answers 100% A+ Graded
Authorization - CORRECT ANSWER -Requirement in large, complex databases that limits users
Conceptual design - CORRECT ANSWER -Design type that specifies database requirements
without a specific system
Relational database rules are characterized by - CORRECT ANSWER -Logical constraints that
ensure the data is valid
What happens when an SQL statement is syntactically incorrect? - CORRECT ANSWER -Error
code and error description in MySQL
What data type is used to store whole integer values, like age? - CORRECT ANSWER -INT
What text-based interface uses MySQL Server Download - CORRECT ANSWER -MySQL
Command-Line Client
What database system includes the World database during install? - CORRECT ANSWER -MySQL
What's the standardized language of relational database systems? - CORRECT ANSWER -
Structed Query Language
Which SQL sublanguage manages database access? - CORRECT ANSWER -Data Control Language
Which SQL sublanguage rolls back database changes? - CORRECT ANSWER -Data Transaction
Language (DTL)
, What format for TIME data type in MySQL? - CORRECT ANSWER -hh:mm:ss
What MySQL operator comes last? - CORRECT ANSWER -OR
What operator to compare columns from left and right tables in MySQL? - CORRECT ANSWER -=
Which type of join combines two tables without comparing columns? - CORRECT ANSWER -
CROSS
Which type of join compares columns using only the '=' operator? - CORRECT ANSWER -
EQUIJOIN
Which type of join is in the following query?
SELECT Dog.Nickname, Kennel.AddressFROM Dog, KennelWHERE Dog.KennelID = Kennel.ID -
CORRECT ANSWER -EQUIJOIN
Another name for a subquery? - CORRECT ANSWER -Nested query
Operator that compares against a list of values when determining a match in a WHERE clause? -
CORRECT ANSWER -IN
Wildcard character that represents zero or more characters when searching for a specified
pattern using a LIKE operator? - CORRECT ANSWER -%/modulo
What function is considered an aggregating function in SQL? - CORRECT ANSWER -MIN
and Verified Answers 100% A+ Graded
Authorization - CORRECT ANSWER -Requirement in large, complex databases that limits users
Conceptual design - CORRECT ANSWER -Design type that specifies database requirements
without a specific system
Relational database rules are characterized by - CORRECT ANSWER -Logical constraints that
ensure the data is valid
What happens when an SQL statement is syntactically incorrect? - CORRECT ANSWER -Error
code and error description in MySQL
What data type is used to store whole integer values, like age? - CORRECT ANSWER -INT
What text-based interface uses MySQL Server Download - CORRECT ANSWER -MySQL
Command-Line Client
What database system includes the World database during install? - CORRECT ANSWER -MySQL
What's the standardized language of relational database systems? - CORRECT ANSWER -
Structed Query Language
Which SQL sublanguage manages database access? - CORRECT ANSWER -Data Control Language
Which SQL sublanguage rolls back database changes? - CORRECT ANSWER -Data Transaction
Language (DTL)
, What format for TIME data type in MySQL? - CORRECT ANSWER -hh:mm:ss
What MySQL operator comes last? - CORRECT ANSWER -OR
What operator to compare columns from left and right tables in MySQL? - CORRECT ANSWER -=
Which type of join combines two tables without comparing columns? - CORRECT ANSWER -
CROSS
Which type of join compares columns using only the '=' operator? - CORRECT ANSWER -
EQUIJOIN
Which type of join is in the following query?
SELECT Dog.Nickname, Kennel.AddressFROM Dog, KennelWHERE Dog.KennelID = Kennel.ID -
CORRECT ANSWER -EQUIJOIN
Another name for a subquery? - CORRECT ANSWER -Nested query
Operator that compares against a list of values when determining a match in a WHERE clause? -
CORRECT ANSWER -IN
Wildcard character that represents zero or more characters when searching for a specified
pattern using a LIKE operator? - CORRECT ANSWER -%/modulo
What function is considered an aggregating function in SQL? - CORRECT ANSWER -MIN
