Question 1

_is a tool provided by Visual Studio for creating and modifying SQL queries.

Accepted Answer

A)  Server Explorer 
B)  SQL Explorer 
C)  Query Builder 
D)  SQL Toolbox 
A)  Server Explorer 
B)  SQL Explorer 
C)  Query Builder 
D)  SQL Toolbox C

Question 2

A complete set of data for a single student that includes the following information is called a . Student ID, First Name, Last Name, Major, Class

Accepted Answer

A)  Table 
B)  Column 
C)  Row 
D)  Field 
A)  Table 
B)  Column 
C)  Row 
D)  Field C

Question 3

_allows individual controls such as text boxes and labels to be linked to and automatically display the contents of a data source.

Accepted Answer

A)  Data binding 
B)  A table adapter 
C)  A data grid 
D)  A data relation 
A)  Data binding 
B)  A table adapter 
C)  A data grid 
D)  A data relation A

Question 4

The _control displays information from a dataset in row and column format.

Accepted Answer

A)  DataAware 
B)  DataGridView 
C)  DataListView 
D)  DataTableView 
A)  DataAware 
B)  DataGridView 
C)  DataListView 
D)  DataTableView

Question 5

__allows you to query many types of data from virtually any source.

Accepted Answer

A)  SQL 
B)  LINQ 
C)  OPENGL 
D)  DirectX 
A)  SQL 
B)  LINQ 
C)  OPENGL 
D)  DirectX

Question 6

Assume the following table named Student exists in a database: Name Number Address GPA CumHrs
Adams, Carol 123 Redford Hall 3.6 67
Baker, Paul 345 Kingman Hall 2.1 34
Jones, Jill 456 Bassett Hall 3.2 89
Smith, Mary 887 Redford Hall 3.8 112
Taylor, Darren 987 Bassett Hall 3.7 55
Which of the following SQL statements will return only the student name and GPA from the Student table for all students having a GPA that is greater than or equal to 3.5?

Accepted Answer

A)  SELECT Name, GPA FROM Student WHERE GPA >=3.5 
B)  SELECT * FROM Student WHERE GPA >= 3.5 
C)  SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5 
D)  SELECT Student WHERE GPA >= 3.5 And Name, GPA 
A)  SELECT Name, GPA FROM Student WHERE GPA >=3.5 
B)  SELECT * FROM Student WHERE GPA >= 3.5 
C)  SELECT Name, Number, GPA, CumHrs FROM Student WHERE GPA >= 3.5 
D)  SELECT Student WHERE GPA >= 3.5 And Name, GPA

Question 7

A ____statement in SQL retrieves data from a database.

Accepted Answer

A)  Select 
B)  Search 
C)  Find 
D)  SearchTable 
A)  Select 
B)  Search 
C)  Find 
D)  SearchTable

Question 8

Which table adapter method reads data from the database into the dataset?

Accepted Answer

A)  Fill 
B)  Read 
C)  Select 
D)  Retrieve 
A)  Fill 
B)  Read 
C)  Select 
D)  Retrieve

Question 9

A _is the design of tables, columns and relationships between tables for the database.

Accepted Answer

A)  data table 
B)  database schema 
C)  data set 
D)  relational model 
A)  data table 
B)  database schema 
C)  data set 
D)  relational model

Question 10

The SelectedValue property of a data-bound ListBox returns the value in the column specified by the ____property.

Accepted Answer

A)  ValueMember 
B)  ReturnColumn 
C)  ReturnField 
D)  DisplayMember 
A)  ValueMember 
B)  ReturnColumn 
C)  ReturnField 
D)  DisplayMember

Question 11

All of the following are true about SQL except .

Accepted Answer

A)  SQL provides a standard means of interacting with a database. 
B)  SQL consists of several keywords. 
C)  SQL stands for "Sequenced Query Language" 
D)  SQL is an industry-standard language. 
A)  SQL provides a standard means of interacting with a database. 
B)  SQL consists of several keywords. 
C)  SQL stands for "Sequenced Query Language" 
D)  SQL is an industry-standard language.

Question 12

A is a column or columns) that uniquely identifies each row of data in a database.

Accepted Answer

A)  selector 
B)  main key 
C)  identifier 
D)  primary key 
A)  selector 
B)  main key 
C)  identifier 
D)  primary key

Question 13

A ____is an in-memory copy of data read from database tables.

Accepted Answer

A)  data control 
B)  dataset 
C)  connection 
D)  data adapter 
A)  data control 
B)  dataset 
C)  connection 
D)  data adapter

Question 14

Which statement does NOT accurately describe a database row?

Accepted Answer

A)  A row contains related data about a single item such as a department. 
B)  A row contains one or more fields. 
C)  When discussing a table, we refer to the rows by name. 
D)  A row is part of a database table. 
A)  A row contains related data about a single item such as a department. 
B)  A row contains one or more fields. 
C)  When discussing a table, we refer to the rows by name. 
D)  A row is part of a database table.

