100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
BCIS 4620 DATABASE EXAM 1 Questions and Answers graded A+ $12.49   Add to cart

Exam (elaborations)

BCIS 4620 DATABASE EXAM 1 Questions and Answers graded A+

 9 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...

[Show more]

Preview 3 out of 19  pages

  • August 3, 2024
  • 19
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • Bcia
  • Bcia
avatar-seller
Pogba119
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

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 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.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67096 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
$12.49
  • (0)
  Add to cart