1._____ is the central activity during the parsing phase in query processing.
The correct answer is: Query optimization
2._____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.
The correct answer is: Homogeneous
3._____ fragmentation allows a user to break a single object into two or more segments, or fragments.
The correct answer is: Data
4._____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.
The correct answer is: Network latency
5._____ transparency allows a physically dispersed database to be managed as though it were centralized.
The correct answer is: Distribution
6._____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.
The correct answer is: Location
7.A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.
The correct answer is: fully heterogeneous
8.A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.
The correct answer is: remote request
9.A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.
The correct answer is: distributed
10.A centralized database management is subject to a problem such as _____.
The correct answer is: growing numbers of remote locations
11.A database management system needs _____ to prepare the data for presentation to the end user or to an application program.
The correct answer is: formatting
12._____ refers to the number of different values a column could possibly have.
The correct answer is: Data sparsity
13.A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as _____.
The correct answer is: extents
14.A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.
The correct answer is: file groups
15.A(n) _____ is a logical grouping of several data files that store data with similar characteristics.
The correct answer is: table space
16.Automatic query optimization means that the:
The correct answer is: DBMS finds the most cost-effective access path without user intervention.
17.Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.
The correct answer is: B-tree index
18.During the ____ phase, the DBMS retrieves the data and sends the result set back to the client.
The correct answer is: fetch
19.From the performance point of view, _____ databases eliminate disk access bottlenecks.
The correct answer is: in-memory
20.If there is no index, the DBMS will perform a _____ scan.
The correct answer is: full table
Other Links:
See other websites for quiz:
Check on QUIZLET