ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: 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 Full SELECT (includes subqueries) only INSERT, UPDATE, DELETE only Both 1 and 3 above are contained in the ODBC core SQL. ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP An OLE DB rowset is equivalent to a cursor. True False True False 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 OLE DB Data source Driver Driver manager OLE DB Data source Driver ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP In ODBC, a data source that is local to a single computer is called a: SQL text file. system data source. file data source. user data source. SQL text file. system data source. file data source. user data source. ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC Level 1 API contains which of the following functions? Browse possible connections and data sources only Connect to data sources with driver-specific information only Both 1 and 3 above are in the OBDC Level 1 API Process a scrollable cursor only Browse possible connections and data sources only Connect to data sources with driver-specific information only Both 1 and 3 above are in the OBDC Level 1 API Process a scrollable cursor only 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. True False True False ANSWER DOWNLOAD EXAMIANS APP