ODBC, OLE DB, ADO, and ASP ODBC minimum SQL grammar contains which of the following? INSERT, UPDATE, DELETE only Literals for date, time and timestamp only Stored Procedures only CREATE VIEW, DROP VIEW only INSERT, UPDATE, DELETE only Literals for date, time and timestamp only Stored Procedures only CREATE VIEW, DROP VIEW only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC core API consists of which of the following functions? Both 1 and 3 above are in the OBDC core API Connect to data sources with driver-specific information only Connect to data sources only Commit or rollback transactions only Both 1 and 3 above are in the OBDC core API 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 ODBC is a foundation of data access in the specifically Microsoft world. True False True False ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP In OLE DB, a tabular data provider: exposes data via rowsets. is both a consumer and a provider of data. does not own data. transforms data through ODE DB interfaces. exposes data via rowsets. is both a consumer and a provider of data. does not own data. transforms data through ODE DB interfaces. ANSWER DOWNLOAD EXAMIANS APP
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. 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 INSERT, UPDATE, DELETE only Stored procedures only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes. False True False True ANSWER DOWNLOAD EXAMIANS APP