ODBC, OLE DB, ADO, and ASP - Database MCQ Questions and answers- Technical Aptitude

11

In OLE DB, which of the following represents characteristics of the recordset abstraction?

A) Properties B) Collections C) Methods D) Abstractions

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

12

In ODBC, a file that can be shared among database users is called a:

A) system data source. B) file data source. C) user data source. D) SQL text file.

Discuss

Answer & Solution

Answer: Option B

Solution:

Option A: system data source

This option is incorrect. A system data source is accessible by all users on a single computer and is not typically shared among multiple users across different computers.

Option B: file data source

This option is correct. A file data source (also known as a DSN file) is stored in a file and can be shared among multiple users and computers. It allows multiple users to access the same data source configuration.

Option C: user data source

This option is incorrect. A user data source is specific to a single user and is not intended to be shared among multiple users.

Option D: SQL text file

This option is incorrect. An SQL text file refers to a file containing SQL commands and is not a type of data source in ODBC.

Conclusion:

In ODBC, a file that can be shared among database users is called a file data source, making Option B: file data source the correct answer.

13

________ is an object-oriented interface that encapsulates data-server functionality.

A) ODBC B) OLE DB C) JPCD D) ADO

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

14

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

A) Data source B) Driver C) Driver manager D) OLE DB

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

15

The ODBC Level 1 API contains which of the following functions?

A) Browse possible connections and data sources only B) Connect to data sources with driver-specific information only C) Process a scrollable cursor only D) Both 1 and 3 above are in the OBDC Level 1 API

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

16

In OLE DB, a service provider:

A) does not own data only. B) transforms data through OLE DB interfaces only. C) is both a consumer and a provider of data only. D) All of the above are true of an OLE DB service provider.

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

17

In OLE DB, a tabular data provider:

A) does not own data. B) transforms data through ODE DB interfaces. C) is both a consumer and a provider of data. D) exposes data via rowsets.

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

18

The ODBC Level 2 API contains which the following functions?

A) Commit or rollback transactions only B) Connect to data sources with driver-specific information only C) Connect to data sources only D) All of the above are contained in the OBDC Level 2 API

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

19

In ODBC, a data source that is local to a single computer is called a:

A) system data source. B) file data source. C) user data source. D) SQL text file.

Discuss

Answer & Solution

Answer: Option C

Solution:

Option A: system data source

This option is incorrect. A system data source is accessible by all users on a computer and typically requires administrative privileges to create or modify. It is not restricted to a single user.

Option B: file data source

This option is incorrect. A file data source (also known as a DSN file) is stored in a file and can be shared among multiple users and computers. It is not local to a single computer.

Option C: user data source

This option is correct. A user data source is specific to a single user and is only accessible by that user. It is stored in the user profile and is local to the user's computer.

Option D: SQL text file

This option is incorrect. An SQL text file refers to a file containing SQL commands and is not a type of data source in ODBC.

Conclusion:

In ODBC, a data source that is local to a single computer is called a user data source, making Option C: user data source the correct answer.

20

________ is a cover for utilizing OLE DB that is designed for use by almost any language.

A) ODBC B) ASP C) JPCD D) ADO

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board