Exam (elaborations)
Database Management Systems Midterm Exam Questions & Answers 2024(A+GRADED 100%VERIFIED)
- Course
- Institution
Database Management Systems Midterm Exam Questions & Answers 2024(A+GRADED 100%VERIFIED)
[Show more]
Content preview
D a t a b a s eM a n a g e m e n t
S y s t e m s
M i d t e r m
E x a m
The
two
types
of
T raditional
Database
applications
are______.
-
ANS
Numeric
and
T extual
Databases.
T ypes
of
recent
Database
applications
are_______.
-
ANS
Multimedia,
Geographic
Info
Systems
(GIS),
Biological
and
Genome
Databases,
Data
warehouses,
and
Mobile
Databases.
A
Database
is____.
-
ANS
A
collection
of
related
data.
(known
facts
that
can
be
recorded
and
have
an
implicit
meaning)
A
mini-world
is____.
-
ANS
Some
part
of
the
real
world
about
which
data
is
stored
in
a
database.
For
example,
student
grades
and
transcripts
at
a
university .
A
Database
Management
System
(DBMS)
is____.
-
ANS
A
software
package/
system
to
facilitate
the
creation
and
maintenance
of
a
computerized
database.
A
Database
System
is_____.
-
ANS
The
DBMS
software
together
with
the
data
itself.
Sometimes,
the
applications
are
also
included.
A
T ypical
DBMS
Functionality
is
to___.
-
ANS
1.
Define
a
particular
database
in
terms
of
its
data
types,
structures,
and
constraints.
2.
Construct
or
Load
the initial
database
contents
on
a
secondary
storage
medium.
3.
Manipulating
the
database
by
Retrieval:
Querying,
generating
reports.
Modification:
Insertions,
deletions,
and
updates
to
its
content.
Accessing
the
database
through
W eb
applications.
4.
Processing
and
Sharing
by
a
set
of
concurrent
users
and
application
programs
-
keeping
all
data
valid
and
consistent.
The
main
Characteristics
of
the
Database
approach
are
___.
-
ANS
A
DBMS
catalog
stores
the
description
of
a
particular
database
(EX:
data
structures,
types,
and
constraints).
The
description
is
called
meta-data
(newer
systems
like
NOSQL
do
not
need
meta-data.)
This
allows
the
DBMS
software
to
work
with
different
database
applications.
Program-data
independence_____.
-
ANS
Allows
changing
data
structures
and
storage
organization
without
having
to
change
the
DBMS
access
programs.
Meta-data
is____.
-
ANS
Description
of
data
in
a
database.
Database
users
two
different
types______.
-
ANS
"Actors
on
the
scene"
and
"W orkers
behind
the
scenes."
Actors
on
the
scene
are____.
-
ANS
Those
who
use
and
control
the
database
content,
and
those
who
design,
develop,
and
maintain
database
applications.
(Administrators,
designers,
End-users,
system
analysts/application
developers)
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 carrington. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76658 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now