Question 1

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

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 2

Members 
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 all family members. Sort the records in descending order by the JoinDate field.

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 3

Case-Based Critical Thinking Questions 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.
 What method could be used to invoke the previous query during run time?
A) FillByPrice
B) SELECT
C) WHERE
D) Fill

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 1 -...

Question 4

Problems - Correcting Logic and Code Errors 
The following sample of code contains errors. Rewrite the incorrect statements to correct all errors. 
' Save dataset changes to a database 
Try 
TblTabletsBindingSource.Update(TabletsDataSet) 
Catch ex 
MessageBox.Show(ex.Message, "Tablet Data", 
MessageBoxButtons.OK, 
MessageBoxIcon.Information) 
End Catch

Accepted Answer

The answer of Problems - Correcting Logic and Code Errors...

Question 5

Members 
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 deletes member 42315 from the tblMembers table.

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 6

Contracts 
The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. 
Three records were added to the ContractsDataSet. Write the statement to save the records in the Contracts database.

Accepted Answer

The answer of Contracts 
The ContractsDataSet contains a table named...

Question 7

Members 
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 only the records for the Senior members. Select all of the fields.

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 8

Members 
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 allows the user to select the members with a fee greater than or equal to the fee amount provided by the user. The query should select the MemberID, LastName, FirstName, and Fee fields.

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 9

Contracts 
The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. 
Write the statement to add a new record to the dataset.

Accepted Answer

The answer of Contracts 
The ContractsDataSet contains a table named...

Question 10

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

Accepted Answer

The answer of Contracts 
The ContractsDataSet contains a table named...

Question 11

Case-Based Critical Thinking Questions 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.
 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?
A) INSERT
B) InsertRecordQuery
C) DELETE
D) DeleteRecordQuery

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 1 -...

Question 12

Members 
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 allows the user to provide a specific MemberID. The query should select all fields.

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 13

What is SQL and how is it used?

Accepted Answer

The answer of What is SQL and how is it...

Question 14

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

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 15

Members 
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, JoinDate, and MemberType fields from all of the records.

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 16

Case-Based Critical Thinking Questions 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.
 An application using the dataset should allow a user to type in a price to use to query the dataset. Which of the following clauses would allow a user to select the records for collars with a price of 15 or more?
A) WHERE Price >= 15
B) WHERE Price Like 15
C) WHERE Price >= ?
D) WHERE Price

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 1 -...

Question 17

Contracts 
The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. 
Write the statement to sort the records in alphabetic order by last name.

Accepted Answer

The answer of Contracts 
The ContractsDataSet contains a table named...

Question 18

Members 
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 inserts the following record into the tblMembers table: 
MemberID - 25631 
Name - Jane Doe 
Date Joined - 2012 
Fee - 65 
Membership Type - Adult

Accepted Answer

The answer of Members 
The tblMembers table contains six fields....

Question 19

Problems - Correcting Logic and Code Errors 
The following sample of code contains errors. Rewrite the incorrect statements to correct all errors. 
' Delete a record from the dataset 
Dim row As TextData 
row = CustomerDataSet.tblCustomer.LookForCustID(3146) 
Delete() 
Try 
TblCustomerTableAdapter.Save(CustomerDataSet.tblCustomer) 
Catch ex As Exception 
MessageBox.Show(ex.Message, "Delete record", 
MessageBoxButtons.OK, 
MessageBoxIcon.Information) 
End Try

Accepted Answer

The answer of Problems - Correcting Logic and Code Errors...

Question 20

What is a parameter query and how is it used?

Accepted Answer

The answer of What is a parameter query and how...

Quiz 14: Access Databases and Sql

Contracts The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. Three records were added to the ContractsDataSet. Write the statement to save the records in the Contracts database.

Contracts The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. Write the statement to add a new record to the dataset.

What is SQL and how is it used?

Contracts The ContractsDataSet contains a table named tblContracts. The table contains four text fields named LastName, FirstName, Email, and Phone. Write the statement to sort the records in alphabetic order by last name.

What is a parameter query and how is it used?