COMP 230 Final Exam 1 - Complete Solutions, Graded A

DeVry University. COMP 230 Final Exam - 1. Complete Solution. Graded A.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 DHCPsupplied 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:DataCustD”, ?, ??, ???) 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) Let fso = CreateObject Set fso = CreateObject Let fso = new Object Set fso = new Object 11. (TCO 6) The following VBScript statement will open a text file. Set file = fso.OpenTextFile(“C:DataCustD”, ?, ??, ???) To open this file for reading, the value of ?must be _____. (Points : 5) 1 2 true false