Exam 14: Access Databases and SQL

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

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

The tblStudent table contains nine fields,one of which is the StudentID field.A user can type in any StudentID to select a particular student.The user provides 124541 as the StudentID to select.Which of the following statements deletes the student record specified by the user?

What is SQL and how is it used?

The WHERE statement is the most commonly used statement in SQL.

The statement SELECT YearWon FROM tblMovies WHERE Title = 'Chicago' selects the Chicago field from the YearWon record.

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 ____.

A Try…Catch statement ends with ____.

What is a parameter query and how is it used?

For the changes made to a dataset to be permanent,you need to save the changes to the database associated with the dataset.

The .xsd file is called the dataset's ____ file.

Case 1 - LuvUrPet The database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers. ItemNum ItemDesc Color Price Quantity 2358 leather collar black 25.00 35 2693 leather collar brown 25.00 25 3547 striped collar red 15.00 75 3855 striped collar blue 15.00 42 3764 striped collar green 15.00 48 5782 solid collar pink 12.00 36 5785 solid collar red 12.00 10 5787 solid collar blue 12.00 15 -An application using the dataset allows the user to provide an ItemNum to select a record to delete from the dataset.Which function must also be used in the code for the Delete button on the form to work properly?

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. -Write a SQL SELECT statement that selects the MemberID,LastName,and FirstName fields for members having a last name that begins with the letter J.

The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. -Write the statement to find the record of a contract with the last name Green and assign the record to a row variable that you declare.Then write the statement to delete that record from the database.

The Query Builder places the WHERE clause's condition in parentheses because the parentheses are required.

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

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?

Which of the following SELECT statements will select the ProdNum field from the tblProducts table,and then sort the records in descending order by the Price field?

A Delete query uses the ____ statement to delete a record from a database.

The tblMembers table contains six fields. The LastName, FirstName, and MemberType fields contain text. The MemberID, JoinDate, and Fee fields contain numbers. The MemberType field contains one of the following letters: F for Family membership, A for one Adult membership, Y for one Youth membership, and S for one Senior membership. -Write a SQL SELECT statement that selects all of the fields and records in the table.Sort the records in ascending order by the MemberType field.