Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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?

Accepted Answer

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

Question 4

What is SQL and how is it used?

Accepted Answer

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

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) Start event procedure 
B) Load event procedure 
C) Refresh event procedure 
D) Click event procedure

Question 8

A Try…Catch statement ends with ____.

Accepted Answer

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

Question 9

What is a parameter query and how is it used?

Accepted Answer

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

Question 10

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 11

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

Accepted Answer

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

Question 12

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}$$
-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?

Accepted Answer

A) INSERT 
B) InsertRecordQuery 
C) DELETE 
D) DeleteRecordQuery

Question 13

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

Question 14

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 The ContractsDataSet contains a table named tblContracts....

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Question 17

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?

Accepted Answer

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 18

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?

Accepted Answer

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 19

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

Accepted Answer

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

Question 20

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

Exam 14: Access Databases and SQL

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

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

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?

What is SQL and how is it used?

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

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

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 Try…Catch statement ends with ____.

What is a parameter query and how is it used?

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

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

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

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

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?

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 Delete query uses the ____ statement to delete a record from a database.