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 on Bissoy. Bissoy App

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

  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 OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
  ক

  True

  খ

  False
• 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
• In OLE DB, which of the following represents characteristics of the recordset abstraction?
  ক

  Properties

  খ

  Collections

  গ

  Methods

  ঘ

  Abstractions
• ________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
  ক

  ODBC

  খ

  OLE DB

  গ

  JPCD

  ঘ

  ADO
• ODBC core SQL grammar contains which of the following?:
  ক

  INSERT, UPDATE, DELETE only

  খ

  Stored procedures only

  গ

  Full SELECT (includes subqueries) only

  ঘ

  Both 1 and 3 above are contained in the ODBC core SQL.
• When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
  ক

  Data source

  খ

  Driver

  গ

  Driver manager

  ঘ

  DBMS
• ODBC minimum SQL grammar contains which of the following?
  ক

  INSERT, UPDATE, DELETE only

  খ

  Stored Procedures only

  গ

  Literals for date, time and timestamp only

  ঘ

  CREATE VIEW, DROP VIEW only