HTML FONTS, TAGS AND ELEMENTS QUIZ

ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

OLE DB has two types of data providers: tabular data providers and service providers.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

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

TRUE ANSWER : ?
YOUR ANSWER : ?

When using ODBC, which of the following serves as an intermediary between the application and the DBMS drivers?

OLE DB

Data source

Driver

Driver manager

TRUE ANSWER : ?
YOUR ANSWER : ?

A data source is an ODBC data structure that identifies a database and the DBMS that processes it.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

Users of OLE DB functionality are referred to as data providers.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

ODBC identifies two types of drivers: single tier and multiple-tier.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

In ODBC, a file that can be shared among database users is called a:

file data source.

system data source.

SQL text file.

user data source.

TRUE ANSWER : ?
YOUR ANSWER : ?

The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

↑