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...

After using the Database Splitter tool, the tables in the back-end are replaced with ________ to those tables in the front-end

Fill in the blank(s) with correct word

Computer Science & Information Technology

What is a semiheap?

What will be an ideal response?

Computer Science & Information Technology