Comp 230 final exam | Computer Science homework help

                  COMP 230 Introduction to Scripting and Database with Lab – DeVry


Final Exam: Page 1

1. (TCO 2) What is an example of a string constant? (Points : 5)

2. (TCO 2) What is the assignment operator? (Points : 5)

3. (TCO 2) The symbols used to describe the logic of a program are known as _____. (Points : 5)

4. (TCO 2) If a variable holds the value 12345, what is its data type? (Points : 5)

5. (TCO 3) The logical AND operator can replace ____ in how it behaves. (Points : 5)

6. (TCO 3) Which pseudocode produces the same result as the following? if customerAge > 65 OR customerAge = 65 then discount = 0.10 else discount = 0 endif (Points : 5)

7. (TCO 3) What logic operator could be used to replace the nested selection structure in this pseudocode?

8. (TCO 3) In order to have the most efficient program, which question should be asked first when working with an AND decision? (Points : 5)

9. (TCO 3) If you are asked to write a program that prints a list of books that have fewer than 30 pages and more than 100 pages, what type of decision structure would you use? (Points : 5)

10. (TCO 3) A ______ represents only one of two states, usually expressed as true or false. (Points : 5)

11. (TCO 4) How many times will the following loop execute?

12. (TCO 4) Array subscripts are always ____. (Points : 5)

13. (TCO 4) When a loop-control variable is not altered during loop execution, a(n) _____ loop may result. (Points : 5)

14. (TCO 4) A loop-control variable that is incremented a specific number of times is known as a(n)_(Points : 5)

15. (TCO 4) A countdown loop operates by the loop-control variable _____. (Points : 5)

16. (TCO 4) All of the elements in an array have the same ____. (Points : 5)

Final Exam: Page 2

1. (TCO 1) Which of the following Windows commands will shut down and restart the computer FileServer in 2 minutes? (Points : 5)

2. (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)

3. (TCO 1) From a 32-bit Windows CLI, the command used to open a new CLI window is __ (Points : 5)

4. (TCO 1) Which one of the following Windows NET commands will allow other computers to access the C:Data directory under the share name UserData? (Points : 5)

5. (TCO 5) What statement is used to indicate the end of a function? (Points : 5)

6. (TCO 5) What variable scope is preferable? (Points : 5)

7. (TCO 5) When writing named constant identifiers, it is a common convention to ______. (Points : 5)

8. (TCO 5) What of the following would most likely be a named constant? (Points : 5)

9. (TCO 6) The following command opens a text file in VBScript. Set file = fso.OpenTextFile(“C:DataCustData.txt”, ?, ??, ???) To open a file for writing, the value of ? must be_(Points : 5)

10. (TCO 6) Once you have a file selected with file = fso.GetFile(“C:DataFile.dat”), what command will allow you to access the file attributes? (Points : 5

11. (TCO 6) The following command opens a text file in VBScript. Set file = fso.OpenTextFile(“C:DataCustData.txt”, ?, ??, ???) To ensure that the file is formatted as ASCII instead of as Unicode, the value of ??? must be _____. (Points : 5)

12. (TCO 6) The following command opens a text file in VBScript. Set file = fso.OpenTextFile(“C:DataCustData.txt”, ?, ??, ???) To open a file for reading, the value of ? must be _____. (Points : 5)

13. (TCO 7) The general syntax of an SQL select statement is _____. (Points : 5)

14. (TCO 7) The questions that cause the database software to extract the appropriate records from a table and specify the fields to be viewed are called ____. (Points : 5)

15. (TCO 7) What is the name for a column that uniquely identifies a record? (Points : 5)

16. (TCO 7) What is the name for a unique key that is constructed from multiple columns? (Points : 5)

Final Exam: Page 3

1(TCO 1)Write the Windows CLI commands thatwill clear the screen; turn off command echo;and display the current IPaddress,subnet mask, and defaultgateway.(Points : 12)

2. (TCO 1) Write the Windows CLI NET commands that will turn the Spooler service OFF and then ON. (Points : 12)

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 : 11)

4. (TCO 3) Given the variable age, write the VBScript code that will decide whether the age is of a teenager or is not of a teenager. Display the message “The value of age is a Teenager” or “The value of age is NOT a Teenager,” depending on the value of the age. (Points : 11)

Final Exam: Page 4

1. (TCO 4) Write the VBScript code that initializes all the variables in the numArray(100) to the value numArray(0)=1, numArray(1)=2,&#-123;,numArray(100)=101. (Points : 11)

2. (TCO 5) Write a VBScript procedure (or subroutine) called Swap(ByRef num1,ByRef num2) that accepts two number variables by reference and exchanges the two values whereby num1 is assigned the original value of num2, and num2 is assigned the original value of num1. (Points : 11)

3. (TCO 6) Write the VBScript code that defines the Scripting.FileSystemObject and the file C:DataDataFile.txt for writing. Make sure that the file will be created if it doesn’t already exist, and ensure that the format is ASCII. (Points : 11)

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, and HDD_Size, write the SQL Query String sqlStr such that the fields Computer, Hostname, and CPU_Type will be displayed for all the records that indicate that CPU_Type is “AMD” and the Bit_Size is 64. The returned records should be sorted by Hostname. (Points : 11) 

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages