The _____ indicates how the two tables should be compared.  

Which choice below will increase the storage capacity of a varchar column so it can store up to 2 gigabytes of data?

When you code a column list in an INSERT statement, you can omit identify columns, columns that have default values, and columns that allow __________ values.

Which data types are used to store whole numbers?

The _____ operator is used to exclude rows that are listed in both tables.

In the INSERT statement that follows, assume that all of the table and column names are spelled correctly, that none of the columns are identity columns, and that none of them have default values or accept null values. What’s wrong with the statement? INSERT INTO InvoiceCopy     (VendorID, InvoiceNumber, InvoiceTotal, PaymentTotal, CreditTotal,     TermsID, InvoiceDate, InvoiceDueDate) VALUES     (97, ‘456789’, 8344.50, 0, 0, 1, ‘2016-08-01’);

You use the UPDATE statement to modify one or more rows in the table named in the

Write the code for a DELETE statement that deletes every row in the Vendors table

Combining columns and values is called

To insert several rows into a table, you can code an INSERT statement with multiple value lists that are separated by what?