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.
Answer: Option C
Solution (By Examveda Team)
Option A: system data sourceThis 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.
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