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. True False True False ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed. False True False True ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP In OLE DB, a service provider: is both a consumer and a provider of data only. All of these does not own data only. transforms data through OLE DB interfaces only. is both a consumer and a provider of data only. All of these does not own data only. transforms data through OLE DB interfaces only. ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC Level 2 API contains which the following functions? 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 Connect to data sources with driver-specific information only 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. 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 ODBC minimum SQL grammar contains which of the following? Stored Procedures only Literals for date, time and timestamp only CREATE VIEW, DROP VIEW only INSERT, UPDATE, DELETE only Stored Procedures only Literals for date, time and timestamp only CREATE VIEW, DROP VIEW only INSERT, UPDATE, DELETE only ANSWER DOWNLOAD EXAMIANS APP