Question 1. The NETSH command that will set the IP address of the interface name LocalNet to a DHCP-supplied IP address is _____.

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. Which of the following Windows commands will restart your computer in 5 minutes?

shutdown /r /t 50

shutdown /r /t 300

shutdown t 5 /r

shutdown /t 300 /r

Question 3. Which one of the following Windows NET commands options is NOT used to control services with the NET????? ServiceName?

STOP

START

CONTINUE

DELETE

Question 4. SPOOLER is the name of the service to do what with the WINDOWS NET command?

To control the DHCP server

To stop spooling the DNS service

To control the queue of print jobs

None of the above

Question 5. What is the best choice for a variable name representing an interest rate?

i

interest

ir

interestRate

Question 6. What is the problem with the following statement? lastName = "Jones

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. An English-like statement used to describe the logic of a program is known as _____.

desk checking

pseudocode

flowchart

code map

Question 8. What is the problem with the following statement? average = (60 + 75) /2

Parentheses are not allowed.

Data types don't match.

Average should be in quotes.

There is no problem with this statement.

Question 9. What is the problem with the following statement? 75 = percent

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. Which VBScript Boolean operator has the highest precedence?

And

OR

Not

XOR

Question 11. In VBScript, which relational operator is used to test for the "Greater Than" relationship?

>>

<

>=

>

Question 12. The VBScript Boolean operator AND is used to evaluate multiple conditions where true means _____.

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. What VBScript decision-making statement would be for a single condition and two alternative code blocks to be executed?

If/Then

While

If/Then/Else

Do/Until

Question 14. What VBScript decision-making statement would be for a single condition and a single code block to be executed?

If/Then

While

If/Then/Else

Do/Until

Question 15. Which VBScript statement represents incrementing the loop counter variable called count?

count = 1

while (count <= 10)

count = count + 1

count++

Question 16. A loop that counts down operates by having the loop control variable _____.

initialized

checked

decremented

incremented

Question 17. Which of the following would NOT be a valid comparison to control a While loop?

count <> 10

count > true

count > 1

count * 3 > 100

Question 18. When a VBScript loop control variable is not altered during loop execution, a(n) _____ loop may result.

single pass

indeterminate

endless

default

Question 19. The statements that are repeated during loop execution are called the _____.

loop body or code block

decision statements

loop group

loop variables

Question 20. What name is ***** ***** to a function or subroutine that calculates overtime pay?

calcO()

calculate overtime()

cO()

calculateOvertime()

Question 21. Internal documentation for scripts include _____.

a data dictionary

program comments

a print chart

user manuals

Question 22. What WSH object is required for VBScript File I/O?

Scripting.FileSystemObject

FileSystemObject

Scripting.FileSystem

WScript.FileSystemObject

Question 23. In creating a VBScript Scripting.FileSystemObject, you must start the code line with _____.

Let fso = CreateObject

Set fso = CreateObject

Let fso = new Object

Set fso = new Object

Question 24. Which line will properly create the object for VBScript File I/O?

Set fso = Scripting.FileSystemObject

fso = CreateObject("Scripting.FileSystem")

Set fso = CreateObject("Scripting.FileSystem")

Set fso = CreateObject("WScript.FileSystemObject")

Question 25. What is the name for a field that uniquely identifies a record?

Primary key

Unique key

Foreign key

Table key

Question 26. What is another name used to refer to a record in a database?

Character

Column

Row

Table

Question 27. The _____ in a table is the column that makes each record different from all others.

unique record

primary key

sort key

magic field

Question 28. What is the most commonly used method to extract data from a database?

SQL

MML

C++

Java

1. Write the Windows CLI NET commands that will turn the Spooler service OFF and then ON.

2. Write the Windows CLI NET commands that will turn the WORKSTATION service OFF and then ON.

3. 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. 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".

5. 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. Write a VBScript function called MaxNum that accepts two numbers and returns the largest of the two numbers.