Fix a Query to Achieve the Desired Results. DATA-ANALYST-ASSOCIATE Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   An analyst wants to list all products and the total quantity sold for each product. Products with no sales should still appear with a quantity of 0. The current query returns only products that have been sold. Which change fixes the query? SELECT p.product_name, SUM(s.quantity) AS total_sold FROM products p JOIN sales s ON p.product_id = s.product_id GROUP BY p.product_name;

   • AChange JOIN to FULL OUTER JOIN.
   • BChange JOIN to RIGHT JOIN.
   • CChange JOIN to LEFT JOIN.
   • DRemove the GROUP BY clause.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   After correcting a query, what is the most direct way to verify that the output matches the expected results?

   • ARun the query and compare the result set to the expected output
   • BCheck the query syntax for errors
   • CAsk a colleague to review the query
   • DReview the query logic manually
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A query contains the following line: SELECT customer_name FROM customers WHERE region = 'West; Which change fixes the syntax error?

   • AChange 'West' to "West"
   • BAdd a semicolon after 'West'
   • CRemove the WHERE clause
   • DAdd a closing single quote after 'West'
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   A query is intended to return only the first 5 rows of a result set. The current query returns all rows. Which clause should be added to the query?

   • ALIMIT 5
   • BORDER BY 5
   • CFETCH FIRST 5 ROWS ONLY
   • DWHERE ROWNUM <= 5
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   A query currently returns the columns customer_id and customer_name. The desired output should only include customer_name. Which change to the SELECT clause achieves this?

   • ARemove customer_id from the SELECT list
   • BAdd a WHERE clause filtering customer_id
   • CAdd an alias to customer_name
   • DRename customer_id to customer_name
   Reveal Solution Discussion Select an answer first