ODBC, OLE DB, ADO, and ASP - General Questions Online Exam Quiz
ODBC, OLE DB, ADO, and ASP - General Questions GK Quiz. Question and Answers related to ODBC, OLE DB, ADO, and ASP - General Questions. MCQ (Multiple Choice Questions with answers about ODBC, OLE DB, ADO, and ASP - General Questions
ODBC minimum SQL grammar contains which of the following?
Options
A : INSERT, UPDATE, DELETE only
B : Stored Procedures only
C : Literals for date, time and timestamp only
D : CREATE VIEW, DROP VIEW only
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Options
A : Data source
B : Driver
C : Driver manager
D : DBMS
The ODBC core API consists of which of the following functions?
Options
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.
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
Options
A : ASP
B : XML
C : ODBC
D : ADO
ODBC core SQL grammar contains which of the following?:
Options
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.
________ is considered to be one of the foundations of data access in the Microsoft world.
Options
A : ODBC
B : OLE DB
C : JPCD
D : ADO
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options
A : ODBC
B : OLE DB
C : JPCD
D : ADO
Which of the following are goals of OLE DB?
Options
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.
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Options
A : data source.
B : driver manager.
C : driver.
D : API.
In OLE DB, actions that an object can perform are called:
Options
A : properties.
B : collections.
C : methods.
D : abstractions.
Advanced SQL - General Questions more Online Exam Quiz
SQL Server 2000 - General Questions
Managing Multiuser Databases - General Questions
Modeling Data in the Organization - General Questions
Object-Oriented Database - General Questions
Object-Oriented Data Modeling - General Questions
Physical Database Design - General Questions
SQL for Database Construction - General Questions
The Client-Server Database - General Questions