ODBC minimum SQL grammar contains which of the following?
Select an option to see the answer and solution.
Database · all questionsODBC, OLE DB, ADO, and ASP
ODBC, OLE DB, ADO, and ASP
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
40
Questions
1/2
Page
Pick an option on a question to see the right answer and solution.
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Select an option to see the answer and solution.
The ODBC core API consists of which of the following functions?
Select an option to see the answer and solution.
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Select an option to see the answer and solution.
ODBC core SQL grammar contains which of the following?:
Select an option to see the answer and solution.
________ is considered to be one of the foundations of data access in the Microsoft world.
Select an option to see the answer and solution.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Select an option to see the answer and solution.
Which of the following are goals of OLE DB?
Select an option to see the answer and solution.
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Select an option to see the answer and solution.
In OLE DB, actions that an object can perform are called:
Select an option to see the answer and solution.
In OLE DB, which of the following represents characteristics of the recordset abstraction?
Select an option to see the answer and solution.
In ODBC, a file that can be shared among database users is called a:
Select an option to see the answer and solution.
________ is an object-oriented interface that encapsulates data-server functionality.
Select an option to see the answer and solution.
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?
Select an option to see the answer and solution.
The ODBC Level 1 API contains which of the following functions?
Select an option to see the answer and solution.
In OLE DB, a service provider:
Select an option to see the answer and solution.
In OLE DB, a tabular data provider:
Select an option to see the answer and solution.
The ODBC Level 2 API contains which the following functions?
Select an option to see the answer and solution.
In ODBC, a data source that is local to a single computer is called a:
Select an option to see the answer and solution.
________ is a cover for utilizing OLE DB that is designed for use by almost any language.
Select an option to see the answer and solution.