Understand How Data Is Retrieved Within a Relational Data Model (I.e. Basic SQL). MARKETING-CLOUD-ENGAGEMENT-CONSULTANT Practice Questions (Page 2)

Questions 6–10

1. 6foundation · easy

   In an ORDER BY clause, what does the DESC keyword do?

   • AFilters rows based on a condition
   • BSorts results in descending order
   • CSorts results in ascending order
   • DRemoves duplicate rows
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which JOIN type returns all rows from the left table and only matching rows from the right table, with NULLs for non-matching right-side columns?

   • AINNER JOIN
   • BLEFT JOIN
   • CRIGHT JOIN
   • DCROSS JOIN
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A consultant needs to find the earliest and latest order dates in the Orders table, along with the total number of orders. Which query returns all three values?

   • ASELECT TOP 1 OrderDate FROM Orders ORDER BY OrderDate
   • BSELECT OrderDate, COUNT(*) FROM Orders GROUP BY OrderDate
   • CSELECT MIN(OrderDate), MAX(OrderDate) FROM Orders
   • DSELECT MIN(OrderDate) AS Earliest, MAX(OrderDate) AS Latest, COUNT(*) AS TotalOrders FROM Orders
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which SQL aggregate function returns the total number of rows in a result set?

   • AMAX
   • BSUM
   • CAVG
   • DCOUNT
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   What is the purpose of the GROUP BY clause in a SQL query?

   • ATo group rows that have the same values in specified columns
   • BTo sort rows in a specific order
   • CTo filter rows based on a condition
   • DTo combine rows from two tables
   Reveal Solution Discussion Select an answer first