Question 1

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 2

A(n) ____________ is a column that contains unique values that are generated by the DBMS.

Accepted Answer

A)  primary key 
B)  identity column 
C)  key column 
D)  generated field 
A)  primary key 
B)  identity column 
C)  key column 
D)  generated field

Question 3

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 4

Each subsequent time an application runs, it connects to the copy of the database in the output folder instead of the project folder.

Accepted Answer

A) True 
 B)False

Question 5

SQL provides the ____________ for determining the number of rows in a table.

Accepted Answer

A)  Rows function 
B)  Count function 
C)  Max function 
D)  Volume function 
A)  Rows function 
B)  Count function 
C)  Max function 
D)  Volume function

Question 6

It is possible to change the type of control that a column is bound to in a Details view.

Accepted Answer

A) True 
 B)False

Question 7

When specifying a data type for the columns in a database table, the data types that you can choose from are provided by the ____________.

Accepted Answer

A)  DBMS 
B)  programming language 
C)  computer manufacturer 
D)  compiler 
A)  DBMS 
B)  programming language 
C)  computer manufacturer 
D)  compiler

Question 8

The Desc operator can be used to sort the results of an SQL Select query in descending order.

Accepted Answer

A) True 
 B)False

Question 9

SQL provides several functions for performing calculations.

Accepted Answer

A) True 
 B)False

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

A(n) ____________ is a column that contains unique values that are generated by the DBMS.

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

Each subsequent time an application runs, it connects to the copy of the database in the output folder instead of the project folder.

SQL provides the ____________ for determining the number of rows in a table.

It is possible to change the type of control that a column is bound to in a Details view.

When specifying a data type for the columns in a database table, the data types that you can choose from are provided by the ____________.

The Desc operator can be used to sort the results of an SQL Select query in descending order.

SQL provides several functions for performing calculations.

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

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

A(n) ____________ is a column that contains unique values that are generated by the DBMS.

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

Each subsequent time an application runs, it connects to the copy of the database in the output folder instead of the project folder.

SQL provides the ____________ for determining the number of rows in a table.

It is possible to change the type of control that a column is bound to in a Details view.

When specifying a data type for the columns in a database table, the data types that you can choose from are provided by the ____________.

The Desc operator can be used to sort the results of an SQL Select query in descending order.

SQL provides several functions for performing calculations.

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