SNHU Module 5 Quiz | Latest Update | 2024/2025 | Already Passed

SNHU Module 5 Quiz | Latest Update | 2024/2025 | Already Passed All study groups in your cohort have access to the database of a fantasy trading app for fans of cryptocurrency. For an assignment, your professor asks all groups to query its database, in particular a table titled CurrencyCounter. This table provides the highest estimated percentage of all players that will choose to play in each of three cryptocurrencies and its per-token value in United States dollars (USD) for the next year. CurrencyCounter CryptocurrencyPerTokenValue (USD)PercentageEthereum9530BitcoinCash10135Litecoin4510ZCash6310Monero7415 Another study group has produced these results from their query: Litecoin and ZCash. Which of the following is their query? Select one. SELECT * FROM CurrencyCounter WHERE (Percentage >= 10 AND Percentage <= 30) AND PerTokenValue < 65 Denormalization intentionally introduces redundancy by merging tables and therefore improves query performance. Which types of normal form tables does it result in? Select all that apply. First or Second Form Four properties of the LIKE operator that is used together with the WHERE clause to match text against a pattern are listed below, as are the specific uses of the property. Match the property with its use. Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once. The wildcard character _ - to match exactly one character The wildcard character % - to match any number of characters LIKE by default - LIKE by default LIKE followed by BINARY- LIKE followed by BINARY In a Jeopardy-style online quiz you are playing, the "answers" to the bonus points question on normal forms are listed as the following: "All non-key columns must depend on the whole primary key." "A table with a simple primary key is automatically in this form." "This form does not eliminate all redundancies." To which normal form do these answers apply? Select one. Second normal form True or false: A logical operator always evaluates to NULL when one or both operands are NULL. False When a table is in third normal form, which of these is true? Select one All non-key columns depend on the whole primary key and on no other columns. Which of these are true about NULL values? Select