COMP 230 Final Exam 2, Complete A+ Test, With Questions And Answers

3. (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:\Data\CustData.txt”)

fso.DeleteFile(“C:\Data\CustData.txt”)

fso.EraseFile(“C:\Data\CustData.txt”)

fso.FileErase(“C:\Data\CustData.txt”)



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:\Data\CustData.txt”)

Set file = fso.CreateFile(“C:\Data\CustData.txt”)

file = fso.CreateFile(“C:\Data\CustData.txt”)

Set file = fso.CreateTextFile(“C:\Data\CustData.txt”)



Question 12.12. (TCO 2) What is an example of a string constant? (Points : 5)

1

"oops"

12432