ISA 245 Exam 1 With 100% Correct And
Verified Answers
Before the advent of database systems, most business
software used _____________ systems.
file-based
floppy disk
RAID
NoSQL - Correct Answer-file-based
In file-based systems, new applications are added
_____________________.
in a top-down manner guided by the IT steering committee
after careful consideration of the enterprise architecture
when the need arises as expressed by departmental users
when they can fit on the mainframe - Correct Answer-when
the need arises as expressed by departmental users
Which of the following is a security problem associated with
file-based systems?
silos
access privilege costraints
data isolation
lack of available encryption - Correct Answer-access
privilege costraints
Vendarsol
,Which of the following is a problem that often results from
data redundancy?
isolation
concurrency
file locks
inconsistency - Correct Answer-inconsistency
If data are incorrect or inconsistent, this is referred to as
a(n) ______________ problem.
concurrency
integrity
isolation
application-specific - Correct Answer-Integrity
Which of the following is an example of data storage?
An Excel spreadsheet
An Oracle database
All of these choices
A sign-in sheet - Correct Answer-all of these choices
Which of the following is an example of database
management software?
All of these choices
Excel
Oracle
Word - Correct Answer-Oracle
A DBMS is:
application software that meets the needs of
a specific business process
a collection of programs that helps users
create and maintain a database
a database system used for project and line
management
a repository for metadata - Correct Answer-a
collection of programs that helps users create
and maintain a database
The data element "Employee Name" would
most likely be represented as _______________ in
a database.
a record
a field
a table
metadata - Correct Answer-a field
Which of the following is NOT an example of
the processing power of a database?
Vendarsol
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 Vendarsol. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.