INF503 Week 6 Quize's

Started on	Sunday, February 20, 2022, 11:05 PM
State	Finished
Completed on	Sunday, February 20, 2022, 11:14 PM
Time taken	9 mins 2 secs
Grade	19.00 out of 20.00 (95%)

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the central activity during the parsing phase in query processing.

Select one:

Partitioning

Clustering

Query optimization

Correct

Query validation

Feedback

The correct answer is: Query optimization

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

_____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.

Select one:

Combination

Homogeneous

Correct

Heterogeneous

Fully heterogeneous

Feedback

The correct answer is: Homogeneous

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

_____ fragmentation allows a user to break a single object into two or more segments, or fragments.

Select one:

Horizontal

Request

Data

Correct

Vertical

Feedback

The correct answer is: Data

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

_____ 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.

Select one:

Data distribution

Network partitioning

Network latency

Correct

Replica transparency

Feedback

The correct answer is: Network latency

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

_____ transparency allows a physically dispersed database to be managed as though it were centralized.

Select one:

Transaction

Performance

Distribution

Correct

Failure

Feedback

The correct answer is: Distribution

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

_____ 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.

Select one:

Local mapping

Fragmentation

Transaction

Location

Correct

Feedback

The correct answer is: Location

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Select one:

fully homogeneous

homogeneous

fully heterogeneous

Correct

heterogeneous

Feedback

The correct answer is: fully heterogeneous

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.

Select one:

remote transaction

remote request

Correct

distributed request

distributed transaction

Feedback

The correct answer is: remote request

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.

Select one:

fragmented

distributed

Correct

transaction

remote

Feedback

The correct answer is: distributed

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

A centralized database management is subject to a problem such as _____.

Select one:

dependence on multiple sites

growing numbers of remote locations

Correct

organizational flexibility of the database

maintaining and operating small database systems

Feedback

The correct answer is: growing numbers of remote locations

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.

Select one:

concurrency control

I/O interface

security

formatting

Correct

Feedback

The correct answer is: formatting

Question 12

Incorrect

0.00 points out of 1.00

Flag question

Question text

_____ refers to the number of different values a column could possibly have.

Select one:

Clustering

Database statistics

Incorrect

Bitmap index

Data sparsity

Feedback

The correct answer is: Data sparsity

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

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 _____.

Select one:

procedure cache

buffer cache

extents

Correct

supplements

Feedback

The correct answer is: extents

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.

Select one:

data caches

operation modes

file groups

Correct

procedure caches

Feedback

The correct answer is: file groups

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is a logical grouping of several data files that store data with similar characteristics.

Select one:

procedure cache

table space

Correct

data cache

listener

Feedback

The correct answer is: table space

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

Automatic query optimization means that the:

Select one:

optimization process is scheduled and selected by the end user or programmer.

database access strategy is defined when the program is executed.

DBMS finds the most cost-effective access path without user intervention.

Correct

optimization takes place at compilation time by the programmer.

Feedback

The correct answer is: DBMS finds the most cost-effective access path without user intervention.

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.

Select one:

reverse index

hash index

sparse index

B-tree index

Correct

Feedback

The correct answer is: B-tree index

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

During the ____ phase, the DBMS retrieves the data and sends the result set back to the client.

Select one:

parse

execute

fetch

Correct

process

Feedback

The correct answer is: fetch

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

From the performance point of view, _____ databases eliminate disk access bottlenecks.

Select one:

distributed

index-organized

RAID

in-memory

Correct

Feedback

The correct answer is: in-memory

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

If there is no index, the DBMS will perform a _____ scan.

Select one:

range

full table

Correct

row ID table access

loop

Feedback

The correct answer is: full table

Finish review

US-India Student Support Services