COMP 230 Final Exam 3 - Complete Solutions, Graded A

COMP 230 Final Exam 3 Question 1. 1. (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 must test true? (Points : 5) OR AND XOR NOT Question 2. 2. (TCO 7) Which one of the following is a correct SELECT clause in a VBScript program for selecting the fields: FirstName and LastName and Age? (Points : 5) SELECT FirstName and LastName and Age SELECT FIELDS(FirstName,LastName,Age SELECT FirstName,LastName,Age SELECT FROM FirstName,LastName,Age Question 3. 3. (TCO 7) What SQL clause is used in a VBScript program to determine the Table or Tables to be accessed in an SQL Query statement? (Points : 5) TABLE FROM SELECT WHERE Question 4. 4. (TCO 7) Which one of the follows fields would be suitable as a primary key in a table that contains employee records? (Points : 5) Area code Last name Birth date Employee number Question 5. 5. (TCO 1) Which Windows shutdown command switch is used to log off the current user of the local computer? (Points : 5) -l /logoff -f /f Question 6. 6. (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) NET USE UserData=C:Data NET SHARE UserData=C:Data NET USE C:Data = UserData NET SHARE C:Data=UserData Question 7. 7. (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 8. 8. (TCO 1) Which of the following Windows commands will shutdown and power down the computer FileServer in 2 minutes? (Points : 5) shutdown -s -m //FileServer -t 2 shutdown -s -m //FileServer -t 120 shutdown -s -m FileServer -t 2 shutdown -s -m FileServer -t 120 Question 9. 9. (TCO 6) What WSH object is required for VBScript File I/O? (Points : 5) Scripting.FileSystemObject FileSystemObject Scripting.FileSystem WScript.FileSystemObject Question 10. 10. (TCO 6) To evaluate whether a file exists or not before you overwrite it in VBScript, use the following command (assuming that fso is an object of type Scripting.FileSystemObject). (Points : 5) If fso.FileCreated(file) Then If fso.FileExists(file) Then If fso.FileNotFound(file) Then If fso.FileFound(file) Then Question 11. 11. (TCO 6) The following VBScript statement will open a text file. Set file = fso.OpenTextFile(“C:DataCustD”, ForWriting) To open this file for writing, the value of ForWriting must be _____. (Points : 5) 1 2 true false Question 12. 12. (TCO 2) Given the rules of operator precedence, what value would the variable contain after the following statement was executed? distance = 2 + 5 * 3 (Points : 5) 21 17 4 3.33 Question 13. 13. (TCO 2) What is an example of a numeric constant? (Points : 5) "1" "oops" 12432 "12332"