ODBC, OLE DB, ADO, and ASP ________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner. OLE DB ODBC ADO JPCD OLE DB ODBC ADO JPCD ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The ODBC Level 2 API contains which the following functions? 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 Connect to data sources only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC minimum SQL grammar contains which of the following? CREATE VIEW, DROP VIEW only Literals for date, time and timestamp only INSERT, UPDATE, DELETE only Stored Procedures only CREATE VIEW, DROP VIEW only Literals for date, time and timestamp only INSERT, UPDATE, DELETE only Stored Procedures 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: system data source. file data source. user data source. SQL text file. system data source. file data source. user data source. SQL text file. ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: 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 Full SELECT (includes subqueries) only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source? DBMS Driver manager Driver Data source DBMS Driver manager Driver Data source ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS