Devry COMP230 Final Exam

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 doesn’t 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 doesn’t 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)