ODBC, OLE, ADO, and ASP Questions and Answers

Practice Mode
Showing 10 of 20 questions
Q1
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
Answer: Option A
Q2
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
  • A Data source
  • B Driver
  • C Driver manager
  • D DBMS
Answer: Option B
Q3
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.
Answer: Option D
Q4
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
  • A ASP
  • B XML
  • C ODBC
  • D ADO
Answer: Option D
Q5
ODBC core SQL grammar contains which of the following?:
  • A INSERT, UPDATE, DELETE only
  • B Stored procedures only
  • C Full SELECT (includes subqueries) only
  • D Both 1 and 3 above are contained in the ODBC core SQL.
Answer: Option D
Q6
 ________ is considered to be one of the foundations of data access in the Microsoft world.
  • A ODBC
  • B OLE DB
  • C JPCD
  • D ADO
Answer: Option B
Q7
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
  • A ODBC
  • B OLE DB
  • C JPCD
  • D ADO
Answer: Option A
Q8
Which of the following are goals of OLE DB?
  • A Create object interfaces for DBMS functionality pieces only.
  • B Increase flexibility only.
  • C Object interface over any type of data only.
  • D All of the above as goals of OLE DB.
Answer: Option D
Q9
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
  • A data source.
  • B driver manager.
  • C driver.
  • D API.
Answer: Option A
Q10
In OLE DB, actions that an object can perform are called:
  • A properties.
  • B collections.
  • C methods.
  • D abstractions.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test