100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
AIS 2024 Exam 2 Questions & Answers 100% CORRECT CA$13.62   Add to cart
Quickly navigate to
Preview
  2.  
  3. AIS 2024
  4.  
  5. AIS 2024

Exam (elaborations)

AIS 2024 Exam 2 Questions & Answers 100% CORRECT
 8 views  0 purchase
  • Course
  • AIS 2024
  • Institution
  • AIS 2024

AIS 2024 Exam 2 Questions & Answers 100% CORRECT Define a database. - ANSWERSan organized collection of data, typically stored electronically; allows us to avoid replication of data List and describe the two general data management approaches. - ANSWERS1. flat-file model: no structured rela...

[Show more]

Preview 3 out of 17  pages

Document information

  • August 10, 2024
  • 17
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • ais 2024 exam 2 questions answers 100 correct

Written for

  • AIS 2024
  • AIS 2024

Seller

avatar-seller
Bensuda

Reviews received

Content preview

AIS 2024 Exam 2 Questions & Answers
100% CORRECT

Define a database. - ANSWERSan organized collection of data, typically stored electronically; allows us to
avoid replication of data



List and describe the two general data management approaches. - ANSWERS1. flat-file model: no
structured relationships to other files; primarily in older systems

2. database model: access to the data resource is controlled by a database management system;
centralizes the organization's data into a common database that is shared by the user community



What are the primary elements of a database? List and explain the role of each. - ANSWERS1. Users:
individuals within the organization who access the data in the database (access through a program or by
direct query)

2. Database management system: set of programs that controls access to the database and manages the
data resource through program development, backup and recovery functions, usage reporting, and
access authorization

3. Database administrator: a function that manages database resources through planning, design,
implementation, operation and maintenance, growth and change.

4. Physical database: magnetic spots on the magnetic media



What are two types of distributed database? Describe each and their advantages. - ANSWERS1.
Partitioned: splits central database into segments (partitions) distributed to their primary users

Advantages:

-users' control increased by having data stored at local sites

-improved transaction processing response time

-reduces potential data loss from a disaster

-volume of transmitted data between IT units is reduced

2. Replicated: common data replicated at each site, reducing data traffic between sites

Advantages:

,-effective for situations with a high degree of data sharing, but no primary user

-primary justification to support read-only queries



What types of issues do we start to have when we have redundant information? - ANSWERS-Data
storage: commonly used data duplicated multiple times with organization

-Data updating: changes must be made separately for each user/risk of having outdated information

-Inconsistent data: data being different across firm due to disorganization

-Task-data dependency: users cannot obtain additional information as needs change



What are two tests that would help prevent unauthorized individuals from viewing, retrieving, or
corrupting or destroying data? - ANSWERS1. Evaluate biometric devices, such as fingerprint or retina
prints that control access to the database.

2. Compare job description so the database authorization table, which contains rules that limit user
actions.



Describe an environment where the partitioned database makes sense. - ANSWERSorganization that
requires little to no data sharing



Describe a database lockout, generally and in the context of each distributed environment. -
ANSWERSDatabase lockouts allow us to keep data up to date, prevent multiple simultaneous access to
data perverting potential corruption; ensures data currency



In a central database:

-allows us to keep data current without causing loss of access due to updates

-IPUs: information processing units; when the first IPU requests access to a certain data location, no
other IPU can have access to it until the first one is finished.



In a partitioned database:

-deadlock situation: where multiple processing units have asked to access information at one time; locks
everything up so no one can do anything with it until someone outside/in administration approves
access one at a time

, In a replicated database:

-How to edit data that is replicated in several different places:

*Concurrency control: used to make sure that when data is updated in one replicated set, it is updated in
all other locations (i.e., time-stamping)



List and describe the three views of a database. - ANSWERS1. Unique internal view: physical
arrangement of records which describes the structure of the data records, the linkages between the files,
and the physical arrangement and sequence of records in the files

2. Unique conceptual view (schema): represents how the database looks both abstractly and logically

3. Many user view (sub-schema): what the individual users are allowed to see



Databases make it easy to share information, but easy sharing of information also increases risk. List and
describe the access control features that help to compensate for this risk. - ANSWERS1. User view: limits
what a particular user is able to see.

2. Database authorization table: limits what a particular user can do.

3. User-defined procedure: allows user to create a personal security program or routine to provide more
positive user identification than a single password ("fence" around data)

4. Data encryption: data kept scrambled so someone breaking into system can't read it; used to protect
highly sensitive stored data (i.e., product formulas, personnel pay rates, password files, and certain
financial data)



Databases can either be __________ or __________. Fill in the blanks and describe each. -
ANSWERSCentralized: everything is in one central location; requests sent from remote locations to
central site to gain access

Distributed: uses partitioned (splits central database into segments distributed to their primary users) or
replicated systems (common data replicated at each site, reducing data traffic between sites)



What are the services that a database management system provides? - ANSWERS-backup and recovery

-program development

-database us age

-database access

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller Bensuda. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for CA$13.62. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

79271 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
CA$13.62
  • (0)
  Add to cart