DBMS – Questions & Answers (Complete And Verified)
1.
In which decade were centralized databases implemented that required that
corporate data be stored in a single central site, usually a mainframe or
midrange computer?
a. 1940s
b. 1960s
c. 1970s
d. 1990s Right Ans - c. 1970s
2.
In recent years the WWW became, in effect, the ____ for distributed data.
a. source
b. impetus
c. repository
d. centralized location Right Ans - c. repository
3.
What is a problem with a centralized database?
a. high cost
b. good performance from remote locations
c. lack of storage
d. poor performance from the main location Right Ans - a. high cost
4.
What feature is a DDBMS disadvantage?
a. data are located near the "greatest demand" site
b. growth facilitation
c. lack of standards
d. reduced operating cost Right Ans - c. lack of standards
5.
What feature is a DDBMS advantage?
a. reduced operating cost
b. complexity of management and control
c. increased training cost
d. increased storage requirements Right Ans - a. reduced operating cost
, 6.
What feature is a DDBMS advantage?
a. greater difficulty in managing the data environment
b. less danger of a single-point failure
c. complexity of management and control
d. increased training cost Right Ans - b. less danger of a single-point failure
7.
The ____ processor is responsible for receiving and processing the
application's data requests.
a. database
b. transaction
c. network
d. data Right Ans - b. transaction
8.
In a distributed database system, a database is composed of several parts
known as database ____.
a. divisors
b. fragments
c. codes
d. schemas Right Ans - b. fragments
9.
The ____ processor is the software component residing on each computer that
stores and retrieves data located at the site.
a. transaction
b. network
c. management
d. data Right Ans - d. data
10.
Under the ____ scenario, multiple processes run on different computers
sharing a single data repository.
a. single-site processing, single-site data
b. multiple-site processing, single-site data
c. multiple-site processing, multiple-site data
d. single-site processing, multiple-site data Right Ans - b. multiple-site
processing, single-site data
1.
In which decade were centralized databases implemented that required that
corporate data be stored in a single central site, usually a mainframe or
midrange computer?
a. 1940s
b. 1960s
c. 1970s
d. 1990s Right Ans - c. 1970s
2.
In recent years the WWW became, in effect, the ____ for distributed data.
a. source
b. impetus
c. repository
d. centralized location Right Ans - c. repository
3.
What is a problem with a centralized database?
a. high cost
b. good performance from remote locations
c. lack of storage
d. poor performance from the main location Right Ans - a. high cost
4.
What feature is a DDBMS disadvantage?
a. data are located near the "greatest demand" site
b. growth facilitation
c. lack of standards
d. reduced operating cost Right Ans - c. lack of standards
5.
What feature is a DDBMS advantage?
a. reduced operating cost
b. complexity of management and control
c. increased training cost
d. increased storage requirements Right Ans - a. reduced operating cost
, 6.
What feature is a DDBMS advantage?
a. greater difficulty in managing the data environment
b. less danger of a single-point failure
c. complexity of management and control
d. increased training cost Right Ans - b. less danger of a single-point failure
7.
The ____ processor is responsible for receiving and processing the
application's data requests.
a. database
b. transaction
c. network
d. data Right Ans - b. transaction
8.
In a distributed database system, a database is composed of several parts
known as database ____.
a. divisors
b. fragments
c. codes
d. schemas Right Ans - b. fragments
9.
The ____ processor is the software component residing on each computer that
stores and retrieves data located at the site.
a. transaction
b. network
c. management
d. data Right Ans - d. data
10.
Under the ____ scenario, multiple processes run on different computers
sharing a single data repository.
a. single-site processing, single-site data
b. multiple-site processing, single-site data
c. multiple-site processing, multiple-site data
d. single-site processing, multiple-site data Right Ans - b. multiple-site
processing, single-site data
