Deck 25: Atm Application

Question 1

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

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

Answer 1

Query Builder

Question 2

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

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

Answer 2

Read

Question 3

Every column in a table is a _______.

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

Answer 3

field

Question 4

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

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 5

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

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

Question 6

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

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

Question 7

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

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

Question 8

You can use the_______ to connect to a database.

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

Question 9

Which of the following statements represents a valid SELECT statement?

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.

Question 10

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

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

Question 11

The ______object is a data command object.

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

Question 12

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

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

Question 13

A _________maintains a connection to a database.

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

Question 14

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

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