1. Under the user location. scenario, all record- and file-locking activities are performed at the end- 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 2. A DDBMS is subject to which restriction? A. Multiple instances of the same database should be integrated over a network B. All database processing must be done at a single site C. Rapid ad hoc data access is not possible D. Remote data access is provided on a read-only basis 3. A distributed database administrator. contains the description of the entire database as seen by the

1. Under the user location. scenario, all record- and file-locking activities are performed at the end- 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 2. A DDBMS is subject to which restriction? A. Multiple instances of the same database should be integrated over a network B. All database processing must be done at a single site C. Rapid ad hoc data access is not possible D. Remote data access is provided on a read-only basis 3. A distributed database administrator. contains the description of the entire database as seen by the

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 3PSE

See similar textbooks

Similar questions

Briefly describe the three stages of physical design.Any of these three levels of backups may be used for database recovery management. Is there a purpose to the many levels of backups?
Succinctly describe the three main steps involved in physical design.Any of these three backup levels may be used for database recovery management. What's the point of having several levels of backup?
b-What degree of replication is recommended in the following environment ? High availability is required, transaction can be submitted by any site, and most transactions are retrievals. 2. Availability could be locally tolerated and certain transactions that access particular parts of the database are mostly submitted at a particular site.
Concisely describe the three stages of physical design.Any of these three levels of backups may be used for database recovery management. For what reasons do we create incremental, daily, and nightly backups?
Given the scenario and requirements in Problem 2, answer the following questions:a. What recommendations will you make regarding the type and characteristics of the required database system?b. What type of data fragmentation is needed for each table?c. What criteria must be used to partition each database?d. Design the database fragments. Show an example with node names, location, fragment names, attribute names, and demonstration data.e. What type of distributed database operations must be supported at each remote site?f. What type of distributed database operations must be supported at the headquarters site?
What type of scenario would fall under a siloed database issue in relation to database migration challenges? a.) Having the physical drives get damaged during migration b.) Having data be read by a third party during the transfer c.) Having disparate databases that exist within various parts of the company d.) Having personally identifiable information be acquired
Briefly list and describe each of the three physical design procedures.These three backup levels may be used in any order for database recovery management. What does each backup level serve?
What three alternatives are available for restoring a database? In a summary, what is the purpose of each secondary tier?
Provide a brief description of the three phases of physical design.Any of these three levels of backups may be used for database recovery management. Which levels of backup are there, and what do they do?
Hi Can you please answer the last three parts since the first 3 were answered in the previous request? Given the scenario and requirements in Problem 2, answer the following questions:a. What recommendations will you make regarding the type and characteristics of the required database system?b. What type of data fragmentation is needed for each table?c. What criteria must be used to partition each database?d. Design the database fragments. Show an example with node names, location, fragment names, attribute names, and demonstration data.e. What type of distributed database operations must be supported at each remote site?f. What type of distributed database operations must be supported at the headquarters site?
I need help answering a few HW questions..... a. Name the different types of recovery and discuss the factors that influence when each type of recovery should be performed? b. Name and describe the three types of database failures that may require recovery? c. What is meant by the term log archival, and why is it important to assure recoverability? So I wasnt able to answer them completely, but I was able to answer these partially (Can someone help fill in my answers)?........... Recovery to Current Point-in-Time (PiT) Recovery Transaction Recovery ==================================================================== Instance Failures: Application Failures: Media Failures: ==================================================================== Long Archival indicates.....
List and briefly describe each of the three physical design techniques.For database recovery management, any combination of these three backup tiers may be employed. What serves as a backup at each level of backup?