Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ISE 224 > Chapter 11 > Flashcards

Chapter 11 Flashcards

1
Q

Every DBMS product has an application programming interface (API).

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Every DBMS product uses the same API.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

ODBC stands for Open Database Connectivity.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

If a server is using a Microsoft Windows operating system, it is usually running Internet Information Server (IIS) as its Web server.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The most commonly used Web server on servers running the Unix or Linux operating system is Internet Information Server (IIS).

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

If the Web server and the DBMS are running on the same server, the system has a three-tier architecture.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

ODBC has not had practical success, but has shown great potential for future development.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

ODBC works with table-like data sources such as relational databases and spreadsheets.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

ODBC acts as a wrapper for OLE DB.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

With ODBC, a database and the DBMS that processes it are identified by the data source.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

With ODBC, the driver manager serves as an intermediary between the application and the DBMS drivers.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

With ODBC, only a single driver is needed to handle all data source types, such as Oracle, DB2, and Access.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

In ODBC, the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A multiple-tier ODBC driver may reformat an SQL request, but it does not actually process the SQL statement.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

With ODBC, a file data source is available only to the user that created it.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

In general, the best type of ODBC data source to define for a Web application is a system data source.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

OLE DB objects are COM objects.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

OLE DB can be used to access ODBC data sources.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

OLE DB is an object-oriented interface.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

In OLE DB, a RecordSet is a more abstract representation of a rowset.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Object classes have properties that represent characteristics of the objects in the class.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

One of the properties of all collections is Count, which is the number of objects in the collection.

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q 
Which of the following can only interact with relational database and table-like data structures?
A) OLE DB
B) ODBC
C) ASP
D) ADO
E) All of the above
A

B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Which of the following is true about ODBC?
A) ODBC has experienced little practical success.
B) ODBC requires developers to have a thorough knowledge of many DBMS native libraries.
C) ODBC can be used to access data from spreadsheets.
D) ODBC has an object-oriented interface.
E) ODBC does not include facilities to return error messages.

A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q 
According to the ODBC standard, which of the following is not part of the specification of a data source?
A) The associated DBMS
B) The database
C) The driver
D) The operating system
E) The network platform
A

C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q 
The ODBC standard defines a means of doing which of the following?
A) Start transactions
B) Rollback transactions
C) Create a connection
D) Issue SQL commands
E) All of the above
27
Q

Which of the following is a function performed by the driver manager in ODBC?
A) Submit SQL statements to the data source
B) Determine the type of DBMS that processes a given ODBC data source
C) Load the appropriate ODBC driver into memory
D) Convert data source error codes into ODBC error codes
E) B and C

28
Q 
The intermediary between the application and the DBMS drivers in the ODBC architecture is the \_\_\_\_\_\_\_\_.
A) driver manager
B) OLE DB interface
C) ODBC driver
D) data source
E) database connector
29
Q

Which of the following is a task performed by the driver according to the ODBC standard?
A) Determines the appropriate DBMS
B) Validates the format of the ODBC command received from the application
C) Converts data source error codes into ODBC standard error codes
D) Verifies the application to the data source
E) Converts the data source into an SQL-compliant data structure

30
Q 
The \_\_\_\_\_\_\_\_ processes ODBC requests and submits specific SQL statements to a given type of data source.
A) driver manager
B) ADO
C) driver
D) source converter
E) ODBC translator
31
Q 
A data source that is fully SQL-compliant would use what type of DBMS driver?
A) Single-tier
B) Multiple-tier
C) SQL transform
D) Text-based
E) Conformance
32
Q

How does an application determine the level of ODBC conformance available from a driver?
A) The application makes a call to the driver manager.
B) The application makes a call to the data source.
C) The application makes a call to the driver.
D) The developer must determine the level of conformance before the application is written.
E) It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition.

33
Q 
Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver?
A) Level 1 API
B) Extended SQL Grammar
C) Core API
D) Level 2 API
E) Core SQL Grammar
34
Q 
Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?
A) Level 2 API
B) Minimum SQL Grammar
C) Core API
D) Extended SQL Grammar
E) Core SQL Grammar
35
Q

In OLE DB, all of an object’s properties must be exposed in all interfaces, but not all methods have to be exposed.

