Question 1

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

Question 2

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 Write a SQL SELECT statement that selects...

Question 3

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

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

Accepted Answer

The answer of Write the statement to sort the records...

Question 5

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

Accepted Answer

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

Question 6

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

The answer of The tblTruck table has two text fields...

Question 7

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 
A)  INSERT 
B)  InsertRecordQuery 
C)  DELETE 
D)  DeleteRecordQuery

Question 8

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 9

The default order of the ORDER BY clause is descending.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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 12

What is SQL and how is it used?

Accepted Answer

SQL is Structured Query Language.It is a

Question 13

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

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

Accepted Answer

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

Question 18

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.

Accepted Answer

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

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

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

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.

Which of the following is not true regarding the Query Builder?

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

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

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?

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?

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

The default order of the ORDER BY clause is descending.

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

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

What is SQL and how is it used?

A Try…Catch statement ends with ____.

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

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

You must first ____ to begin creating a SQL query.

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

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.

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.

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

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

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.

Which of the following is not true regarding the Query Builder?

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

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

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?

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?

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

The default order of the ORDER BY clause is descending.

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

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

What is SQL and how is it used?

A Try…Catch statement ends with ____.

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

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

You must first ____ to begin creating a SQL query.

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

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.

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.

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