1. (TCO 7) The general syntax of an SQL select statement is _____. (Points : 5)
Select—From—Where
Get—Date—Where
Select—Update—When
Select—Condition—Table
2. (TCO 7) In a VBScript SQL Query statement, what Boolean operator can be used to test a set of
conditions whereby all conditions must be true? (Points : 5)
OR
AND
XOR
NOT
3. (TCO 7) The _____ in a table is the column that makes each record different from all others. (Points :
5)
unique record
primary key
sort key
magic field
4. (TCO 7) What task(s) are involved in designing a database table? (Points : 5)
, Naming each record
Naming each field
Naming each field and providing data types
Inserting all of the data
5. (TCO 1) Which of the following Windows commands will shutdown and restart the computer
FileServer in 2 minutes? (Points : 5)
shutdown -r -m //FileServer -t 2
shutdown -r -m //FileServer -t 120
shutdown -r -m \\FileServer -t 2
shutdown -r -m \\FileServer -t 120
6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a
remote computer? (Points : 5)
-h
/halt
-s
/shut
7. (TCO 1) Which one of the following Windows NET commands options is not used to control services
with the NET ?????ServiceName? (Points : 5)
STOP
, START
CONTINUE
PAUSE
DELETE
8. (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)
netsh interface set ip address “NIC” source=dhcp
netsh interface ip address “NIC” source=dhcp
netsh interface ip set address “NIC” source=dhcp
netsh interface set ip address source=dhcp “NIC”
9. (TCO 6) The following VBScript statement will open a text file.
Set file = fso.OpenTextFile(“C:\Data\CustData.txt”, ?, ??, ???)
To create a new file if it doesn’t exist, the value of ??must be _____. (Points : 5)
1
2
false
true
10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with _____.
(Points : 5)
Select—From—Where
Get—Date—Where
Select—Update—When
Select—Condition—Table
2. (TCO 7) In a VBScript SQL Query statement, what Boolean operator can be used to test a set of
conditions whereby all conditions must be true? (Points : 5)
OR
AND
XOR
NOT
3. (TCO 7) The _____ in a table is the column that makes each record different from all others. (Points :
5)
unique record
primary key
sort key
magic field
4. (TCO 7) What task(s) are involved in designing a database table? (Points : 5)
, Naming each record
Naming each field
Naming each field and providing data types
Inserting all of the data
5. (TCO 1) Which of the following Windows commands will shutdown and restart the computer
FileServer in 2 minutes? (Points : 5)
shutdown -r -m //FileServer -t 2
shutdown -r -m //FileServer -t 120
shutdown -r -m \\FileServer -t 2
shutdown -r -m \\FileServer -t 120
6. (TCO 1) Which Windows shutdown command switch is used to shutdown and turn off a local or a
remote computer? (Points : 5)
-h
/halt
-s
/shut
7. (TCO 1) Which one of the following Windows NET commands options is not used to control services
with the NET ?????ServiceName? (Points : 5)
STOP
, START
CONTINUE
PAUSE
DELETE
8. (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)
netsh interface set ip address “NIC” source=dhcp
netsh interface ip address “NIC” source=dhcp
netsh interface ip set address “NIC” source=dhcp
netsh interface set ip address source=dhcp “NIC”
9. (TCO 6) The following VBScript statement will open a text file.
Set file = fso.OpenTextFile(“C:\Data\CustData.txt”, ?, ??, ???)
To create a new file if it doesn’t exist, the value of ??must be _____. (Points : 5)
1
2
false
true
10. (TCO 6) In creating a VBScript Scripting.FileSystemObject, you must start the code line with _____.
(Points : 5)
