Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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?

Accepted Answer

A)  FillByPrice 
B)  SELECT 
C)  WHERE 
D)  Fill 
A)  FillByPrice 
B)  SELECT 
C)  WHERE 
D)  Fill

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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?

Accepted Answer

A)  WHERE Price >= 15 
B)  WHERE Price Like 15 
C)  WHERE Price >= ? 
D)  WHERE Price 
A)  WHERE Price >= 15 
B)  WHERE Price Like 15 
C)  WHERE Price >= ? 
D)  WHERE Price

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

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.

Accepted Answer

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

Question 10

What is a parameter query and how is it used?

Accepted Answer

A parameter query is a query that uses t

Question 11

What is SQL and how is it used?

Accepted Answer

SQL is Structured Query Language. It is

Question 12

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?

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

' Delete a record from the dataset 
Dim

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

Accepted Answer

DELETE FRO

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

A Try…Catch statement ends with ____.

Accepted Answer

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

Question 19

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

Accepted Answer

A)  row = PartsDataSet.tblParts.FindPartNum("KL542") 
B)  row = Parts.tblParts.FindByPartNum("KL542") 
C)  row = PartsDataSet.tblParts.FindBy("KL542") 
D)  row = PartsDataSet.tblParts.FindByPartNum("KL542") 
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 20

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

Accepted Answer

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

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

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

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

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

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

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

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.

What is a parameter query and how is it used?

What is SQL and how is it used?

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?

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

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

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

A Try…Catch statement ends with ____.

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

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

An Introduction to Visual Basic 2015

Designing Applications

Using Variables and Constants

The Selection Structure

More on the Selection Structure

The Repetition Structure

Sub and Function Procedures

String Manipulation

Arrays

Structures and Sequential Access Files

Classes and Objects

Web Applications

Working With Access Databases and Linq

Filters

Exam 14: Access Databases and Sql

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

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

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

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

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

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

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.

What is a parameter query and how is it used?

What is SQL and how is it used?

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?

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

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

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

A Try…Catch statement ends with ____.

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

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

An Introduction to Visual Basic 2015

Designing Applications

Using Variables and Constants

The Selection Structure

More on the Selection Structure

The Repetition Structure

Sub and Function Procedures

String Manipulation

Arrays

Structures and Sequential Access Files

Classes and Objects

Web Applications

Working With Access Databases and Linq

Filters