ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: Both 1 and 3 above are contained in the ODBC core SQL. INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only Stored procedures only Both 1 and 3 above are contained in the ODBC core SQL. INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only Stored procedures only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers? Driver OLE DB Driver manager Data source Driver OLE DB Driver manager Data source ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC Level 2 API contains which the following functions? Connect to data sources with driver-specific information only Connect to data sources only All of these Commit or rollback transactions only Connect to data sources with driver-specific information only Connect to data sources only All of these Commit or rollback transactions only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC minimum SQL grammar contains which of the following? Stored Procedures only INSERT, UPDATE, DELETE only CREATE VIEW, DROP VIEW only Literals for date, time and timestamp only Stored Procedures only INSERT, UPDATE, DELETE only CREATE VIEW, DROP VIEW only Literals for date, time and timestamp only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC identifies two types of drivers: single tier and multiple-tier. False True False True ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP An OLE DB interface is specified by a set of objects and the properties and methods that they expose. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS