MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
ODBC, OLE DB, ADO, And ASP
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
True
False
Q.2
A OLE DB collection is an object that contains a group of other objects.
True
False
Q.3
OLE DB has two types of data providers: tabular data providers and service providers.
True
False
Q.4
The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
True
False
Q.5
ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.
True
False
Q.6
A user data source is one that can be shared among database users.
True
False
Q.7
ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
True
False
Q.8
OLE DB tabular data providers present data in the form of rowsets.
True
False
Q.9
The ADO connection object is created after the ADO errors object is created.
True
False
Q.10
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
Q.11
A file data source is one that is local to a single computer.
True
False
Q.12
An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
True
False
Q.13
An OLE DB rowset is equivalent to a cursor.
True
False
Q.14
ODBC is a foundation of data access in the specifically Microsoft world.
True
False
Q.15
An abstraction is a generalization of something.
True
False
Q.16
An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
True
False
Q.17
In OLE DB, a service provider:
does not own data only.
transforms data through OLE DB interfaces only.
is both a consumer and a provider of data only.
All of the above are true of an OLE DB service provider.
Q.18
In OLE DB, which of the following represents characteristics of the recordset abstraction?
Properties
Collections
Methods
Abstractions
Q.19
A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
True
False
Q.20
ODBC identifies two types of drivers: single tier and multiple-tier.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page