vmartinez

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

 

You have two tables, “Product Inventory” and “Products Sold”. The tables have the same columns and you want to combine their records. However, you want to keep the records from both tables separate and display them as distinct sets. Which SQL operation should you use in this scenario?

 

• ORDER BY
• GROUP BY
• UNION
• JOIN

 

Which statement is used to extract specified fields from a table?

 

• SELECT
• GET
• OPEN
• EXTRACT

 

Which function which returns the average value of the column?

 

• AVG()
• MEAN()
• SUM()
• MEDIAN()