ODBC, OLE DB, ADO, and ASP In OLE DB, a service provider: is both a consumer and a provider of data only. does not own data only. transforms data through OLE DB interfaces only. All of these is both a consumer and a provider of data only. does not own data only. transforms data through OLE DB interfaces only. All of these 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 In ODBC, a file that can be shared among database users is called a: user data source. system data source. SQL text file. file data source. user data source. system data source. SQL text file. file data source. 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
ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: Full SELECT (includes subqueries) only Both 1 and 3 above are contained in the ODBC core SQL. INSERT, UPDATE, DELETE only Stored procedures only Full SELECT (includes subqueries) only Both 1 and 3 above are contained in the ODBC core SQL. INSERT, UPDATE, DELETE only Stored procedures only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC core API consists of which of the following functions? Connect to data sources only Both 1 and 3 above are in the OBDC core API Connect to data sources with driver-specific information only Commit or rollback transactions only Connect to data sources only Both 1 and 3 above are in the OBDC core API Connect to data sources with driver-specific information only Commit or rollback transactions only ANSWER DOWNLOAD EXAMIANS APP