Vidyalelo
Database · Q12

ODBC, OLE DB, ADO, and ASP

Programming · Database · question 12

Q12

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

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

Answer: Option B

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.