BCIS 4620 DATABASE EXAM 1 Questions and Answers graded A+
7 views 0 purchase
Course
Bcia
Institution
Bcia
BCIS 4620 DATABASE EXAM 1 Questions and Answers graded A+
_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.
Performance tuning
A desktop database is a _____ database
single-user
_____ exists when diffe...
BCIS 4620 DATABASE EXAM 1
Questions and Answers graded A+
_____ relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. - answer Performance tuning
A desktop database is a _____ database - answer single-user
_____ exists when different versions of the same data appear in different places. -
answer Data inconsistency
The response of the DBMS to a query is the ___________ - answer query result set
Database programming languages receive all application requests and translate them
into the complex operations required to fulfill those requests - answer False
A(n) _____ database supports a relatively small number of users (usually fewer than
50) or a specific department within an organization. - answer workgroup
Data is said to be verifiable if: - answer the data always yields consistent results.
_____ serve as the intermediary between the user and the database. - answer
DBMSs
An operational database is sometimes referred to as an enterprise database. - answer
False
When data are entered into a form and saved, they are placed in the underlying
database as knowledge. - answer False
Data anomaly is defined as the condition in which all of the data in the database are
consistent with the real-world events and conditions. - answer False
The organization of data within folders in a manual file system is determined by
_______. - answer its expected use
Data is the result of processing raw facts to reveal its meaning. - answer False
End-user data is _____. - answer raw facts of interest to the end user
_____ data exist in a format that does not lend itself to processing that yields
information. - answer Unstructured
,A workgroup database is a(n) _____ database. - answer multiuser
Which of the following is true of spreadsheet applications? - answer They enhance
the user's ability to understand the data.
Structure is based on the type of processing to be performed on the data. - answer
True
Structural dependence exists when it is possible to make changes in the file structure
without affecting the application program's ability to access the data. - answer False
A data warehouse contains historical data obtained from the _____. - answer
operational databases
A data warehouse can store data derived from many sources. - answer True
_____ is the result of revealing the meaning of raw facts. - answer Information
One disadvantage of a database system over previous data management approaches
is increased costs. - answer True
Field refers to a collection of related records. - answer False
A _____ is a collection of related records. - answer file
_____ provide a description of the data characteristics and the set of relationships that
link the data found within the database. - answer Metadata
_____ data exist in the format in which they were collected. - answer Unstructured
Corporations use only structured data. - answer False
The term _____ refers to an organization of components that define and regulate the
collection, storage, management and use of data within a database environment. -
answer database system
Which of the following refers to the situation where different versions of the same data
are stored at different places because they weren't updated consistently? - answer
Data redundancy
An advantage of database systems is that you needn't perform frequent updates and
apply latest patches. - answer False
The database structure in a DBMS is stored as a _____. - answer collection of files
, Data processing can be as simple as organizing data to reveal patterns. - answer
True
Data constitute the building blocks of information. - answer True
Data and information are essentially the same thing. - answer False
A _____ is a character or group of characters that has a specific meaning. - answer
field
_____ are the result of formatting disorganized data in order to facilitate storage, use
and generation of information. - answer Structured data
_____ is defined as the condition in which all of the data in the database are consistent
with the real-world events and conditions. - answer Data integrity
One disadvantage of the DBMS is that it increases the risk of data security breaches. -
answer False
The DBMS reveals much of the database's internal complexity to the application
programs and users. - answer False
One advantage of a database system over previous data management approaches is
that the database system is considerably less complex. - answer False
_____ is the body of information and facts about a specific subject. - answer
Knowledge
An XML database supports the storage and management of _____ XML data. - answer
semistructured
Most data that can be encountered are best classified as _____. - answer
semistructured
A _____ is a logically connected set of one or more fields that describes a person,
place, or thing. - answer record
Metadata describe the data characteristics and the set of relationships that links the
data found within the database. - answer True
A(n) _____ might be written by a programmer or it might be created through a DBMS
utility program. - answer application
Accurate, relevant, and timely information is the key to ____. - answer good decision
making
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 Pogba119. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
