Questions

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

 

What is the purpose of Common Table Expressions (CTEs) in SQL?

 

• To perform aggregate calculations on grouped records
• To define and store a temporary result set for the duration of a query
• To encapsulate complex queries and improve query readability and maintainability