ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: Full SELECT (includes subqueries) only INSERT, UPDATE, DELETE only Both 1 and 3 above are contained in the ODBC core SQL. Stored procedures only Full SELECT (includes subqueries) only INSERT, UPDATE, DELETE only Both 1 and 3 above are contained in the ODBC core SQL. Stored procedures 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 Data source OLE DB Driver Driver manager Data source OLE DB Driver ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process. False True False True 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 OLE DB has two types of data providers: tabular data providers and service providers. False True False True ANSWER DOWNLOAD EXAMIANS APP