Question 1.1. (TCO 1) The NETSH command that will set the IP address of the interface name LocalNet to a DHCP-supplied IP address is _____. (Points : 5)
netsh interface set ip address “NIC” source=dhcp
netsh interface ip address “LocalNet” source=dhcp
netsh interface ip set address “LocalNet” source=dhcp
netsh interface set ip address source=dhcp “NIC”

Question 2.2. (TCO 1) Which of the following Windows commands will restart your computer in 5 minutes? (Points : 5)
shutdown /r /t 50
shutdown /r /t 300
shutdown t 5 /r
shutdown /t 300 /r

Question 3.3. (TCO 1) Which one of the following Windows NET commands options is NOT used to control services with the NET????? ServiceName? (Points : 5)
STOP
START
CONTINUE
DELETE

Question 4.4. (TCO 1) SPOOLER is the name of the service to do what with the WINDOWS NET command? (Points : 5)
To control the DHCP server
To stop spooling the DNS service
To control the queue of print jobs
None of the above

Question 5.5. (TCO 2) What is the best choice for a variable name representing an interest rate? (Points : 5)
i
interest
ir
interestRate

Question 6.6. (TCO 2) What is the problem with the following statement? lastName = “Jones (Points : 5)
There is nothing wrong with this assignment.
lastName is ***** ***** descriptive variable name.
Jones should be in double quotes.
Value on the left must be a variable name.

Question 7.7. (TCO 2) An English-like statement used to describe the logic of a program is known as _____. (Points : 5)
desk checking
pseudocode
flowchart
code map

Question 8.8. (TCO 2) What is the problem with the following statement? average = (60 + 75) /2 (Points : 5)
Parentheses are not allowed.
Data types don’t match.
Average should be in quotes.
There is no problem with this statement.

Question 9.9. (TCO 2) What is the problem with the following statement? 75 = percent (Points : 5)
75 is not a reasonable percent value.
Data types don’t match.
75 should be in quotes.
Value on the left must be a variable name.

Question 10.10. (TCO 3) Which VBScript Boolean operator has the highest precedence? (Points : 5)
And
OR
Not
XOR

Question 11.11. (TCO 3) In VBScript, which relational operator is used to test for the “Greater Than” relationship? (Points : 5)
>>
<
>=
>

Question 12.12. (TCO 3) The VBScript Boolean operator AND is used to evaluate multiple conditions where true means _____. (Points : 5)
all conditions must be false
all conditions must be true
any one or more conditions must be false
any one or more conditions must be true

Question 13.13. (TCO 3) What VBScript decision-making statement would be for a single condition and two alternative code blocks to be executed? (Points : 5)
If/Then
While
If/Then/Else
Do/Until

Question 14.14. (TCO 3) What VBScript decision-making statement would be for a single condition and a single code block to be executed? (Points : 5)
If/Then
While
If/Then/Else
Do/Until

Question 1.1. (TCO 4) Which VBScript statement represents incrementing the loop counter variable called count? (Points : 5)
count = 1
while (count <= 10)
count = count + 1
count++

Question 2.2. (TCO 4) A loop that counts down operates by having the loop control variable _____. (Points : 5)
initialized
checked
decremented
incremented

Question 3.3. (TCO 4) Which of the following would NOT be a valid comparison to control a While loop? (Points : 5)
count <> 10
count > true
count > 1
count * 3 > 100

Question 4.4. (TCO 4) When a VBScript loop control variable is not altered during loop execution, a(n) _____ loop may result.(Points : 5)
single pass
indeterminate
endless
default

Question 5.5. (TCO 4) The statements that are repeated during loop execution are called the _____. (Points : 5)
loop body or code block
decision statements
loop group
loop variables

Question 6.6. (TCO 5) What name is ***** ***** to a function or subroutine that calculates overtime pay? (Points : 5)
calcO()
calculate overtime()
cO()
calculateOvertime()

Question 7.7. (TCO 5) Internal documentation for scripts include _____. (Points : 5)
a data dictionary
program comments
a print chart
user manuals

Question 8.8. (TCO 6) What WSH object is required for VBScript File I/O? (Points : 5)
Scripting.FileSystemObject
FileSystemObject
Scripting.FileSystem
WScript.FileSystemObject

Question 9.9. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with _____. (Points : 5)
Let fso = CreateObject
Set fso = CreateObject
Let fso = new Object
Set fso = new Object

Question 10.10. (TCO 6) Which line will properly create the object for VBScript File I/O? (Points : 5)
Set fso = Scripting.FileSystemObject
fso = CreateObject(“Scripting.FileSystem”)
Set fso = CreateObject(“Scripting.FileSystem”)
Set fso = CreateObject(“WScript.FileSystemObject”)

Question 11.11. (TCO 7) What is the name for a field that uniquely identifies a record? (Points : 5)
Primary key
Unique key
Foreign key
Table key

Question 12.12. (TCO 7) What is another name used to refer to a record in a database? (Points : 5)
Character
Column
Row
Table

Question 13.13. (TCO 7) The _____ in a table is the column that makes each record different from all others. (Points : 5)
unique record
primary key
sort key
magic field

Question 14.14. (TCO 7) What is the most commonly used method to extract data from a database? (Points : 5)
SQL
MML
C++
Java

1. (TCO 1) Write the Windows CLI NET commands that will turn the Spooler service OFF and then ON.
2. (TCO 1) Write the Windows CLI NET commands that will turn the WORKSTATION service OFF and then ON.
3. (TCO 2) Write the VBScript code lines that perform the following tasks: define a variable name that is initialized to “John Doe” and a variable age that is initialized to 35. Display a message that uses the variables “Your name is***** and your age is 35.”
4. (TCO 3) Write the VBScript code that implements this logic. Given the numeric variable age, display the message “You are a Senior” if age is greater than or equal to 65, otherwise display the message “You are not a Senior”. (Points : 10)
5. TCO 7) Assuming that you are connected to a database table called Computers with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, OS_Type, Memory, and HDD_Size, write the SQL Query String sqlStr such that the fields Computer, Hostname, and CPU_Type will be displayed for all records CPU_Type is ‘AMD’ and the Bit_Size is 64. The returned records should be sorted by Hostname.
6. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest of the two numbers.