A+ Answers

Question 1. (TCO 7) Which statement concerning primary keys is false?
Primary keys must be unique. 
Primary keys may be numbers. 
Primary keys may be letters. 
A primary key value can repeat in a table.


Question 2. (TCO 7) The WSH Object used in a VBScript program to open a database is _____.
ADODB.Connect 
ADODB.Open 
ADODB.Connection 
ADODB.DBConnect

Question 3.3. (TCO 7) What task(s) are involved in designing a database table?
Naming each record 
Naming each field 
Naming each field and providing data types 
Inserting all the data


Question 4.4. (TCO 7) What SQL clause is used to determine the sequence in which the records are displayed in an SQL Query statement? (Points : 2)
SEQUENCE 
ORDER BY 
SORT BY 
INDEX BY 


Question 5.5. (TCO 7) The questions that cause the database software to extract the appropriate records from a table and specify the fields to be viewed are called _____.
reports 
keys 
queries 
indexes 

Question 6.6. (TCO 7) In an SQL Query statement, what Boolean operator can be used to test a set of conditions whereby all conditions must be true?
OR 
AND 
XOR 
NOT 


Question 7.7. (TCO 7) Which one of the following is a correct SELECT clause for selecting the fields: FirstName and LastName and Age?
SELECT FirstName and LastName and Age 
SELECT FIELDS(FirstName,LastName,Age 
SELECT FirstName,LastName,Age 
SELECT FROM FirstName,LastName,Age 


Question 8.8. (TCO 7) Which field would be suitable as a primary key in a table that contains employee records?
Area code 
Last name 
Birth date 
An employee number