Odbc_ Ole Db_ Ado_ And Asp MCQs with Explanations

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.

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.

INSERT, UPDATE, DELETE only is the correct answer to “ODBC minimum SQL grammar contains which of the following”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

Driver is the correct answer to “When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

Both 1 and 3 above are in the OBDC core API is the correct answer to “The ODBC core API consists of which of the following functions”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

ADO is the correct answer to “________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

Both 1 and 3 above are contained in the ODBC core SQL. is the correct answer to “ODBC core SQL grammar contains which of the following?:”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

OLE DB is the correct answer to “________ is considered to be one of the foundations of data access in the Microsoft world.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

ODBC is the correct answer to “________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

All of the above as goals of OLE DB. is the correct answer to “Which of the following are goals of OLE DB”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

data source. is the correct answer to “An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

methods. is the correct answer to “In OLE DB, actions that an object can perform are called:”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

Properties is the correct answer to “In OLE DB, which of the following represents characteristics of the recordset abstraction”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

OLE DB is the correct answer to “________ is an object-oriented interface that encapsulates data-server functionality.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

Driver manager is the correct answer to “When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

Connect to data sources with driver-specific information only is the correct answer to “The ODBC Level 1 API contains which of the following functions”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

All of the above are true of an OLE DB service provider. is the correct answer to “In OLE DB, a service provider:”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

exposes data via rowsets. is the correct answer to “In OLE DB, a tabular data provider:”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

All of the above are contained in the OBDC Level 2 API is the correct answer to “The ODBC Level 2 API contains which the following functions”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

ADO is the correct answer to “________ is a cover for utilizing OLE DB that is designed for use by almost any language.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “A file data source is one that is local to a single computer.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “An OLE DB rowset is equivalent to a cursor.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “ODBC is a foundation of data access in the specifically Microsoft world.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “An abstraction is a generalization of something.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “An OLE DB interface is specified by a set of objects and the properties and methods that they expose.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “ODBC identifies two types of drivers: single tier and multiple-tier.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “A data source is an ODBC data structure that identifies a database and the DBMS that processes it.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “Users of OLE DB functionality are referred to as data providers.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “A user data source is one that can be shared among database users.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “OLE DB tabular data providers present data in the form of rowsets.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “The ADO connection object is created after the ADO errors object is created.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “A OLE DB collection is an object that contains a group of other objects.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

True is the correct answer to “OLE DB has two types of data providers: tabular data providers and service providers.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.

False is the correct answer to “ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.”. This question is standard in competitive examination syllabi for Odbc_ Ole Db_ Ado_ And Asp.