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
