COMP 230 Final Exam 3; Latest update 2021

COMP 230 Final Exam 3; Latest update 2021

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