DeVry University. COMP 230 Final Exam - 3. Complete Solution. Graded A.Question 1. 1. (TCO 7) In an SQL Query statement used in a VBScript program,
what
... [Show More] 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:\Data\CustData.txt”, 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" [Show Less]