COMP 230 Final Exam
1. (TCO 7) The general syntax of an SQL select statement is _____. (Points : 5)
2. (TCO 7) In a VBScript SQL Query statement, what Boolean operator can be used to test a set of conditions whereby all conditions must be true? (Points : 5)
3. (TCO 7) The _____ in a table is the column that makes each record different from all others. (Points : 5)
4. (TCO 7) What task(s) are involved in designing a database table? (Points : 5)
5. (TCO 1) Which of the following Windows commands will shutdown and restart the computer FileServer in 2 minutes? (Points : 5)
6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a remote computer? (Points : 5)
7. (TCO 1) Which one of the following Windows NET commands options is not used to control services with the NET ?????ServiceName? (Points : 5)
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)
9. (TCO 6) The following VBScript statement will open a text file.
Set file = fso.OpenTextFile(C:DataCustData.txt, ?, ??, ???)
To create a new file if it doesnt exist, the value of ??must be _____. (Points : 5)
10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with _____.(Points : 5)
11. (TCO 6) The following VBScript statement will open a text file.
Set file = fso.OpenTextFile(C:DataCustData.txt, ?, ??, ???)
To open this file for reading, the value of ?must be _____. (Points : 5)
12. (TCO 2) What is the problem with the following statement? average = (60 + 75) /100 (Points : 5)
13. (TCO 2) What is the multiplication operator? (Points : 5)
14. (TCO 2) What is the assignment operator? (Points : 5)
15. (TCO 2) What is the best choice for a variable name representing an interest rate? (Points : 5)
16. (TCO 2) If a variable holds the value Ferrari, what is its data type? (Points : 5)
17. (TCO 5) In what way do VBScript named constants differ from variables? (Points : 5)
18. (TCO 5) Variables declared in the main section of a VBScript program have what scope? (Points : 5)
19. (TCO 3) What characters can be used to force operator precedence? (Points : 5)
20. (TCO 3) What produces the same result as the following pseudocode?
if empRate>= 10.00 then
if empRate< 20.00 then
print empIdNumber, empLastName, empFirstName
endif
endif (Points : 5)
21. (TCO 3) What VBScript Boolean operator could be used to replace the nested selection structure in this pseudocode?
if empMedicalIns = Y then
if empDentalIns = Y then
print empIdNumber, empLastName, empFirstName
endif
endif (Points : 5)
22. (TCO 3) In VBScript, when you combine Boolean operators, the _____ operators take precedence, meaning their values are evaluated first. (Points : 5)
23. (TCO 3) A decision that is inside of another decision is known as a _____ decision. (Points : 5)
24. (TCO 4) What is the problem with the following VBScript Do While loop?
count = 1
Do While count < 10
WScript.Echo count
Loop (Points : 5)
25. (TCO 4) The number of elements in an array is called the _____ of the array. (Points : 5)
26. (TCO 4) How many times will the following VBScript Do While loop execute the loop body?
count = 0
Do While count < 10
count = count + 1
Loop (Points : 5)
27. (TCO 4) VBScript arrays are most efficiently processed using _____. (Points : 5)
28. (TCO 4) In VBScript, the array declaration dim data(10) indicates the array data can have a maximum of _____ elements or components. (Points : 5)
1. (TCO 1) Write the Windows CLI commands that will Clear the screen; Turn off Command echo; and display the current IP address, Subnet Mask, and Default Gateway. (Points : 13)
2. (TCO 1) Write the Windows CLI NET commands that will turn the Spooler service OFF and then ON. (Points : 13)
3. (TCO 2) Write the VBScript code lines that define a constant TAXRATE that is 25%, a variable basePay that is $1000, and a variable bonusPay that is $500. Calculate the net pay, and assign that value to netPay. Then, calculate the taxes, and assign that value to taxWithheld. (Points : 14)
4. (TC0 3) Given the variables hoursWorked and payRate, write the VBScript code that will calculate grossPay such that all hoursWorked 40 will be paid at time and a half. (Points : 14)
1. (TCO 4) Write the VBScript code that uses a Do Until loop to display all of the integer values stored in the array numArray(100) . (Points : 14)
2. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest to the two numbers. (Points : 14)
3. (TCO 6) Write the VBScript code that defines the Scripting.FileSystemObject and the file C:DataDataFile.txt for writing. Make sure the file will be created if it doesnt exist, and ensure that the format is ASCII. (Points : 14)
4. (TCO 7) Assuming that you are connected to a database called Computers.mdb with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, OS_Type, Memory, Speed and HDD_Size, write the SQL Query String sqlStr such that all the fields will be displayed for the records that indicate a speed less than two and a memory value less than four. The returned records should be sorted by Room_Num. (Points : 14)