Given this SQL statement, match the question with the correct answer: SELECT Contribution.SSN, Contribution.PayDate, Contribution.GrossPay, Contribution.[401KEmployee], Contribution.[401KMatch], Contribution.[401KTotal] INTO Archive FROM Contribution WHERE (((Contribution.SSN)="456667778")) ORDER BY Contribution.PayDate

I. What would need to be done to delete the criteria?
II. What would need to be done to change the name of the new database to "Old"?
III. What would need to be done to sort the records in descending order?
IV. What would need to be done to sort by the default field?
V. What would need to be done to not create the new table?

A. Delete INTO Archive
B. Delete WHERE (((Contribution.SSN)="456667778"))
C. Delete ORDER BY Contribution.PayDate
D. ORDER BY Contribution.PayDate DESC
E. INTO Old


B, E, D, C, A

Computer Science & Information Technology

You might also like to view...

Arduino was developed by ________

A) Massito Hirahito B) Intel C) Massimo Banzi D) Sony

Computer Science & Information Technology

In order to use the Find and Replace dialog box to find a paragraph mark in your document, press the Enter key in the Find what: box

Indicate whether the statement is true or false

Computer Science & Information Technology

An exception that can be recognized by the compiler is a(n) ____.

A. unchecked exception B. checked exception C. compiler exception D. execution exception

Computer Science & Information Technology

IPv6 will use the IPsec Tunnel mode by default.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology