You need to populate a table named EmployeeCopy with data from an existing table named
Employee.
Which statement should you use?

You execute the following statement:

This statement is an example of a/an:

Which keyword would you use in a select statement to return rows that meet a specific condition?

You have a table named Employee that includes the following columns:
EmployeeID Smp1oyeeName Which statement should you use to return the number of rows in the
table?

The Product table contains the following data.

You execute the following statement:
SELECT COUNT(*) FROM Product WHERE Quantity > 18 What is the value returned by this
statement?

Which command should you use to remove a table from a database?

You need to store the contact information for each student in your school database.
You should store each student’s information in a:

Which category of SQL statements is used to add, remove, and modify database structures?

You have a Customer table and an Order table. You join the Customer table with the Order table by
using the CusromerID column.
The results include:
All customers and their orders
Customers who have no orders
Which type of join do these results represent?

Data in a database is stored in: