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:\Data\CustData.txt”, ?, ??, ???) 



        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:\Data\CustData.txt”, ?, ??, ???) 



        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:\Data\CustData.txt to C:\BackUp\CustData.txt in a VBScript program, use the following command ( fso is a Scripting.FileSystemObject). (Points : 5) fso.MoveFile(“C:\Data\CustData.txt”,”C:\BackUp\CustData.txt”)

  	 fso.MoveFile(”C:\BackUp\CustData.txt”, “C:\Data\CustData.txt”)            



  	 fso.FileMove(“C:\Data\CustData.txt”,”C:\BackUp\CustData.txt”)            fso.FileMove(”C:\BackUp\CustData.txt”, “C:\Data\CustData.txt”)

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)