Bissoy
Login
Register
Home
MCQs
Job Preparation
Database
ODBC
Database | ODBC
Practice Database | ODBC on Bissoy — browse topics below and open any question.
Test my Merit
My Results
Create Exam
OLE DB
Questions
The ODBC core API consists of which of the following functions?
ক
Commit or rollback transactions only
খ
Connect to data sources only
গ
Connect to data sources with driver-specific information only
ঘ
Both 1 and 2 above are in the OBDC core API.
Which of the following are goals of OLE DB?
ক
Create object interfaces for DBMS functionality pieces only.
খ
Increase flexibility only.
গ
Object interface over any type of data only.
ঘ
All of the above as goals of OLE DB.
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
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 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.
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
ক
ODBC
খ
OLE DB
গ
JPCD
ঘ
ADO
In OLE DB, which of the following represents characteristics of the recordset abstraction?
ক
Properties
খ
Collections
গ
Methods
ঘ
Abstractions
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
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
ক
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
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
ক
True
খ
False