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. Stored procedures only INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only Both 1 and 3 above are contained in the ODBC core SQL. Stored procedures only INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP In ODBC, a file that can be shared among database users is called a: file data source. system data source. SQL text file. user data source. file data source. system data source. SQL text file. user data source. ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP In OLE DB, a service provider: All of these transforms data through OLE DB interfaces only. is both a consumer and a provider of data only. does not own data only. All of these transforms data through OLE DB interfaces only. is both a consumer and a provider of data only. does not own data 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 Connect to data sources with driver-specific information only Commit or rollback transactions only All of these Connect to data sources only Connect to data sources with driver-specific information only Commit or rollback transactions only All of these ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP A user data source is one that can be shared among database users. True False True False ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP Which of the following are goals of OLE DB? Object interface over any type of data only. All of these Create object interfaces for DBMS functionality pieces only. Increase flexibility only. Object interface over any type of data only. All of these Create object interfaces for DBMS functionality pieces only. Increase flexibility only. ANSWER DOWNLOAD EXAMIANS APP