COMP 230 Final Exam 3, Complete A+ Test, With Questions And Answers

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