You need to write a query that returns all Employees that have a LastName starting with the letter A. Which WHERE clause should you use to fill in the blank in this query?

Which query shows the first name, department, and team of all students with the two lowest points?

What is the result of this statement?

Which is the best approach to update the last name of the student Donette Figgins to Smith

Which of these data types is an approximate numeric?

You need to remove all data from a table name Products. Which query fully logs the removal of each record?

Your database currently has a table called Inventory in the Warehouse schema. You need to move the table to the Products schema. Which query accomplishes this goal?

To combine the results of two or more SELECT statements, removing duplicates, which keyword can you use?

What is the result of this query? SELECT 123+'123' AS Result;

You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

To remove all of the content from the Students table but keep the schema, which statement should you use?