DeVry University. COMP 230 Final Exam - 2. Complete Solution. Graded A.(TCO 7) What SQL clause is used in a VBScript program to determine the fields to be
... [Show More] 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 [Show Less]