ODBC MCQ

Test your knowledge with important ODBC MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more ODBC MCQs at Bissoy

• ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
  ক

  True

  খ

  False
• The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
  ক

  True

  খ

  False
• OLE DB has two types of data providers: tabular data providers and service providers.
  ক

  True

  খ

  False
• A OLE DB collection is an object that contains a group of other objects.
  ক

  True

  খ

  False
• ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
  ক

  True

  খ

  False
• The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
  ক

  True

  খ

  False
• The ADO connection object is created after the ADO errors object is created.
  ক

  True

  খ

  False
• OLE DB tabular data providers present data in the form of rowsets.
  ক

  True

  খ

  False
• ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
  ক

  True

  খ

  False
• A user data source is one that can be shared among database users.
  ক

  True

  খ

  False
• Users of OLE DB functionality are referred to as data providers.
  ক

  True

  খ

  False
• A data source is an ODBC data structure that identifies a database and the DBMS that processes it.
  ক

  True

  খ

  False
• ODBC identifies two types of drivers: single tier and multiple-tier.
  ক

  True

  খ

  False
• A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
  ক

  True

  খ

  False
• An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
  ক

  True

  খ

  False
• An abstraction is a generalization of something.
  ক

  True

  খ

  False
• ODBC is a foundation of data access in the specifically Microsoft world.
  ক

  True

  খ

  False
• An OLE DB rowset is equivalent to a cursor.
  ক

  True

  খ

  False
• An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
  ক

  True

  খ

  False
• A file data source is one that is local to a single computer.
  ক

  True

  খ

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

  ODBC

  খ

  ASP

  গ

  JPCD

  ঘ

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

  system data source.

  খ

  file data source.

  গ

  user data source.

  ঘ

  SQL text file.
• The ODBC Level 2 API contains which the following functions?
  ক

  Commit or rollback transactions only

  খ

  Connect to data sources with driver-specific information only

  গ

  Connect to data sources only

  ঘ

  All of the above are contained in the OBDC Level 2 API
• In OLE DB, a tabular data provider:
  ক

  does not own data.

  খ

  transforms data through ODE DB interfaces.

  গ

  is both a consumer and a provider of data.

  ঘ

  exposes data via rowsets.
• In OLE DB, a service provider:
  ক

  does not own data only.

  খ

  transforms data through OLE DB interfaces only.

  গ

  is both a consumer and a provider of data only.

  ঘ

  All of the above are true of an OLE DB service provider.
• When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
  ক

  Data source

  খ

  Driver

  গ

  Driver manager

  ঘ

  OLE DB
• ________ is an object-oriented interface that encapsulates data-server functionality.
  ক

  ODBC

  খ

  OLE DB

  গ

  JPCD

  ঘ

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

  system data source.

  খ

  file data source.

  গ

  user data source.

  ঘ

  SQL text file.
• In OLE DB, which of the following represents characteristics of the recordset abstraction?
  ক

  Properties

  খ

  Collections

  গ

  Methods

  ঘ

  Abstractions
• In OLE DB, actions that an object can perform are called:
  ক

  properties.

  খ

  collections.

  গ

  methods.

  ঘ

  abstractions.