Comp 230 Week 8 : Final Exam - Final Exam with questions and the correct answers - $13.49   Add to cart

Looking for more study guides & notes to pass COMP230? Find more study material on our COMP230 overview page 

Exam (elaborations)

Comp 230 Week 8 : Final Exam - Final Exam with questions and the correct answers

Comp 230 Week 8 : Final Exam - Final Exam with questions and the correct answers Comp230 Week 8 : Final Exam - Final Exam 1. (TCO 1) The Windows CLI shell command that is used to display all of the environmental variables and their values is _____. (Points : 5) env set var shell Question 2. 2. (TCO 1) The Windows CLI command that is used to display the search path for the executable files is _____. (Points : 5) echo path echo pathext path pathext Question 3. 3. (TCO 1) Which one of the following Windows AT commands specifies an action that will take place at 3:00 p.m.? (Points : 5) at 3:00 command at 3:00 p.m. command at 15:00 command at 14:00 command Question 4. 4. (TCO 1) From the Start/Run dialog, the command used to open the 32-bit Windows command prompt is _____. (Points : 5) command cmd start prompt Question 5. 5. (TCO 2) The value of a string constant will _____. (Points : 5) change during the execution of a program remain the same until it is assigned a new value be on the left side of an assignment operation retain the same value during program execution Question 6. 6. (TCO 2) What is the assignment operator? (Points : 5) = ^ * % Question 7. 7. (TCO 2) What is the division operator? (Points : 5) / ^ * + Question 8. 8. (TCO 2) What is an example of a numeric constant? (Points : 5) "1" "oops" 12432 "12332" Question 9. 9. (TCO 2) String constants and _____ refer to the same concept. (Points : 5) variables string literals numbers numeric identifiers Question 10. 10. (TCO 6) The following VBScript statement will open an existing text file. Set file = fso.OpenTextFile(“C:DataCustD”, ?, ??, ???) To open this file for appending, the value of ? must be _____. (Points : 5) 1 2 8 true Question 11. 11. (TCO 6) The following VBScript statement will open a text file. Set file = fso.OpenTextFile(“C:DataCustD”, ?, ??, ???) To create a new file if it doesn’t exist, the value of ?? must be _____. (Points : 5) 1 2 false true Question 12. 12. (TCO 6) In order to move the file C:DataCustD to C:BackUpCustD in a VBScript program, use the following command ( fso is a Scripting.FileSystemObject). (Points : 5) fso.MoveFile(“C:DataCustD”,”C:BackUpCustD”) fso.MoveFile(”C:BackUpCustD”, “C:DataCustD”) fso.FileMove(“C:DataCustD”,”C:BackUpCustD”) fso.FileMove(”C:BackUpCustD”, “C:DataCustD”) Question 13. 13. (TCO 7) The questioning that causes extraction of data from a relational database is known as _____. (Points : 5) extraction sorting data refining querying Question 14. 14. (TCO 7) In an SQL Query statement used in a VBScript program, what Boolean operator can be used to test a set of conditions whereby any condition being true makes the entire expression true? (Points : 5) OR AND XOR NOT Question 15. 15. (TCO 7) Which field would be suitable as a primary key in a table that contains employee records? (Points : 5) Area code Last name Birth date An employee number Question 16. 16. (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) OR AND XOR NOT Page 2 Question 1. 1. (TCO 5) Which of the following would most likely be a VBScript named constant? (Points : 5) x taxRate isFinished TAX_RATE Question 2. 2. (TCO 5) Intermediate values that are not inputted or displayed should be stored in _____ variables. (Points : 5) unnamed work temporary global Question 3. 3. (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) XOR AND OR NOT Question 4. 4. (TCO 3) What VBScript Boolean operator could be used to combine the following decision-making structure into a single If/Then structure? (Points : 5) XOR AND OR NOT Question 5. 5. (TCO 3) Every decision you make in a computer program involves evaluating one or more _____ expression(s). (Points : 5) mathematical environmental conditional assignment Question 6. 6. (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) if empRate >= 10.00 AND empRate < 20.00 hen print empIdNumber, empLastName, empFirstName end if if empRate >= 10.00 AND empRate < 20.00 then WScript.Echo empIdNumber & empLastName & empFirstName end if if empRate>= 10.00 OR empRate < 20.00 print empIdNumber, empLastName, empFirstName end if if empRate>= 10.00 OR empRate < 20.00 WScript.Echo empIdNumber & empLastName & empFirstName end if Question 7. 7. (TCO 3) What characters can be used to force operator precedence? (Points : 5) Parentheses Dollar signs Question marks Double quotes Question 8. 8. (TCO 4) What is the term used to represent individual items in an array? (Points : 5) Variable Index Element Superscript Question 9. 9. (TCO 4) In VBScript, the first array index is always _____. (Points : 5) -1 0 1 2 Question 10. 10. (TCO 4) A VBScript array stores a _____ in memory. (Points : 5) collection of values single value character value floating point value Question 11. 11. (TCO 4) A loop within another loop is imbedded is known as a(n) _____ loop. (Points : 5) convoluted nested bi-polar sub Question 12. 12. (TCO 4) The number of elements in an array is called the _____ of the array. (Points : 5) width height size depth 13. (TCO 1) Write the NETSH command that will set the IP address of the interface name “NIC” to 192.168.100.10 255.255.255.0 with a default-gateway of 192.168.100.1 and a metric of 1. (Points : 10) Question 14. 14. (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 : 10) Page 3 1. (TCO 2) Give the order of precedence for all of the arithmetic operators and the parentheses. (Points : 10) Question 2. 2. (TCO 3) A movie theater manager says, "Provide a discount to patrons who are under 15 years old and those who are over 55 years old; otherwise, charge the full price." Write the VBScript code that implements this logic. Assume the variables age and price and the constants DISCOUNT_PRICE and FULL_PRICE. (Points : 10) Question 3. 3. (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, Speed, OS_Type, Memory, and HDD_Size. write the SQL Query String sqlStr such that all the fields will be displayed for the records that indicate a speed greater than 2 and a memory value greater than 4. The returned records should be sorted by OS_Type. (Points : 10) Question 4. 4. (TCO 5) Write a VBScript function called Average(num1,num2) that accepts two numbers and returns the average value of the two numbers. (Points : 10)

Preview 2 out of 11  pages

avatar-seller
ianwazaski

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 450,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

$ 13.49
  • (0)
  Add to cart