ODBC, OLE DB, ADO, and ASP ODBC minimum SQL grammar contains which of the following? INSERT, UPDATE, DELETE only CREATE VIEW, DROP VIEW only Stored Procedures only Literals for date, time and timestamp only INSERT, UPDATE, DELETE only CREATE VIEW, DROP VIEW only Stored Procedures only Literals for date, time and timestamp only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP ODBC core SQL grammar contains which of the following?: Stored procedures only Both 1 and 3 above are contained in the ODBC core SQL. INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only Stored procedures only Both 1 and 3 above are contained in the ODBC core SQL. INSERT, UPDATE, DELETE only Full SELECT (includes subqueries) only ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed. True False True False 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 Driver manager Data source DBMS Driver Driver manager Data source ANSWER DOWNLOAD EXAMIANS APP
ODBC, OLE DB, ADO, and ASP OLE DB tabular data providers present data in the form of rowsets. False True False True 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 Driver manager OLE DB Data source Driver Driver manager OLE DB Data source ANSWER DOWNLOAD EXAMIANS APP