Question 1

Clicking the ellipsis (...) Button that appears in the OleDbCommand object's CommandText property opens______ .&#10;A) the Query Builder dialog&#10;B) the Add Table dialog&#10;C) the Server Explorer window&#10;D) Both a and b.&#10;E) None of the above.

Accepted Answer

Both a and b.&#10;

Question 2

If =? is specified in the Criteria column for a field, the name of that field will appear in the _____property.&#10;A) Variables&#10;B) Unknowns&#10;C) Parameters&#10;D) DataSource&#10;E) None of the above.

Accepted Answer

The correct term for fields specified with =? in the Criteria column, indicating a parameter query, is "Parameters." This means that the field will appear in the Parameters property, where you can define or modify the criteria for that parameter.

Question 3

Most databases are_____ databases-databases where the data is organized in tables.&#10;A) tabular&#10;B) SQL&#10;C) relational&#10;D) Access&#10;E) None of the above.

Accepted Answer

Most databases are relational databases, where data is organized in tables that can relate to each other, hence the term "relational."

Question 4

When using a Microsoft Access database, select the_____ option under the Provider tab of the Data Link Properties dialog.&#10;A) Microsoft Jet 4.0 OLE DB Provider&#10;B) Microsoft OLE DB Provider for Oracle&#10;C) Microsoft OLE DB Simple Provider&#10;D) Microsoft OLE DB Provider for Access&#10;E) None of the above.

Accepted Answer

The correct option is "Microsoft Jet 4.0 OLE DB Provider" because it is specifically designed to work with Microsoft Access databases, enabling applications to access data stored in Access databases through OLE DB.

Deck 30: Bookstore Application: Information Tier