Question 1

Which of the following statements represents a valid SELECT statement?

Accepted Answer

A)  SELECT columnName FROM tableName WHERE criteria 
B)  SELECT tableName FROM columnName WHERE criteria 
C)  SELECT criteria FROM tableName WHERE columnName 
D)  FROM columnName SELECT tableName WHERE criteria 
E)  None of the above. 
A)  SELECT columnName FROM tableName WHERE criteria 
B)  SELECT tableName FROM columnName WHERE criteria 
C)  SELECT criteria FROM tableName WHERE columnName 
D)  FROM columnName SELECT tableName WHERE criteria 
E)  None of the above. A

Question 2

You can use the_______ to connect to a database.

Accepted Answer

A)  Solution Explorer window 
B)  Properties window 
C)  Server Explorer window 
D)  Database Explorer window 
E)  Connection Explorer window 
A)  Solution Explorer window 
B)  Properties window 
C)  Server Explorer window 
D)  Database Explorer window 
E)  Connection Explorer window C

Question 3

The_______ is a Visual Studio .NET tool that allows you to specify the commands that retrieve information from and modify information in databases.

Accepted Answer

A)  SQL Builder 
B)  Command Builder 
C)  Query Tool 
D)  Query Builder 
E)  Query Command Builder 
A)  SQL Builder 
B)  Command Builder 
C)  Query Tool 
D)  Query Builder 
E)  Query Command Builder D

Question 4

The ________of a command indicates from which specific row data will be retrieved or manipulated.

Accepted Answer

A)  table name 
B)  primary key 
C)  column name 
D)  database name 
E)  criteria 
A)  table name 
B)  primary key 
C)  column name 
D)  database name 
E)  criteria

Question 5

Every column in a table is a _______.

Accepted Answer

A)  file 
B)  database 
C)  row 
D)  primary key 
E)  field 
A)  file 
B)  database 
C)  row 
D)  primary key 
E)  field

Question 6

The ______object is a data command object.

Accepted Answer

A)  OleDbCommand 
B)  OleDataCommand 
C)  OleCommand 
D)  DataCommand 
E)  Command 
A)  OleDbCommand 
B)  OleDataCommand 
C)  OleCommand 
D)  DataCommand 
E)  Command

Question 7

The OleDbConnection object provides the _______and_______ methods, which allow you to open and close the connection to the database.

Accepted Answer

A)  Start, End 
B)  Open, Close 
C)  Connect, Close 
D)  Open, End 
E)  Connect, End 
A)  Start, End 
B)  Open, Close 
C)  Connect, Close 
D)  Open, End 
E)  Connect, End

Question 8

An OleDbDataReader can be created by calling the _______method on an OleDbCommand object.

Accepted Answer

A)  CreateReader 
B)  ExecuteReader 
C)  CreateDataReader 
D)  DataReader 
E)  NewDataReader 
A)  CreateReader 
B)  ExecuteReader 
C)  CreateDataReader 
D)  DataReader 
E)  NewDataReader

Question 9

A(n) ______enables you to access and store data without worrying about how the data is organized.

Accepted Answer

A)  MIS 
B)  DBMS 
C)  database 
D)  primary key 
E)  column 
A)  MIS 
B)  DBMS 
C)  database 
D)  primary key 
E)  column

Question 10

A _________maintains a connection to a database.

Accepted Answer

A)  connection object 
B)  data reader 
C)  StreamReader 
D)  StreamWriter 
E)  Both c and d. 
A)  connection object 
B)  data reader 
C)  StreamReader 
D)  StreamWriter 
E)  Both c and d.

Question 11

Databases should be used instead of sequential-access files for________ .

Accepted Answer

A)  instant-access applications 
B)  simple calculator applications 
C)  applications that display a welcome message and a picture 
D)  all applications 
E)  no applications. There is no reason to use a database instead of a sequential-access file. 
A)  instant-access applications 
B)  simple calculator applications 
C)  applications that display a welcome message and a picture 
D)  all applications 
E)  no applications. There is no reason to use a database instead of a sequential-access file.

Question 12

_____is the part of Microsoft's .NET platform used for interacting with databases.

Accepted Answer

A)  MDB .NET 
B)  Database .NET 
C)  Access .NET 
D)  ADO .NET 
E)  SQL .NET 
A)  MDB .NET 
B)  Database .NET 
C)  Access .NET 
D)  ADO .NET 
E)  SQL .NET

Question 13

A_____ character represents a parameter that is not yet determined in a SQL statement.

Accepted Answer

A)  exclamation mark (!) 
B)  at (@) 
C)  question mark (?) 
D)  asterisk (*) 
E)  dollar sign ($) 
A)  exclamation mark (!) 
B)  at (@) 
C)  question mark (?) 
D)  asterisk (*) 
E)  dollar sign ($)

Question 14

Use a data reader object's ______method to read information from a database.

Accepted Answer

A)  Open 
B)  ReadData 
C)  GetRecord 
D)  Read 
E)  ReadTable 
A)  Open 
B)  ReadData 
C)  GetRecord 
D)  Read 
E)  ReadTable

Exam 25: Atm Application

Which of the following statements represents a valid SELECT statement?

You can use the_______ to connect to a database.

The_______ is a Visual Studio .NET tool that allows you to specify the commands that retrieve information from and modify information in databases.

The ________of a command indicates from which specific row data will be retrieved or manipulated.

Every column in a table is a _______.

The ______object is a data command object.

The OleDbConnection object provides the _______and_______ methods, which allow you to open and close the connection to the database.

An OleDbDataReader can be created by calling the _______method on an OleDbCommand object.

A(n) ______enables you to access and store data without worrying about how the data is organized.

A _________maintains a connection to a database.

Databases should be used instead of sequential-access files for________ .

_____is the part of Microsoft's .NET platform used for interacting with databases.

A_____ character represents a parameter that is not yet determined in a SQL statement.

Use a data reader object's ______method to read information from a database.

Graphing Application

Welcome Applicationintroducing the Visual Studio Net Ide

Welcome Applicationintroduction to Visual Programming

Designing the Inventory Application

Completing the Inventory Application

Enhancing the Inventory Application

Wage Calculator Application

Dental Payment Application

Car Payment Calculator Application

Class Average Application

Interest Calculator Application

Security Panel Application

Enhancing the Wage Calculator Application

Shipping Time Application

Fund Raiser Application

Craps Game Application

Flag Exam Application

Sales Data Application

Microwave Oven Application

Shipping Hub Application

Cat and Mouse Painter Application

Typing Application

Screen Scraping Application

Ticket Information Application

Checkwriter Application

Phone Book Application

Bookstore Application: Web Applications

Bookstore Application: Client Tier

Bookstore Application: Information Tier

Bookstore Application: Middle Tier

Appendix a Operator Precedence Chart

Filters

The OleDbConnection object provides the _and_ methods, which allow you to open and close the connection to the database.