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

Questions 16–20

1. 16application · easy

   A data steward needs to find all subscribers whose EmailAddress column contains a NULL value, indicating missing data. Which WHERE clause correctly identifies these records?

   • AWHERE EmailAddress IS NULL
   • BWHERE EmailAddress = NULL
   • CWHERE EmailAddress IS NOT NULL
   • DWHERE EmailAddress = ''
   Reveal Solution Discussion Select an answer first
2. 17application · easy

   A consultant needs a report of all subscribers sorted by last name in alphabetical order, and within the same last name, by first name in alphabetical order. The Subscribers table has LastName and FirstName columns. Which ORDER BY clause achieves this?

   • AORDER BY FirstName ASC, LastName ASC
   • BORDER BY LastName, FirstName DESC
   • CORDER BY LastName DESC, FirstName DESC
   • DORDER BY LastName ASC, FirstName ASC
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   What does NULL represent in a SQL database?

   • AA missing or unknown value
   • BThe number zero
   • CAn empty string
   • DA default value
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which type of JOIN returns only the rows that have matching values in both tables?

   • ALEFT JOIN
   • BINNER JOIN
   • CFULL OUTER JOIN
   • DRIGHT JOIN
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is a subquery in SQL?

   • AA query nested inside another query
   • BA query that uses aggregate functions
   • CA query that returns only one row
   • DA query that joins two tables
   Reveal Solution Discussion Select an answer first