ODBC, OLE DB, ADO, and ASP When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source? Driver manager DBMS Driver Data source Driver manager DBMS Driver Data source ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner. False True False True ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP 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 3 above are in the OBDC core API Commit or rollback transactions only Connect to data sources only Connect to data sources with driver-specific information only Both 1 and 3 above are in the OBDC core API ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP Which of the following are goals of OLE DB? Object interface over any type of data only. Increase flexibility only. All of these Create object interfaces for DBMS functionality pieces only. Object interface over any type of data only. Increase flexibility only. All of these Create object interfaces for DBMS functionality pieces only. ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: INSERT, UPDATE, DELETE only Stored procedures only Both 1 and 3 above are contained in the ODBC core SQL. Full SELECT (includes subqueries) only INSERT, UPDATE, DELETE only Stored procedures only Both 1 and 3 above are contained in the ODBC core SQL. Full SELECT (includes subqueries) only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset. True False True False ANSWER DOWNLOAD EXAMIANS APP