Question 1

The equal to and not equal to operators in SQL are different from those in C#.

Accepted Answer

A) True 
 B)False

Question 2

Each column in a table must have a name.

Accepted Answer

A) True 
 B)False

Question 3

In SQL, you use keywords to construct statements, which are also known as ____________.

Accepted Answer

A)  queries 
B)  expressions 
C)  determinants 
D)  solutions 
A)  queries 
B)  expressions 
C)  determinants 
D)  solutions

Question 4

In SQL, if you need to include a single quote as part of a string, simply write two single quotes in its place.

Accepted Answer

A) True 
 B)False

Question 5

When you click on the ____________, a tasks panel will pop up, giving you a number of options that you can perform.

Accepted Answer

A)  options check box 
B)  smart tag 
C)  view button 
D)  taskbar 
A)  options check box 
B)  smart tag 
C)  view button 
D)  taskbar

Question 6

In SQL, the ____________ is used as a wildcard character, and can be used to represent any sequence of zero or more characters.

Accepted Answer

A)  ^ symbol 
B)  Wild operator 
C)  % symbol 
D)  * character 
A)  ^ symbol 
B)  Wild operator 
C)  % symbol 
D)  * character

Question 7

There are numerous DBMSs in use today, and Visual C# can interact with many of them.

Accepted Answer

A) True 
 B)False

Question 8

A ____________ can display an entire database table in a scrollable grid on an application's form.

Accepted Answer

A)  BindingNavigator control 
B)  DataSet control 
C)  Chart control 
D)  DataGridView control 
A)  BindingNavigator control 
B)  DataSet control 
C)  Chart control 
D)  DataGridView control

Question 9

A ____________ is a source of data with which the application can work.

Accepted Answer

A)  data source 
B)  table copy 
C)  binding source 
D)  dataset 
A)  data source 
B)  table copy 
C)  binding source 
D)  dataset

Question 10

When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's ____________.

Accepted Answer

A)  Sync method 
B)  Refresh method 
C)  Fill method 
D)  Clear method 
A)  Sync method 
B)  Refresh method 
C)  Fill method 
D)  Clear method

Question 11

Once the data is stored using the database management system, applications may be written in ____________ to communicate with the DBMS.

Accepted Answer

A)  Java 
B)  C# 
C)  Visual Basic 
D)  any of these 
A)  Java 
B)  C# 
C)  Visual Basic 
D)  any of these

Question 12

The DBMS works directly with the data and sends the results of operations back to the ____________.

Accepted Answer

A)  application 
B)  data 
C)  DBMS 
D)  CPU 
A)  application 
B)  data 
C)  DBMS 
D)  CPU

Question 13

A database management system stores data in a ____________ .

Accepted Answer

A)  text file 
B)  binary file 
C)  database 
D)  source file 
A)  text file 
B)  binary file 
C)  database 
D)  source file

Question 14

A ____________ is a component that can connect user interface controls directly to a dataset.

Accepted Answer

A)  table binder 
B)  grid viewer 
C)  binding source 
D)  data source 
A)  table binder 
B)  grid viewer 
C)  binding source 
D)  data source

Question 15

To bind a ListBox control to a column, you must set two of the controls properties: DataSource and DisplayMember.

Accepted Answer

A) True 
 B)False

Question 16

In SQL, the ____________ calculates the average value in a particular column.

Accepted Answer

A)  Val keyword 
B)  # symbol 
C)  Avg function 
D)  SQL_Average statement 
A)  Val keyword 
B)  # symbol 
C)  Avg function 
D)  SQL_Average statement

Question 17

When developing applications that work with an intensive amount of data, most developers prefer to use a database management system.

Accepted Answer

A) True 
 B)False

Question 18

The ____________ identifies the table from which the data-bound control will get its data.

Accepted Answer

A)  DataSource property 
B)  Table property 
C)  primary key 
D)  DisplayMember property 
A)  DataSource property 
B)  Table property 
C)  primary key 
D)  DisplayMember property

Question 19

SQL uses database mnemonics to construct statements, which are also known as table adapter queries.

Accepted Answer

A) True 
 B)False

Question 20

You can add your own SQL queries to a table adapter and call them from your C# code.

Accepted Answer

A) True 
 B)False

The equal to and not equal to operators in SQL are different from those in C#.

Each column in a table must have a name.

In SQL, you use keywords to construct statements, which are also known as ____________.

In SQL, if you need to include a single quote as part of a string, simply write two single quotes in its place.

When you click on the ____________, a tasks panel will pop up, giving you a number of options that you can perform.

In SQL, the ____________ is used as a wildcard character, and can be used to represent any sequence of zero or more characters.

There are numerous DBMSs in use today, and Visual C# can interact with many of them.

A ____________ can display an entire database table in a scrollable grid on an application's form.

A ____________ is a source of data with which the application can work.

When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's ____________.

Once the data is stored using the database management system, applications may be written in ____________ to communicate with the DBMS.

The DBMS works directly with the data and sends the results of operations back to the ____________.

A database management system stores data in a ____________ .

A ____________ is a component that can connect user interface controls directly to a dataset.

To bind a ListBox control to a column, you must set two of the controls properties: DataSource and DisplayMember.

In SQL, the ____________ calculates the average value in a particular column.

When developing applications that work with an intensive amount of data, most developers prefer to use a database management system.

The ____________ identifies the table from which the data-bound control will get its data.

SQL uses database mnemonics to construct statements, which are also known as table adapter queries.

You can add your own SQL queries to a table adapter and call them from your C# code.

Introduction to Computers and Programming

Introduction to Visual C

Processing Data

Making Decisions

Loops, Files, and Random Numbers

Modularizing Your Code With Methods

Arrays and Lists

More About Processing Data

Classes and Multiform Projects

Inheritance and Polymorphism

Filters

Exam 11: Databases

The equal to and not equal to operators in SQL are different from those in C#.

Each column in a table must have a name.

In SQL, you use keywords to construct statements, which are also known as ____________.

In SQL, if you need to include a single quote as part of a string, simply write two single quotes in its place.

When you click on the ____________, a tasks panel will pop up, giving you a number of options that you can perform.

In SQL, the ____________ is used as a wildcard character, and can be used to represent any sequence of zero or more characters.

There are numerous DBMSs in use today, and Visual C# can interact with many of them.

A ____________ can display an entire database table in a scrollable grid on an application's form.

A ____________ is a source of data with which the application can work.

When working with data-bound controls on multiple forms, you can make sure that a dataset contains a current copy of the data by calling the table adapter's ____________.

Once the data is stored using the database management system, applications may be written in ____________ to communicate with the DBMS.

The DBMS works directly with the data and sends the results of operations back to the ____________.

A database management system stores data in a ____________ .

A ____________ is a component that can connect user interface controls directly to a dataset.

To bind a ListBox control to a column, you must set two of the controls properties: DataSource and DisplayMember.

In SQL, the ____________ calculates the average value in a particular column.

When developing applications that work with an intensive amount of data, most developers prefer to use a database management system.

The ____________ identifies the table from which the data-bound control will get its data.

SQL uses database mnemonics to construct statements, which are also known as table adapter queries.

You can add your own SQL queries to a table adapter and call them from your C# code.

Introduction to Computers and Programming

Introduction to Visual C

Processing Data

Making Decisions

Loops, Files, and Random Numbers

Modularizing Your Code With Methods

Arrays and Lists

More About Processing Data

Classes and Multiform Projects

Inheritance and Polymorphism

Filters