Deck 14: Access Databases and SQL

Question 1

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.AddtableNameRow(valueField1[, valueField2…, valueFieldN])
D)dataSetName.tableName.AddRowtableName(valueField1[, valueField2…, valueFieldN])

Answer 1

C

Question 2

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"

Answer 2

B

Question 3

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

Answer 3

B

Question 4

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

Question 5

The default order of the ORDER BY clause is descending.

Question 6

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

Question 7

You use the REMOVE statement to delete records.

Question 8

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 9

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 10

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

Question 11

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 12

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

Question 13

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 14

A Try…Catch statement ends with ____.

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

Question 15

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 16

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

Question 17

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 18

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

The WHERE statement is the most commonly used statement in 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

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 tblProductsSORT Price DESC
B)SELECT ProdNum FROM tblProductsORDER BY Price DESC
C)SELECT ProdNum FROM tblProductsWHERE Price DESC
D)SELECT ProdNum FROM tblProductsORDER BY ProdNum DESC

Question 22

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

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

Question 23

The parameter marker is a(n)____.

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

Question 24

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 25

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 tblStudentWHERE StudentID = 124541
B)DELETE FROM tblStudentWHERE StudentID = 124541
C)DELETE FROM tblStudentWHERE StudentID = '124541'
D)DELETE FROM tblStudentWHERE StudentID = ?

Question 26

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 27

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 28

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 29

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 30

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 31

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 32

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 33

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 34

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 35

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

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

Question 36

The wildcard character is the ____.

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

Question 37

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 38

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

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

Question 39

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

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

Question 40

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 41

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 42

' 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 43

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 44

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 45

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 46

' 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 47

Write a SQL SELECT statement that selects only the records for the Senior members.Select all of the fields.

Question 48

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 49

Write the statement to add a new record to the dataset.

Question 50

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 51

What is SQL and how is it used?

Question 52

Three records were added to the ContractsDataSet.Write the statement to save the records in the Contracts database.

Question 53

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 54

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 55

What is a parameter query and how is it used?

Question 56

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 57

Write a SQL SELECT statement that deletes member 42315 from the tblMembers table.

Question 58

Write the statement to sort the records in alphabetic order by last name.

Question 59

Write a SQL SELECT statement that selects the MemberID,LastName,JoinDate,and MemberType fields from all of the records.

Question 60

Write a SQL SELECT statement that allows the user to provide a specific MemberID.The query should select all fields.