Deck 14: Access Databases and Sql

Question 1

A Try…Catch statement ends with ____.

A) End
B) End Try…Catch
C) End Catch
D) End Try

Answer 1

D

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

You save a query that contains the SELECT statement by associating the query with one or more methods.

Question 5

The statement SELECT YearWon, Title, ProductionCo FROM tblMovies WHERE YearWon >= 2006 selects all of the fields from records for the year 2006 and later.

Question 6

You use the REMOVE statement to delete records.

Question 7

In order for an application to use a query during run time, you will need to save the query and then invoke it from code.

Question 8

Most of the time, you will know in advance the values to include in the criteria of a query.

Question 9

Because it is possible for an error to occur when saving data to a database, it's a good programming practice to place the Update method within the ____ block of a Try…Catch statement.

A) Try
B) Catch
C) Assert
D) Fail

Question 10

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

A) ORDER BY
B) WHERE
C) GROUP BY
D) UNION

Question 11

The syntax to add a record to a dataset is ____.

A) dataSetName.tableName .Add( valueField1 [, valueField2 …, valueFieldN ])
B) dataSetName.tableName. AddRow( valueField1 [, valueField2 …, valueFieldN ])
C) dataSetName . tableName .Add tableName Row(valueField1[, valueField2…, valueFieldN ])
D) dataSetName.tableName. AddRow tableName ( valueField1 [, valueField2 …, valueFieldN ])

Question 12

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

Question 13

The default order of the ORDER BY clause is descending.

Question 14

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

A) row = PartsDataSet.tblParts.FindPartNum("KL542")
B) row = Parts.tblParts.FindByPartNum("KL542")
C) row = PartsDataSet.tblParts.FindBy("KL542")
D) row = PartsDataSet.tblParts.FindByPartNum("KL542")

Question 15

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

Question 16

Which of the following sorts the records for the PartsDataSet by the Price field?

A) TblPartsDataSet.Sort = "Price"
B) TblPartsBindingSource.Sort = "Price"
C) TblPartsBindingSource.Sort = Price
D) TblPartsTableAdapter.Sort = "Price"

Question 17

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) Start event procedure
B) Load event procedure
C) Refresh event procedure
D) Click event procedure

Question 18

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

A) TblAccountsTableAdapter.Update(AccountsDataSet.tblAccounts)
B) TblAccountsTableAdapter.Save(AccountsDataSet.tblAccounts)
C) TblAccountsTableAdapter.Store(AccountsDataSet.tblAccounts)
D) TblAccountsBindingSource.Update(AccountsDataSet.tblAccounts)

Question 19

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

A) TQL
B) LINQ
C) C#
D) SQL

Question 20

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

A) row.Delete(getRow)
B) getRow.Update()
C) getRow.Delete()
D) Delete.getRow

Question 21

A ____ is a query that uses the parameter marker in place of the criteria's value.

A) structured query
B) parameter query
C) limited query
D) replaceable query

Question 22

An Insert query uses the ____ statement to add a record to a database.

A) INSERT
B) ADD
C) UPDATE
D) DELETE

Question 23

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

A) SELECT ItemNum OR ItemDesc FROM tblItems
B) SELECT ItemNum AND ItemDesc FROM tblItems
C) SELECT ItemNum, ItemDesc IN tblItems
D) SELECT ItemNum, ItemDesc FROM tblItems

Question 24

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.
You must first ____ to begin creating a SQL query.

A) start the TableAdapter Query Configuration Wizard
B) right-click the CollarsDataSet.xsd file, then click Open to open the DataSet Designer window
C) choose a query type
D) specify a SQL SELECT statement

Question 25

The ____ provides an easy way of associating the query with one or more methods.

A) TableAdapter Configuration Wizard
B) TableAdapter Modification Wizard
C) TableAdapter Dataset Configuration Wizard
D) TableAdapter Query Configuration Wizard

