vmartinez

What type of join would you use to select all records from the first table and matching records from the second table based on a specified column?

 

• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN

 

What is the purpose of the CASE function?

 

• To sort the result set in ascending or descending order
• To conditionally change or transform values based on specified conditions
• To perform mathematical calculations on numeric fields

 

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