Add delete and update records within a table nbspwrite

Question

2. (TCO 7) Which of the following is NOT a feature of database management software? (Points : 2) Add, delete, and update records within a table. Write questions that select specific records from a table for viewing. View data on a PDA. Create table descriptions.

Question 3. 3. (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 4. 4. (TCO 7) The _____ in a table is the column that makes each record different from all others. unique record primary key sort key magic field

Question 5. 5. (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 6. 6. (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 7. 7. (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

Question 8. 8. (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? OR AND XOR NOT

Question 9. 9. (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 10.10. (TCO 7) The WSH Object used in a VBScript program to retrieve data from a database is _____. ADODB.Recordset ADODB.Open ADODB.Retrieve ADODB.Record