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?…
Question 8Suppose you want to calculate when each game in the fun.games table celebrated its 10th anniversary. (For information about this table, see the result of the DESCRIBE statement in…
Question 6Consider this query: SELECT game, shop, price, round(0.08*price,2) AS tax FROM fun.inventory; Which are the correct column names in the header of the result set for this query? 1…
Question 5The result of DESCRIBE fun.games; gives this result: name type commentid intname stringinventor stringyear stringmin_age tinyintmin_players tinyintmax_players tinyintlist_price decimal(5,2)Assume you are using Impala, which does not implicitly cast data…
Question 3The customers table in the default database has columns cust_id, name, and country (all string types). Which of the following are valid SELECT statements? Check all that apply. 1…
Question 2Which of the following can be achieved using a SELECT statement with Hive or Impala? Check all that apply. 1 point Displaying the output of an expression Loading a…
1.Question 1Which is the best description of the SELECT statement in SQL? (Note, this is not referring to the SELECT list.) 1 point The statement most often used to define…
Question 4Which of the following provide a user interface where you can enter and run SQL queries? Check all that apply. 1 point Hue Linux JDBC Impala Shell SQuirreL SQL…
Question 3What are the steps to run a SELECT statement in Hue? 1 point Navigate to the Table Browser and click on the table you want to use. Enter the…
