Expert Answers


Question 1 (TCO 7) What SQL clause is used to determine the fields to be displayed in an SQL Query statement? (Points : 2) SELECT ORDER BY FIELDS WHERE

Question 2.2. (TCO 7) What is the name for a column that uniquely identifies a record? (Points : 2) Primary key

Unique key Foreign key Table key

Question 3.3. (TCO 7) What task(s) are involved in designing a database table? (Points : 2) 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 _____. (Points : 2) reports keys queries indexes

Question 6.6. (TCO 7) Which of the following is not a database security issue? (Points : 2) Providing encryption Providing normalization Recovering lost data Providing data integrity

Question 7.7. (TCO 7) In an SQL Query statement, what Boolean operator can be used to test a set of conditions whereby any condition being true will and must test true? (Points : 2) OR AND XOR NOT

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

9.9. (TCO 7) The WSH Object used in a VBScript program to retrieve data from a database is _____. (Points : 2) ADODB.Recordset ADODB.Open ADODB.Retrieve ADODB.Record

Question 10.10. (TCO 7) The general syntax of an SQL select statement is _____ (Points : 2)
Select—From—Where. Get—Date—Where. Select—Update—When. Select—Condition—Table.