ODBC, OLE DB, ADO, and ASP ODBC minimum SQL grammar contains which of the following? INSERT, UPDATE, DELETE only Stored Procedures only CREATE VIEW, DROP VIEW only Literals for date, time and timestamp only INSERT, UPDATE, DELETE only Stored Procedures only CREATE VIEW, DROP VIEW only Literals for date, time and timestamp 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 manager Driver OLE DB Data source Driver manager Driver OLE DB Data source ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC Level 2 API contains which the following functions? All of these Connect to data sources with driver-specific information only Connect to data sources only Commit or rollback transactions only All of these Connect to data sources with driver-specific information only Connect to data sources only Commit or rollback transactions only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source. True False True False ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP Users of OLE DB functionality are referred to as data providers. True False True False 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. False True False True ANSWER DOWNLOAD EXAMIANS APP