COMP 230 Final Exam 2 - Complete Solutions, Graded A

COMP 230 Final Exam 2 (TCO 7) What SQL clause is used in a VBScript program to determine the fields to be displayed in an SQL Query statement? (Points : 5) SELECT ORDER BY FIELDS WHERE Question 4.4. (TCO 7) What SQL clause is used in a VBScript program to determine the Table or Tables to be accessed in an SQL Query statement? (Points : 5) TABLE FROM SELECT WHERE Question 5.5. (TCO 1) The name of the service that controls the queue of print jobs with the Windows NET command is _____. (Points : 5) PRINTSPOOL PRINTQUEUE PRINTER SPOOLER Question 6.6. (TCO 1) The NETSH command that will set the IP address of the interface name NIC to 192.168.100.10 255.255.255.0 with a metric of 1 is _____. (Points : 5) netsh interface set ip address “NIC” source=static 192.168.100.10 255.255.255.0 netsh interface ip set address “NIC” source=static 192.168.100.10 255.255.255.0 netsh interface set ip address “NIC” source=static 192.168.100.10 255.255.255.0 1 netsh interface ip set address “NIC” source=static 192.168.100.10 255.255.255.0 1 Question 7.7. (TCO 1) The Windows CLI command that is used to display the extensions recognized as executable files is _____. (Points : 5) pathext echo PATHEXT echo %PATHEXT% echo $PATHEXT$ Question 8.8. (TCO 1) The NETSH command that will set the IP address of the interface name NIC to a DHCP-supplied IP address is _____. (Points : 5) netsh interface set ip address “NIC” source=dhcp netsh interface ip address “NIC” source=dhcp netsh interface ip set address “NIC” source=dhcp netsh interface set ip address source=dhcp “NIC” Question 9.9. (TCO 6) To delete a file in VBScript, use the following command (assuming that fso is a Scripting.FileSystemObject). (Points : 5) fso.FileDelete(“C:DataCustD”) fso.DeleteFile(“C:DataCustD”) fso.EraseFile(“C:DataCustD”) fso.FileErase(“C:DataCustD”) Question 10.10. (TCO 6) What WSH object is required for VBScript File I/O? (Points : 5) Scripting.FileSystemObject FileSystemObject Scripting.FileSystem WScript.FileSystemObject Question 11.11. (TCO 6) To create a new file in a VBScript program, use the following command (assuming that fso is an instance of Scripting.FileSystemObject). (Points : 5) file = fso.CreateTextFile(“C:DataCustD”) Set file = fso.CreateFile(“C:DataCustD”) file = fso.CreateFile(“C:DataCustD”) Set file = fso.CreateTextFile(“C:DataCustD”) Question 12.12. (TCO 2) What is an example of a string constant? (Points : 5) 1 "oops" 12432