Question 26

You can use the ____ associated with a query to invoke the query during run time.

A) properties
B) methods
C) objects
D) values

Question 27

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

A) UPDATE
B) SELECT
C) INSERT
D) DELETE

Question 28

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?

A) SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The %' ORDER BY ProductionCo
B) SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The %' ORDER BY ProductionCo DESC
C) SELECT Title, ProductionCo FROM tblMovies WHERE Title LIKE 'The *' ORDER BY ProductionCo DESC
D) SELECT Title, ProductionCo FROM tblMovies ORDER BY ProductionCo DESC

Question 29

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) SELECT ProdNum FROM tblProducts SORT Price DESC
B) SELECT ProdNum FROM tblProducts ORDER BY Price DESC
C) SELECT ProdNum FROM tblProducts WHERE Price DESC
D) SELECT ProdNum FROM tblProducts ORDER BY ProdNum DESC

Question 30

Click ____ on the shortcut menu to start the TableAdapter Query Configuration Wizard.

A) Add Configuration
B) Add Query
C) Add Link
D) Add TableAdapter

Question 31

The parameter marker is a(n) ____.

A) ?
B) *
C) &
D) %

Question 32

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.
Which of the following is not true regarding the Query Builder?

A) The table and its related fields are displayed in the Diagram pane.
B) You cannot view the results of the query in the Query Builder once it is executed.
C) You can manually type the SELECT statement instead of using the Query Builder.
D) You must click the Execute Query button for the query to run.

Question 33

The FillByMake method is associated with a parameter query. Which of the following statements invokes the method and passes the contents of the txtMake control's Text property?

A) TblTruckTableAdapter.FillTruck(TruckDataSet.tblTruck)
B) TblTruckTableAdapter.FillByMake(TruckDataSet.tblTruck)
C) TblTruckTableAdapter.FillByMake(TruckDataSet, txtMake.Text)
D) TblTruckTableAdapter.FillByMake(TruckDataSet.tblTruck, txtMake.Text)

Question 34

The tblTruck table has two text fields named Make and Model, and one numeric field named Year. Which of the following statements adds the record 2013 Ford F150 to the table?

A) INSERT VALUES ('Ford', 'F150', 2013) INTO tblTruck (Make, Model, Year)
B) INSERT INTO tblTruck ('Ford', 'F150', 2013) VALUES (Make, Model, Year)
C) INSERT INTO 'tblTruck' ('Make', 'Model', 'Year') VALUES ('Ford', 'F150', 2013)
D) INSERT INTO tblTruck (Make, Model, Year) VALUES ('Ford', 'F150', 2013)

Question 35

The file that contains information about the tables, fields, records, and properties included in the dataset has an ____ extension.

A) .xst
B) .xsq
C) .xsd
D) .xsl

Question 36

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?

A) SELECT FROM tblStudent WHERE StudentID = 124541
B) DELETE FROM tblStudent WHERE StudentID = 124541
C) DELETE FROM tblStudent WHERE StudentID = '124541'
D) DELETE FROM tblStudent WHERE StudentID = ?

Question 37

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

A) schema
B) layout
C) format
D) standard

Question 38

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

A) GROUP BY
B) WHERE
C) ORDER BY
D) JOIN

Question 39

When you don't know the specific value to include in the criteria, you use a ____.

A) limited query
B) tagged query
C) structured query
D) parameter query

Question 40

The wildcard character is the ____.

A) %
B) &
C) *
D) @

Question 41

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.

Question 42

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.

Question 43

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

Question 44

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

Question 45

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.

Question 46

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.

Question 47

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.

Question 48

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.

Question 49

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.

Question 50

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.

Question 51

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

Question 52

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.

Question 53

What is SQL and how is it used?

Question 54

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.

Question 55

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.

Question 56

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

Question 57

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.

Question 58

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

Question 59

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

Question 60

What is a parameter query and how is it used?