Question 7The following shows just a few rows from a table for students in a school. (GPA is grade point average, where 4.0 means the student is getting the highest…
Question 6Which of the following would provide results that include a row with int_x=-25? Check all that apply. 1 point SELECT * FROM table_name WHERE int_x IN (-50, 0); SELECT…
Question 5The table table_name includes the following row: id bool1 bool2 b​ool33​4 t​rue f​alse t​rueWhich of the following would include that row in the result set? Check all that apply….
Question 4Select the expressions that are equivalent to x != 2 in SQL. Check all that apply. 1 point x < 2 OR x > 2 NOT x = 2…
Question 3Write and run a query on wax.crayons to find colors with 205 as the red value. Which of the following colors are returned? Check all that apply. 1 point…
Question 2The following query will fail: SELECT name, shop, aisle FROM fun.inventory WHERE price + 5; What are the issues with this query? Check all that apply. 1 point The…
Question 1For which of these tasks would you need to use a WHERE clause? Check all that apply. 1 point For a table of pets, including their owners and ages,…
Question 11Which of the following are true of keywords (such as SELECT and FROM) and identifiers (such as names of tables and columns) in Hive and Impala? Check all that…
Question 10You are working in the default database and want to list all the data in the crayons table, which is in the wax database. Which of the following allow…
Question 9The statement DESCRIBE workforce; has the following result: name type commentname stringoccupation stringsalary intWhich is the best statement to get a list of the occupations used in the table?…
