ODBC core SQL grammar contains which of the following?: Both 1 and 3 above are contained in the ODBC core SQL. Stored procedures only INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only TRUE ANSWER : ? YOUR ANSWER : ?
The ODBC Level 2 API contains which the following functions? Connect to data sources only Commit or rollback transactions only All of these Connect to data sources with driver-specific information only TRUE ANSWER : ? YOUR ANSWER : ?
In ODBC, a data source that is local to a single computer is called a: file data source. user data source. system data source. SQL text file. TRUE ANSWER : ? YOUR ANSWER : ?
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source? Driver manager Driver Data source DBMS TRUE ANSWER : ? YOUR ANSWER : ?
The ODBC core API consists of which of the following functions? Commit or rollback transactions only Both 1 and 3 above are in the OBDC core API Connect to data sources only Connect to data sources with driver-specific information only TRUE ANSWER : ? YOUR ANSWER : ?
A data source is an ODBC data structure that identifies a database and the DBMS that processes it. True False TRUE ANSWER : ? YOUR ANSWER : ?
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner. ODBC OLE DB JPCD ADO TRUE ANSWER : ? YOUR ANSWER : ?
________ is considered to be one of the foundations of data access in the Microsoft world. ODBC ADO JPCD OLE DB TRUE ANSWER : ? YOUR ANSWER : ?
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications. ADO ASP XML ODBC TRUE ANSWER : ? YOUR ANSWER : ?