Question 1

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

Accepted Answer

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

Question 2

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 3

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?

Accepted Answer

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 4

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.
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { ItemNum } & \text { ItemDesc } & \text { Color } & \text { Price } & \text { Quantity } \
\hline 2358 & \text { leather collar } & \text { black } & 25.00 & 35 \
\hline 2693 & \text { leather collar } & \text { brown } & 25.00 & 25 \
\hline 3547 & \text { striped collar } & \text { red } & 15.00 & 75 \
\hline 3855 & \text { striped collar } & \text { blue } & 15.00 & 42 \
\hline 3764 & \text { striped collar } & \text { green } & 15.00 & 48 \
\hline 5782 & \text { solid collar } & \text { pink } & 12.00 & 36 \
\hline 5785 & \text { solid collar } & \text { red } & 12.00 & 10 \
\hline 5787 & \text { solid collar } & \text { blue } & 12.00 & 15 \
\hline
\end{array}$$
-Which of the following is not true regarding the Query Builder?

Accepted Answer

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 5

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)

Question 6

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

Accepted Answer

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

Question 7

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.
 $$\begin{array} { | l | l | l | l | l | } 
\hline \text { ItemNum } & \text { ItemDesc } & \text { Color } & \text { Price } & \text { Quantity } \
\hline 2358 & \text { leather collar } & \text { black } & 25.00 & 35 \
\hline 2693 & \text { leather collar } & \text { brown } & 25.00 & 25 \
\hline 3547 & \text { striped collar } & \text { red } & 15.00 & 75 \
\hline 3855 & \text { striped collar } & \text { blue } & 15.00 & 42 \
\hline 3764 & \text { striped collar } & \text { green } & 15.00 & 48 \
\hline 5782 & \text { solid collar } & \text { pink } & 12.00 & 36 \
\hline 5785 & \text { solid collar } & \text { red } & 12.00 & 10 \
\hline 5787 & \text { solid collar } & \text { blue } & 12.00 & 15 \
\hline
\end{array}$$
-You must first ____ to begin creating a SQL query.

Accepted Answer

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

Accepted Answer

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

Question 9

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 The tblMembers table contains six fields. The...

Question 10

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

Accepted Answer

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

Question 11

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 The tblMembers table contains six fields. The...

Question 12

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

Accepted Answer

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

Question 13

The wildcard character is the ____.

Accepted Answer

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

Question 14

The parameter marker is a(n)____.

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

You use the REMOVE statement to delete records.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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])

Question 18

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 The tblMembers table contains six fields. The...

Question 19

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

Question 20

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

Exam 14: Access Databases and SQL

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

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

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?

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 ____ is a query that uses the parameter marker in place of the criteria's value.

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.

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

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

The wildcard character is the ____.

The parameter marker is a(n) ____.

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

You use the REMOVE statement to delete records.

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

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

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