Question 1 1 pts You use the clause which contains a condit

Question 1 1 pts

You use the ____ clause, which contains a condition, to limit the records you want to view.

Flag this Question

Question 2 1 pts

Which of the following statements selects the Title and ProductionCo fields from records whose title begins with the word “The” followed by a space and zero or more characters, and then sorts the records in descending order by the ProductionCo field?

Flag this Question

Question 3 1 pts

____ is a set of statements that allows you to access and manipulate the data stored in many database management systems on computers of all sizes, from large mainframes to small microcomputers.

Flag this Question

Question 4 1 pts

Which of the following statements will delete the record associated with a DataRow variable named getRow?

Flag this Question

Question 5 1 pts

One record is added to the AccountsDataSet. Which of the following statements will save the record in the Accounts database?

Flag this Question

Question 6 1 pts

The ____ clause is used to arrange the records in either ascending (the default) or descending order by one or more fields.

Flag this Question

Question 7 1 pts

Which of the following locates the record whose PartNum field contains KL542, and then assigns the record to the row variable?

Flag this Question

Question 8 1 pts

If you want the records in a dataset to appear in a particular order when the application is started, you enter the Sort method in the form’s ____.

Flag this Question

Question 9 1 pts

The wildcard character is the ____.

Flag this Question

Question 10 1 pts

Which of the following SELECT statements will select the ItemNum and ItemDesc fields from the tblItems table?

Solution

Answers:

_______

1. WHERE

2. SELECT Title, ProductionCo FROM tblMovies Title LIKE \'The %\' ORDER BY ProductionCo DESC

3. SQL

4. getRow.Delete()

5. TblAccountsTableAdapter.Update(AccountsDataSet.tblAccounts)

6. ORDER BY

7. row = PartsDataSet.tblParts.FindPartNum(\"KL542\")

8. Refresh event procedure

9. *

10. SELECT ItemNum, ItemDesc FROM tblItems