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

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?

You need to create a simple database backup in the server's Z:\Backups directory. Which query should you use?

Though not currently a requirement, what will a future release of SQL Server require of all SQL statements?Though not currently a requirement, what will a future release of SQL Server require of all SQL statements?

Which is the best approach to update the last name and email address of a student with ID 56295?

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

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?

What is an example of a DDL command in SQL?

The keywords AND, IN, LIKE, and between all belong to a category called what?

Which answer is NOT a type of table index?