Questions

Why might you leverage the PARTITION BY clause in your query?

 

• Partition a table into new sub-tables based on a specified column
• Limit records in the result set to the partition’s date range
• Divide the result set into partitions based on the specified column

 

Which SQL keyword is used to sort your result-set?

 

• ORDER
• SORT BY
• SORT
• ORDER BY

 

What can you accomplish using the CAST function?

 

• Sequester records based on conditions dictated in the function logic
• Convert the values in a field from one datatype to another datatype
• Alter the core attributes of a field within a table

 

Which clause is used to filter the query results based on a condition?

 

• WHERE
• FIND
• WHEN
• FILTER

 

How would you get the count of unique values in a given field?

 

• COUNT() function with DISTINCT clause
• COUNT() function with UNIQUE clause
• TOTAL() function with DISTINCT clause

 

How can you return the number of records in the “campaigns” table?

 

• SELECT COLUMNS(*) FROM campaigns
• SELECT COUNT(*) FROM campaigns
• SELECT NO(*) FROM campaigns
• SELECT LEN(*) FROM campaigns