CISC 215 : Database Design And Application Development! Trivia Questions Quiz

28 Questions | By Connorn | Updated: Mar 21, 2022 | Attempts: 622

Questions

Settings

CISC 215 : Database Design And Application Development! Trivia Questions Quiz - Quiz

Are you looking for a CISC 215: database design and application development trivia questions quiz? If you are practicing for your CISC exam, the best way to see if you are well prepared is to test yourself regularly, and one way to do so is to take the quiz below. How about you give it a try and see how well you will do!

Questions and Answers

1.

Centralized database management is subject to a problem such as
- A.
  
  A growing number of remote locations
- B.
  
  Maintaining and operating small database systems
- C.
  
  Dependence on multiple sites
- D.
  
  Organizational flexibility of the database
2.

A disadvantage of a distributed database management system (DDBMS) is that:
- A.
  
  There are lack of standards
- B.
  
  It is slower in terms of data access
- C.
  
  Adding new sites affects other sites' operations
- D.
  
  It is processor dependent.
3.

A distributed database is composed of several parts known as database
- A.
  
  Sections
- B.
  
  Fragments
- C.
  
  Partitions
- D.
  
  Parts
4.

Distributed processing does not require:
- A.
  
  Database processing functions to be distributed to all data storage sites
- B.
  
  An existing distributed database
- C.
  
  A network of interconnected components
- D.
  
  Multiple sites to share processing chores
5.

Under the _____ scenario, all record and file-locking activities are performed at the end-user location.
- A.
  
  Single-site processing, single-site data
- B.
  
  Multiple-site processing, single-site data
- C.
  
  Single-site processing, multiple-site data
- D.
  
  Multiple-site processing, multiple-site data
6.

________ transparency allows a physically dispersed database to be managed as though it were centralized.
- A.
  
  Distribution
- B.
  
  Transaction
- C.
  
  Failure
- D.
  
  Performance
7.

________ transparency is the highest level of transparency. The end-user or programmer does not need to know that a database is partitioned.
- A.
  
  Performance
- B.
  
  Fragmentation
- C.
  
  Location
- D.
  
  Local mapping
8.

A _______ lets a single SQL statement access the data that are to be processed by a single remote database processor.
- A.
  
  Remote request
- B.
  
  Remote transaction
- C.
  
  Distributed request
- D.
  
  Distributed transaction
9.

________ is the delay imposed by the amount of time required for a data packet to make around trip from point A to point B.
- A.
  
  Data distribution
- B.
  
  Replica transparency
- C.
  
  Network Latency
- D.
  
  Network Partitioning
10.

A(n) ________ database stores each database fragment at a single site.
- A.
  
  Partially replicated
- B.
  
  Unreplicated
- C.
  
  Fully replicated
- D.
  
  Partitioned
11.

A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems.
- A.
  
  True
- B.
  
  False
12.

Distributed data access was needed to support geographically dispersed business units.
- A.
  
  True
- B.
  
  False
13.

Rapid ad hoc data became unnecessary in the quick-response decision-making environment.
- A.
  
  True
- B.
  
  False
14.

The Internet is the repository for distributed data.
- A.
  
  True
- B.
  
  False
15.

Current distributed database management system (DDBMS) are subject to some problems, such as the complexity of management and control
- A.
  
  True
- B.
  
  False
16.

Distributed processing shares a database's logical processing among two or more physically independent sites that are connected through a network.
- A.
  
  True
- B.
  
  False
17.

One of the advantages of a distributed database management system (DDBMS) is that the data is located near the site with the least demand.
- A.
  
  True
- B.
  
  False
18.

One of the advantages of a distributed database management system (DDBMS) is growth facilitation.
- A.
  
  True
- B.
  
  False
19.

One of the advantages of a distributed database management system (DDBMS) is security.
- A.
  
  True
- B.
  
  False
20.

Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.
- A.
  
  True
- B.
  
  False
21.

In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
- A.
  
  True
- B.
  
  False
22.

A database management system (DBMS) must have validation, transformation, and mapping functions, as well as other functions, in order to be classified as distributed.
- A.
  
  True
- B.
  
  False
23.

A fully distributed database management system (DBMS) must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.
- A.
  
  True
- B.
  
  False
24.

The transaction processor (TP) is the software component found in each computer that requests data.
- A.
  
  True
- B.
  
  False
25.

A distributed database management system (DDBMS) must be communications-media-dependent.
- A.
  
  True
- B.
  
  False