MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 40 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Users of OLE DB functionality are referred to as data providers. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 2. |
ODBC identifies two types of drivers: single tier and multiple-tier. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 3. |
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 4. |
The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 5. |
The ADO connection object is created after the ADO errors object is created. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 6. |
A OLE DB collection is an object that contains a group of other objects. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 7. |
OLE DB tabular data providers present data in the form of rowsets. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 8. |
A data source is an ODBC data structure that identifies a database and the DBMS that processes it. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 9. |
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 10. |
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 11. |
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 12. |
OLE DB has two types of data providers: tabular data providers and service providers. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 13. |
An abstraction is a generalization of something. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 14. |
In ODBC, a data source that is local to a single computer is called a: |
| A. | system data source. |
| B. | file data source. |
| C. | user data source. |
| D. | SQL text file. |
| Answer» B. file data source. | |
| 15. |
________ is a cover for utilizing OLE DB that is designed for use by almost any language. |
| A. | ODBC |
| B. | ASP |
| C. | JPCD |
| D. | ADO |
| Answer» E. | |
| 16. |
Which of the following are goals of OLE DB? |
| A. | Create object interfaces for DBMS functionality pieces only. |
| B. | Increase flexibility only. |
| C. | Object interface over any type of data only. |
| D. | All of the above as goals of OLE DB. |
| Answer» E. | |
| 17. |
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 18. |
ODBC is a foundation of data access in the specifically Microsoft world. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 19. |
The ODBC Level 2 API contains which the following functions? |
| A. | Commit or rollback transactions only |
| B. | Connect to data sources with driver-specific information only |
| C. | Connect to data sources only |
| D. | All of the above are contained in the OBDC Level 2 API |
| Answer» E. | |
| 20. |
In ODBC, a file that can be shared among database users is called a: |
| A. | system data source. |
| B. | file data source. |
| C. | user data source. |
| D. | SQL text file. |
| Answer» C. user data source. | |
| 21. |
________ is an object-oriented interface that encapsulates data-server functionality. |
| A. | ODBC |
| B. | OLE DB |
| C. | JPCD |
| D. | ADO |
| Answer» C. JPCD | |
| 22. |
A user data source is one that can be shared among database users. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 23. |
In OLE DB, a tabular data provider: |
| A. | does not own data. |
| B. | transforms data through ODE DB interfaces. |
| C. | is both a consumer and a provider of data. |
| D. | exposes data via rowsets. |
| Answer» E. | |
| 24. |
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 25. |
An ODBC data structure that identifies a database and the DBMS that processes it is called a(n): |
| A. | data source. |
| B. | driver manager. |
| C. | driver. |
| D. | API. |
| Answer» B. driver manager. | |
| 26. |
In OLE DB, actions that an object can perform are called: |
| A. | properties. |
| B. | collections. |
| C. | methods. |
| D. | abstractions. |
| Answer» D. abstractions. | |
| 27. |
When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers? |
| A. | Data source |
| B. | Driver |
| C. | Driver manager |
| D. | OLE DB |
| Answer» D. OLE DB | |
| 28. |
An OLE DB interface is specified by a set of objects and the properties and methods that they expose. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 29. |
________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner. |
| A. | ODBC |
| B. | OLE DB |
| C. | JPCD |
| D. | ADO |
| Answer» B. OLE DB | |
| 30. |
The ODBC Level 1 API contains which of the following functions? |
| A. | Browse possible connections and data sources only |
| B. | Connect to data sources with driver-specific information only |
| C. | Process a scrollable cursor only |
| D. | Both 1 and 3 above are in the OBDC Level 1 API. |
| Answer» C. Process a scrollable cursor only | |
| 31. |
An OLE DB rowset is equivalent to a cursor. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 32. |
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications. |
| A. | ASP |
| B. | XML |
| C. | ODBC |
| D. | ADO |
| Answer» E. | |
| 33. |
________ is considered to be one of the foundations of data access in the Microsoft world. |
| A. | ODBC |
| B. | OLE DB |
| C. | JPCD |
| D. | ADO |
| Answer» C. JPCD | |
| 34. |
The ODBC core API consists of which of the following functions? |
| A. | Commit or rollback transactions only |
| B. | Connect to data sources with driver-specific information only |
| C. | Connect to data sources only |
| D. | Both 1 and 3 above are in the OBDC core API. |
| Answer» E. | |
| 35. |
When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source? |
| A. | Data source |
| B. | Driver |
| C. | Driver manager |
| D. | DBMS |
| Answer» C. Driver manager | |
| 36. |
In OLE DB, a service provider: |
| A. | does not own data only. |
| B. | transforms data through OLE DB interfaces only. |
| C. | is both a consumer and a provider of data only. |
| D. | All of the above are true of an OLE DB service provider. |
| Answer» E. | |
| 37. |
ODBC core SQL grammar contains which of the following?: |
| A. | INSERT, UPDATE, DELETE only |
| B. | Stored procedures only |
| C. | Full SELECT (includes subqueries) only |
| D. | Both 1 and 3 above are contained in the ODBC core SQL. |
| Answer» E. | |
| 38. |
In OLE DB, which of the following represents characteristics of the recordset abstraction? |
| A. | Properties |
| B. | Collections |
| C. | Methods |
| D. | Abstractions |
| Answer» B. Collections | |
| 39. |
A file data source is one that is local to a single computer. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 40. |
ODBC minimum SQL grammar contains which of the following? |
| A. | INSERT, UPDATE, DELETE only |
| B. | Stored Procedures only |
| C. | Literals for date, time and timestamp only |
| D. | CREATE VIEW, DROP VIEW only |
| Answer» B. Stored Procedures only | |