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.
Answer: Option B
Solution (By Examveda Team)
Option A: system data sourceThis 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.
Related Questions on ODBC, OLE DB, ADO, and ASP
ODBC minimum SQL grammar contains which of the following?
A. INSERT, UPDATE, DELETE only
B. Stored Procedures only
C. Literals for date, time and timestamp only
D. CREATE VIEW, DROP VIEW only
A. Data source
B. Driver
C. Driver manager
D. DBMS
The ODBC core API consists of which of 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. Both 1 and 3 above are in the OBDC core API

Join The Discussion