What client/server database and distributed database have in common is that in both cases the databases can be located other than “in the computer itself.”

Quiz 2 Instructions
Question 1
What client/server database and distributed database have in common is that in both cases the databases can be located other than “in the computer itself.”

True

False
Question 2
In a two-tiered client/server arrangement, data can be found on each PC’s hard drive and data can be in a database at the server.

True

False
Question 3
In the database server approach to client/server database, the actual database processing is done at the server.

True

False
Question 4
One use of the term three-tier approach to client/server database is that data sought from one of the client PCs can be on any one of a succession of three other PCs on the LAN.

True

False
Question 5
When data is distributed in a distributed database arrangement, the database is no longer considered to be a single, logical database.

True

False
Question 6
A distributed database management system manages the distributed data as a single, logical database.

True

False
Question 7
In a network environment, a centralized database provides local autonomy over the data.

True

False
Question 8
Distributed data with no replication provides a high degree of availability.

True

False
Question 9
The two-phase commit process is used for asynchronous updating of replicated data.

True

False
Question 10
In the prepare phase of the two-phase commit process, the updated data is written to a log at each site but not to the database at each site.

True

False

Question 11
Decision support systems are designed to make decisions for managers.

True

False
Question 12
Data warehouse data is characterized as subject oriented.

True

False
Question 13
Data warehouse data is less problematic if denormalized than operational data would be.

True

False
Question 14
Due to the nature of DSS applications, data warehouse data must be up-to-the-moment current.

True

False
Question 15
A data mart is a small-scale data warehouse that is designed to support a small part of an organization, say a department or a related group of departments.

True

False
Question 16
Data warehouses are often referred to as multidimensional databases because each occurrence of the subject is referenced by an occurrence of each of several dimensions or characteristics of the subject.

True

False
Question 17
The star schema approach to multidimensional data design is incompatible with relational database structures.

True

False
Question 18
A star schema has a “fact table,” which represents the data warehouse “subject”.

True

False
Question 19
Data enrichment is the process of copying the data from the transactional databases in preparation for loading it into the data warehouse.

True

False
Question 20
Data cleaning or cleansing or scrubbing refers to fixing errors in data as it is being loaded into the operational database.

True

False
Question 21
All of the following are true about a two-tiered client/server LAN, except ____.

a gateway computer can link the LAN to other LANs or to the Internet

data can reside on a client PC’s hard drive or at the server

searching for data is location transparent

a printer on the LAN is available to all of the client PCs

data transparency can extend to a mainframe external to the LAN
Question 22
Compared to the file server approach, the database server approach to client/server database _____.

generates more network data traffic

requires more processing power at the server

requires a gateway connection to a mainframe computer

spreads security control through all of the client PCs

requires “fatter” client PCs with more processing power

Question 23
Consider a distributed relational database in which there is no data replication. All of the following are true, except ____.

all of the table on the network is still available even if one site that has some tables goes down

every table can be placed at the site at which it is most heavily used

if one site goes down then the data at that site cannot be accessed there or anywhere else on the network

the integration of two tables that are not located at the same site will require a distributed join

if one site goes down at least some of the database’s tables will still be accessible
Question 24
If a distributed database network with data replication has one node that has a copy of every table in the database ____.

the problem of data concurrency is eliminated

the issue of one site becoming a bottleneck is eliminated

the problem of data security is eliminated

at least one other copy of each table must also be stored elsewhere on the network

the problem of distributed joins is eliminated
Question 25
If all went well during the prepare phase of the two-phase commit, then during the commit phase ____.

only the site issuing the update request writes the update to its database

all of the involved sites write the update to their logs

all of the involved sites write the update to their databases

all of the sites except the site issuing the update request write the update to their logs

all of the sites except the site issuing the update request write the update to their databases
Question 26
Of the following applications or application systems, the one that would be considered a decision support system is ____.

a system that links companies in a supply chain

a hospital application that makes patient records available to all doctors and other health care professionals who are treating patients

a university course and grade record keeping system

a system that provides the management of a retail chain with data helpful in choosing sites for new stores

a payroll system
Question 27
Data in a typical data warehouse ____.

is frequently updated by changing existing attribute values as the values change in the operational database

grows as new data is appended to the end of the existing tables

does not require timestamps

is always fully detailed, not summarized data

is organized according to the company’s TPS applications

Question 28
An enterprise data warehouse (EDW) ____.

must be the sum of all of a company’s data marts

is designed to support a department or a related group of departments

cannot exist without data marts being present

must be fully normalized

supports an entire company or a major part of one
Question 29
There is a(n) _____ relationship between each dimension table entity and the fact table entity in a star schema data warehouse structure.

standard

structured

unstructured

many-to-many

one-to-many
Question 30
____ is a decision support methodology based on viewing data in multiple dimensions.

Data mining

Market basket analysis

Neural networks

Online analytic processing

Data transformation

Question 31
Australian Boomerang, Ltd., wants to design a distributed relational database. The company is headquartered in Perth and has major operations in Sydney, Melbourne, and Darwin. The database involved consists of five tables, labeled A, B, C, D, and E, with the following characteristics:

Table A consists of 500,000 records and is heavily used in Perth and Sydney.
Table B consists of 100,000 records and is frequently required in all four cities.
Table C consists of 800 records and is frequently required in all four cities.
Table D consists of 75,000 records. Records 1-30,000 are most frequently used in Sydney. Records 30,001-75,000 are most frequently used in Melbourne.
Table E consists of 20,000 records and is used almost exclusively in Perth.

Design a distributed relational database for Australian Boomerang. Justify your placement, replication, and partitioning of the tables. (Please answer in complete sentences; do not submit any diagrams. This is a question about the architecture of how the distributed database is set up, balancing costs versus reliability, not how to design the schema.)

Question 32
This question is from Chapter 13, question 2(a), page 364. Refer to the database schema on pages 363-364 to use in answering this question.

Design a multidimensional database using a star schema for a data warehouse for the Best Airlines, Inc., airplane maintenance environment described by the database schema. The main subject will be maintenance event, starting with the fact table EVENT. Complete the rest of the design, including snowflake tables as appropriate. Use the Dropbox for Quiz 2: Q32 to submit a diagram or a text-based schema representation is also acceptable. Using the ERD design tool in MySQL Workbench, if you have it, is an appropriate tool for this assignment. (Hint: see Fig 13.9, p 350 for an example of a star schema design)

Screenshot_2015-11-19_12.51.58

Screenshot_2015-11-19_12.52.06

Screenshot_2015-11-19_12.52.10

---

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH LITE ESSAYS TODAY AND GET AN AMAZING DISCOUNT

The post What client/server database and distributed database have in common is that in both cases the databases can be located other than “in the computer itself.” appeared first on Cheapest Academic Custom Papers.