Question 1

If a column contains no data, it is said to be ____________.

Accepted Answer

A)  null 
B)  empty 
C)  void 
D)  open 
A)  null 
B)  empty 
C)  void 
D)  open

Question 2

The table column designated as the primary key must hold a unique value for each row.

Accepted Answer

A) True 
 B)False

Question 3

If an application needs to store only a small amount of data, sequential and binary files are efficient and easy to use.

Accepted Answer

A) True 
 B)False

Question 4

When you make changes to a database table in one form, the changes automatically appear in other forms that connect to the same table using their own datasets.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

When you use Visual Studio to create a database, the database file will be created in the project folder.

Accepted Answer

A) True 
 B)False

Question 7

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 8

In SQL, you use the ____________ to retrieve the rows in a table.

Accepted Answer

A)  Read statement 
B)  Get expression 
C)  Select statement 
D)  Row keyword 
A)  Read statement 
B)  Get expression 
C)  Select statement 
D)  Row keyword

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A .NET application requires a set of special components that let it connect to, and work with, a database.

Accepted Answer

A) True 
 B)False

Question 11

In SQL, strings are enclosed in ____________.

Accepted Answer

A)  single quotes 
B)  underscores 
C)  asterisks 
D)  brackets 
A)  single quotes 
B)  underscores 
C)  asterisks 
D)  brackets

Question 12

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 13

A ____________ connects to a data source and can retrieve and update data from a table in a data source.

Accepted Answer

A)  source reference 
B)  table connection 
C)  table adapter 
D)  binding source 
A)  source reference 
B)  table connection 
C)  table adapter 
D)  binding source

Question 14

Data-bound controls automatically display data from a data source and can be used to modify the data they are bound to.

Accepted Answer

A) True 
 B)False

Question 15

When you create a database table, you must specify a data type for each column.

Accepted Answer

A) True 
 B)False

Question 16

In SQL, the ____________ can be used to search for a substring.

Accepted Answer

A)  Sub method 
B)  Contains statement 
C)  Who instruction 
D)  Like operator 
A)  Sub method 
B)  Contains statement 
C)  Who instruction 
D)  Like operator

Question 17

In SQL, the asterisk symbol is used as a wildcard to represent a single character.

Accepted Answer

A) True 
 B)False

Question 18

A ____________ is a complete set of information about a single item in a table.

Accepted Answer

A)  bit 
B)  column 
C)  cell 
D)  row 
A)  bit 
B)  column 
C)  cell 
D)  row

Question 19

Rather than displaying multiple rows at once, a Details view lets the user see one row at a time.

Accepted Answer

A) True 
 B)False

Question 20

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.

If a column contains no data, it is said to be ____________.

The table column designated as the primary key must hold a unique value for each row.

If an application needs to store only a small amount of data, sequential and binary files are efficient and easy to use.

When you make changes to a database table in one form, the changes automatically appear in other forms that connect to the same table using their own datasets.

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

When you use Visual Studio to create a database, the database file will be created in the project folder.

A database management system stores data in a ____________ .

In SQL, you use the ____________ to retrieve the rows in a table.

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

A .NET application requires a set of special components that let it connect to, and work with, a database.

In SQL, strings are enclosed in ____________.

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

A ____________ connects to a data source and can retrieve and update data from a table in a data source.

Data-bound controls automatically display data from a data source and can be used to modify the data they are bound to.

When you create a database table, you must specify a data type for each column.

In SQL, the ____________ can be used to search for a substring.

In SQL, the asterisk symbol is used as a wildcard to represent a single character.

A ____________ is a complete set of information about a single item in a table.

Rather than displaying multiple rows at once, a Details view lets the user see one row at a time.

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

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

If a column contains no data, it is said to be ____________.

The table column designated as the primary key must hold a unique value for each row.

If an application needs to store only a small amount of data, sequential and binary files are efficient and easy to use.

When you make changes to a database table in one form, the changes automatically appear in other forms that connect to the same table using their own datasets.

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

When you use Visual Studio to create a database, the database file will be created in the project folder.

A database management system stores data in a ____________ .

In SQL, you use the ____________ to retrieve the rows in a table.

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

A .NET application requires a set of special components that let it connect to, and work with, a database.

In SQL, strings are enclosed in ____________.

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

A ____________ connects to a data source and can retrieve and update data from a table in a data source.

Data-bound controls automatically display data from a data source and can be used to modify the data they are bound to.

When you create a database table, you must specify a data type for each column.

In SQL, the ____________ can be used to search for a substring.

In SQL, the asterisk symbol is used as a wildcard to represent a single character.

A ____________ is a complete set of information about a single item in a table.

Rather than displaying multiple rows at once, a Details view lets the user see one row at a time.

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

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