Question 15

In an SQL query, the _wildcard character, used with the LIKE operator, will match multiple unknown characters.

Accepted Answer

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

Question 16

A ____component passes data from one or more database tables to your program.

Accepted Answer

A)  DataTransfer 
B)  DataSet 
C)  Connection 
D)  TableAdapter 
A)  DataTransfer 
B)  DataSet 
C)  Connection 
D)  TableAdapter

Question 17

In Visual Studio, choose the ___template when creating a database file.

Accepted Answer

A)  Service-based Database 
B)  Local Database 
C)  DataSet 
D)  XML Schema 
A)  Service-based Database 
B)  Local Database 
C)  DataSet 
D)  XML Schema

Question 18

A unique student ID number could be used as a ____, whereas a student's last name would not be suitable because two students might have the last name.

Accepted Answer

A)  Primary Key 
B)  Sort Key 
C)  Record Type 
D)  Data Source 
A)  Primary Key 
B)  Sort Key 
C)  Record Type 
D)  Data Source

Question 19

A table adapter's method is used to add a new row to a table.

Accepted Answer

A)  Add 
B)  Append 
C)  Insert 
D)  Update 
A)  Add 
B)  Append 
C)  Insert 
D)  Update

Question 20

The correct SQL syntax to sort a table by Last_Name in order of A-Z is _.

Accepted Answer

A)  SORT BY Last_Name ASCENDING 
B)  ORDER BY Last_Name Down 
C)  ORDER BY Last_Name ASC 
D)  ORDER BY Last_Name DESC 
A)  SORT BY Last_Name ASCENDING 
B)  ORDER BY Last_Name Down 
C)  ORDER BY Last_Name ASC 
D)  ORDER BY Last_Name DESC

_is a tool provided by Visual Studio for creating and modifying SQL queries.

A complete set of data for a single student that includes the following information is called a . Student ID, First Name, Last Name, Major, Class

_allows individual controls such as text boxes and labels to be linked to and automatically display the contents of a data source.

The _control displays information from a dataset in row and column format.

__allows you to query many types of data from virtually any source.

A ____statement in SQL retrieves data from a database.

Which table adapter method reads data from the database into the dataset?

A _is the design of tables, columns and relationships between tables for the database.

The SelectedValue property of a data-bound ListBox returns the value in the column specified by the ____property.

All of the following are true about SQL except .

A is a column or columns) that uniquely identifies each row of data in a database.

A ____is an in-memory copy of data read from database tables.

Which statement does NOT accurately describe a database row?

In an SQL query, the _wildcard character, used with the LIKE operator, will match multiple unknown characters.

A ____component passes data from one or more database tables to your program.

In Visual Studio, choose the ___template when creating a database file.

A unique student ID number could be used as a ____, whereas a student's last name would not be suitable because two students might have the last name.

A table adapter's method is used to add a new row to a table.

The correct SQL syntax to sort a table by Last_Name in order of A-Z is _.

Introduction to Programming and Visual Basic

Creating Applications With Visual Basic

Variables and Calculations

Making Decisions

Lists and Loops

Procedures and Functions

Multiple Forms, Modules, and Menus

Arrays and More

Files, Printing, and Structures

Developing Web Applications

Classes, Collections, and Inheritance

Filters

Exam 10: Working With Databases

_is a tool provided by Visual Studio for creating and modifying SQL queries.

A complete set of data for a single student that includes the following information is called a . Student ID, First Name, Last Name, Major, Class

_allows individual controls such as text boxes and labels to be linked to and automatically display the contents of a data source.

The _control displays information from a dataset in row and column format.

__allows you to query many types of data from virtually any source.

A ____statement in SQL retrieves data from a database.

Which table adapter method reads data from the database into the dataset?

A _is the design of tables, columns and relationships between tables for the database.

The SelectedValue property of a data-bound ListBox returns the value in the column specified by the ____property.

All of the following are true about SQL except .

A is a column or columns) that uniquely identifies each row of data in a database.

A ____is an in-memory copy of data read from database tables.

Which statement does NOT accurately describe a database row?

In an SQL query, the _wildcard character, used with the LIKE operator, will match multiple unknown characters.

A ____component passes data from one or more database tables to your program.

In Visual Studio, choose the ___template when creating a database file.

A unique student ID number could be used as a ____, whereas a student's last name would not be suitable because two students might have the last name.

A table adapter's method is used to add a new row to a table.

The correct SQL syntax to sort a table by Last_Name in order of A-Z is _.

Introduction to Programming and Visual Basic

Creating Applications With Visual Basic

Variables and Calculations

Making Decisions

Lists and Loops

Procedures and Functions

Multiple Forms, Modules, and Menus

Arrays and More

Files, Printing, and Structures

Developing Web Applications

Classes, Collections, and Inheritance

Filters