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 ArchiveB.Delete WHERE (((Contribution.SSN)="456667778"))C.Delete ORDER BY Contribution.PayDateD.ORDER BY Contribution.PayDate DESCE.INTO Old
Fill in the blank(s) with the appropriate word(s).
B, E, D, C, A
Computer Science & Information Technology
You might also like to view...
Name three ActionScript classes that are available for Adobe AIR only.
What will be an ideal response?
Computer Science & Information Technology
A user should be able to complete all related tasks under a single navigation form rather than having to move from form to form to find different tasks
Indicate whether the statement is true or false
Computer Science & Information Technology
Files can remain in the Web cache for days or weeks.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
A protocol that encrypts information before it is sent across the internet.
A. SMM B. SMS C. SSL
Computer Science & Information Technology