36
Q

One important result of OLE DB is that data does not have to be moved or converted from one form to another.

37
Q

An OLE DB service provider accepts data from an OLE DB tabular data provider.

38
Q

ADO provides access to ODBC functionality to programming languages that ordinarily could not access ODBC functions.

39
Q

ADO is accessible from languages such as C++ and C#, but not Visual Basic or scripting languages.

40
Q

ADO was (and still is) frequently used for database applications.

41
Q

ADO.NET is a completely new product, with no connection to ADO except the similar name.

42
Q

ADO.NET provides the capability to create and process in-memory databases called DataSets.

43
Q

An ADO.NET DataSet has all the characteristics, features, and functions of a regular database.

44
Q

An ADO.NET DataSet is connected to databases.

45
Q

An ADO.NET dataset can have primary and foreign keys, but ADO.NET does not support referential integrity.

46
Q

Once an ADO.NET dataset is constructed, its contents can be formatted as an XML document with a single command.

47
Q

An ADO.NET dataset can only be used with optimistic locking.

48
Q 
A \_\_\_\_\_\_\_\_ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database.
A) file
B) common
C) shared
D) system
E) user
49
Q 
data source that is local to a single computer and can be used by the operating system and any user on that computer is called a \_\_\_\_\_\_\_\_ data source.
A) file
B) common
C) shared
D) system
E) user
50
Q 
In general, for Web applications it is best to create what type of data source on the Web server?
A) File
B) Common
C) Shared
D) System
E) User
51
Q 
OLE DB breaks the features and functions of a DBMS into what type of objects?
A) COM
B) DBMS
C) MTS
D) ODBC
E) ASP
52
Q

Which of the following is not true about OLE DB?
A) Scripting languages cannot access OLE DB.
B) OLE DB is object-oriented.
C) OLE DB can access ODBC data sources.
D) OLE DB can access non-relational data sources.
E) OLE DB is used as a wrapper for ADO objects.

53
Q 
The characteristics of an object are called \_\_\_\_\_\_\_\_.
A) classes
B) collections
C) methods
D) properties
E) procedures
54
Q 
The actions that an object can perform are called \_\_\_\_\_\_\_\_.
A) classes
B) collections
C) methods
D) properties
E) procedures
55
Q 
An important method of a collection is a(n) \_\_\_\_\_\_\_\_, which can be used to pass through or otherwise identify the items in the collection.
A) iterator
B) identifier
C) converter
D) transformer
E) signal
56
Q 
A set of objects and the properties and methods that they expose are known as a(n) \_\_\_\_\_\_\_\_.
A) provider
B) data consumer
C) implementation
D) instantiation
E) interface
57
Q 
Which of the following is a type of OLE DB data provider?
A) relational data provider
B) method provider
C) sequential data provider
D) tabular data provider
E) implementation provider
58
Q 
Which standard interface in OLE DB is invoked to declare a forward-only cursor?
A) IRowSet
B) IAccessor
C) IColumnsInfo
D) adXact
E) ADODB
59
Q

Which of the following is not true of ADO?
A) ADO is a simple object model for OLE DB data consumers.
B) ADO can be used from VBScript and JavaScript.
C) ADO is harder to understand than OLE DB.
D) ADO can be called from languages such as Visual Basic.NET, Java and C#.
E) All of the above are true of ADO.

60
Q

Which of the following is true about ADO.NET?
A) It is an improved and expanded version of ADO.
B) It facilitates the transformation of XML documents to and from relational database constructs.
C) It provides the ability to create and process in-memory databases.
D) A and B
E) A, B, and C

61
Q 
ADO.NET in-memory databases are called \_\_\_\_\_\_\_\_.
A) adoBases
B) adoDatabases
C) dotNetBases
D) dotNetDatabases
E) DataSets
62
Q 
An ADO.NET Data Provider is a(n) \_\_\_\_\_\_\_\_ that provides ADO.NET services.
A) class library
B) windows application
C) Web application
D) XML service
E) DND service
63
Q

Which of the following is true about ADO.NET DataSets?
A) They can have multiple tables and relationships.
B) They can have foreign keys and surrogate keys.
C) They can support referential integrity actions.
D) A and B
E) A, B, and C

ISE 224 (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions