Database - ODBC, OLE, ADO, and ASP
Database - ODBC, OLE, ADO, and ASP
1. ODBC minimum SQL grammar contains which of the following?
- INSERT, UPDATE, DELETE only
- Stored Procedures only
- Literals for date, time and timestamp only
- CREATE VIEW, DROP VIEW only
2. When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
- Data source
- Driver
- Driver manager
- DBMS
3. The ODBC core API consists of which of the following functions?
- Commit or rollback transactions only
- Connect to data sources with driver-specific information only
- Connect to data sources only
- Both 1 and 3 above are in the OBDC core API.
4. ________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.
- ASP
- XML
- ODBC
- ADO
5. ODBC core SQL grammar contains which of the following?:
- INSERT, UPDATE, DELETE only
- Stored procedures only
- Full SELECT (includes subqueries) only
- Both 1 and 3 above are contained in the ODBC core SQL.
6. ________ is considered to be one of the foundations of data access in the Microsoft world.
- ODBC
- OLE DB
- JPCD
- ADO
7. ________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
- ODBC
- OLE DB
- JPCD
- ADO
8. Which of the following are goals of OLE DB?
- Create object interfaces for DBMS functionality pieces only.
- Increase flexibility only.
- Object interface over any type of data only.
- All of the above as goals of OLE DB.
9. An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
- data source.
- driver manager.
- driver.
- API.
10. In OLE DB, actions that an object can perform are called:
- properties.
- collections.
- methods.
- abstractions.