Question 1

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 
A)  ORDER BY 
B)  WHERE 
C)  GROUP BY 
D)  UNION

Question 2

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

The answer of The tblStudent table contains nine fields,one of...

Question 3

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

The answer of Which of the following SELECT statements will...

Question 4

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

Accepted Answer

The answer of Write a SQL SELECT statement that deletes...

Question 5

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

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) 
A)  TblAccountsTableAdapter.Update(AccountsDataSet.tblAccounts) 
B)  TblAccountsTableAdapter.Save(AccountsDataSet.tblAccounts) 
C)  TblAccountsTableAdapter.Store(AccountsDataSet.tblAccounts) 
D)  TblAccountsBindingSource.Update(AccountsDataSet.tblAccounts)

Question 7

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

Accepted Answer

The answer of Three records were added to the ContractsDataSet.Write...

Question 8

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

Accepted Answer

The answer of Write the statement to add a new...

Question 9

The parameter marker is a(n)____.
A) ?
B) *
C) &
D) %

Accepted Answer

The answer of The parameter marker is a(n)____.
A) ?
B) *
C)...

Question 10

The wildcard character is the ____.

Accepted Answer

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

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.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 
A)  TableAdapter Configuration Wizard 
B)  TableAdapter Modification Wizard 
C)  TableAdapter Dataset Configuration Wizard 
D)  TableAdapter Query Configuration Wizard

Question 14

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.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

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

The answer of The FillByMake method is associated with a...

Question 17

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 Write the statement to find the record...

Question 18

You use the REMOVE statement to delete records.

Accepted Answer

A) True 
 B)False

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

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?

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?

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

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?

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

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

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

The parameter marker is a(n)____. A) ? B) * C) & D) %

The wildcard character is the ____.

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

What method could be used to invoke the previous query during run time?

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

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.

Which of the following SELECT statements will select the ItemNum and ItemDesc fields from the tblItems 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?

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.

You use the REMOVE statement to delete records.

An Introduction to Visual Basic 2012

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 use the ____ clause,which contains a condition,to limit the records you want to view.

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?

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?

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

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?

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

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

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

The parameter marker is a(n)____. A) ? B) * C) & D) %

The wildcard character is the ____.

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

What method could be used to invoke the previous query during run time?

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

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.

Which of the following SELECT statements will select the ItemNum and ItemDesc fields from the tblItems 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?

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.

You use the REMOVE statement to delete records.

An Introduction to Visual Basic 2012

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