IndiaBIX

Database - ODBC, OLE DB, ADO, and ASP

Exercise : ODBC, OLE DB, ADO, and ASP - General Questions
1.
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
Answer: Option
Explanation:
No answer description is available. Let's discuss.
2.
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
Answer: Option
Explanation:
No answer description is available. Let's discuss.
3.
The ODBC core API consists of which of the following functions?
Commit or rollback transactions only
Connect to data sources with driver-specific information only
Connect to data sources only
Both 1 and 3 above are in the OBDC core API.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
4.
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
ASP
XML
ODBC
ADO
Answer: Option
Explanation:
No answer description is available. Let's discuss.
5.
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.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers