Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
3 Cards in this Set
- Front
- Back
|
COMP 230 Final Exam (Devry)
http://www.fres-courses.com/product/comp-230-final-exam-devry |
COMP 230 Final Exam (Devry) 1. (TCO 7) The general syntax of an SQL select statement is _____. 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? 3. (TCO 7) The _____ in a table is the column that makes each record different from all others 4. (TCO 7) What task(s) are involved in designing a database table? 5. (TCO 1) Which of the following Windows commands will shutdown and restartthe computer FileServer in 2 minutes? 6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a remote computer? 7. (TCO 1) Which one of the following Windows NET commands options is not used to control services with the NET ?????ServiceName? 8. (TCO 1) The NETSH command that will set the IP address of the interface name NIC to a DHCP-supplied IP address is _____. 9. (TCO 6) The following VBScript statement will open a text file 10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with 11. (TCO 6) The following VBScript statement will open a text file. 12. (TCO 2) What is the problem with the following statement? average = (60 + 75) /100 13. (TCO 2) What is the multiplication operator? 14. (TCO 2) What is the assignment operator? 15. (TCO 2) What is the best choice for a variable name representing an interest rate 16. (TCO 2) If a variable holds the value “Ferrari,” what is its data type? 17. (TCO 5) In what way do VBScript named constants differ from variables? 18. (TCO 5) Variables declared in the main section of a VBScript program have what scope? 19. (TCO 3) What characters can be used to force operator precedence? 20. (TCO 3) What produces the same result as the following pseudocode? 21. (TCO 3) What VBScript Boolean operator could be used to replace the nested selection structure in this pseudocode? 22. (TCO 3) In VBScript, when you combine Boolean operators, the _____ operators take precedence, meaning their values are evaluated first 23. (TCO 3) A decision that is inside of another decision is known as a _____ decision 24. (TCO 4) What is the problem with the following VBScript Do While loop? 25. (TCO 4) The number of elements in an array is called the _____ of the array 26. (TCO 4) How many times will the following VBScript Do While loop execute the loop body? 27. (TCO 4) VBScript arrays are most efficiently processed using _____. 28. (TCO 4) In VBScript, the array declaration dim data(10) indicates the array data can have a maximum of _____ elements or components 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 2. (TCO 1) Write the Windows CLI NET commands that will turn the Spoolerservice OFF and then ON 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 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 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) 2. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest to the two numbers 3. (TCO 6) Write the VBScript code that defines the Scripting.FileSystemObject and the file C:\Data\DataFile.txt for writing. Make sure the file will be created if it doesn’t exist, and ensure that the format is ASCII 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
|
|
|
COMP 230 Final Exam (Devry)
http://www.fres-courses.com/product/comp-230-final-exam-devry |
COMP 230 Final Exam (Devry) 1. (TCO 7) The general syntax of an SQL select statement is _____. 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? 3. (TCO 7) The _____ in a table is the column that makes each record different from all others 4. (TCO 7) What task(s) are involved in designing a database table? 5. (TCO 1) Which of the following Windows commands will shutdown and restartthe computer FileServer in 2 minutes? 6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a remote computer? 7. (TCO 1) Which one of the following Windows NET commands options is not used to control services with the NET ?????ServiceName? 8. (TCO 1) The NETSH command that will set the IP address of the interface name NIC to a DHCP-supplied IP address is _____. 9. (TCO 6) The following VBScript statement will open a text file 10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with 11. (TCO 6) The following VBScript statement will open a text file. 12. (TCO 2) What is the problem with the following statement? average = (60 + 75) /100 13. (TCO 2) What is the multiplication operator? 14. (TCO 2) What is the assignment operator? 15. (TCO 2) What is the best choice for a variable name representing an interest rate 16. (TCO 2) If a variable holds the value “Ferrari,” what is its data type? 17. (TCO 5) In what way do VBScript named constants differ from variables? 18. (TCO 5) Variables declared in the main section of a VBScript program have what scope? 19. (TCO 3) What characters can be used to force operator precedence? 20. (TCO 3) What produces the same result as the following pseudocode? 21. (TCO 3) What VBScript Boolean operator could be used to replace the nested selection structure in this pseudocode? 22. (TCO 3) In VBScript, when you combine Boolean operators, the _____ operators take precedence, meaning their values are evaluated first 23. (TCO 3) A decision that is inside of another decision is known as a _____ decision 24. (TCO 4) What is the problem with the following VBScript Do While loop? 25. (TCO 4) The number of elements in an array is called the _____ of the array 26. (TCO 4) How many times will the following VBScript Do While loop execute the loop body? 27. (TCO 4) VBScript arrays are most efficiently processed using _____. 28. (TCO 4) In VBScript, the array declaration dim data(10) indicates the array data can have a maximum of _____ elements or components 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 2. (TCO 1) Write the Windows CLI NET commands that will turn the Spoolerservice OFF and then ON 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 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 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) 2. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest to the two numbers 3. (TCO 6) Write the VBScript code that defines the Scripting.FileSystemObject and the file C:\Data\DataFile.txt for writing. Make sure the file will be created if it doesn’t exist, and ensure that the format is ASCII 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
|
|
|
COMP 230 Final Exam (Devry)
http://www.fres-courses.com/product/comp-230-final-exam-devry |
COMP 230 Final Exam (Devry) 1. (TCO 7) The general syntax of an SQL select statement is _____. 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? 3. (TCO 7) The _____ in a table is the column that makes each record different from all others 4. (TCO 7) What task(s) are involved in designing a database table? 5. (TCO 1) Which of the following Windows commands will shutdown and restartthe computer FileServer in 2 minutes? 6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a remote computer? 7. (TCO 1) Which one of the following Windows NET commands options is not used to control services with the NET ?????ServiceName? 8. (TCO 1) The NETSH command that will set the IP address of the interface name NIC to a DHCP-supplied IP address is _____. 9. (TCO 6) The following VBScript statement will open a text file 10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with 11. (TCO 6) The following VBScript statement will open a text file. 12. (TCO 2) What is the problem with the following statement? average = (60 + 75) /100 13. (TCO 2) What is the multiplication operator? 14. (TCO 2) What is the assignment operator? 15. (TCO 2) What is the best choice for a variable name representing an interest rate 16. (TCO 2) If a variable holds the value “Ferrari,” what is its data type? 17. (TCO 5) In what way do VBScript named constants differ from variables? 18. (TCO 5) Variables declared in the main section of a VBScript program have what scope? 19. (TCO 3) What characters can be used to force operator precedence? 20. (TCO 3) What produces the same result as the following pseudocode? 21. (TCO 3) What VBScript Boolean operator could be used to replace the nested selection structure in this pseudocode? 22. (TCO 3) In VBScript, when you combine Boolean operators, the _____ operators take precedence, meaning their values are evaluated first 23. (TCO 3) A decision that is inside of another decision is known as a _____ decision 24. (TCO 4) What is the problem with the following VBScript Do While loop? 25. (TCO 4) The number of elements in an array is called the _____ of the array 26. (TCO 4) How many times will the following VBScript Do While loop execute the loop body? 27. (TCO 4) VBScript arrays are most efficiently processed using _____. 28. (TCO 4) In VBScript, the array declaration dim data(10) indicates the array data can have a maximum of _____ elements or components 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 2. (TCO 1) Write the Windows CLI NET commands that will turn the Spoolerservice OFF and then ON 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 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 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) 2. (TCO 5) Write a VBScript function called MaxNum that accepts two numbers and returns the largest to the two numbers 3. (TCO 6) Write the VBScript code that defines the Scripting.FileSystemObject and the file C:\Data\DataFile.txt for writing. Make sure the file will be created if it doesn’t exist, and ensure that the format is ASCII 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
|
