Exam (elaborations)
DBMS 110 – Questions & Correct Solutions (100%)
- Course
- Institution
DBMS 110 – Questions & Correct Solutions (100%)
[Show more]
Content preview
DBMS 110 – Questions & Correct Solutions (100%)Defines and describes the data and relationships between tables in the
database. Right Ans - Metadata
Facts that represent real-world information. Right Ans - Data Elements
The ability to read a file but not make changes. Right Ans - Read-Only
Access
Represents data as record types. Right Ans - Network Model
A database system is referred to as self-describing because it not only
contains the database itself, but also metadata which defines and describes
the data and relationships between tables in the database. Right Ans - Self-
Describing
A shared collection of related data used to support the activities of a particular
organization. Right Ans - Database
Determines the sort of data permitted in a field, for example numbers only.
Right Ans - Data Type
A situation where various copies of the same data are conflicting. Right Ans
- Data Inconsistency
Allows the management of large amounts of organizational information.
Right Ans - Database Approach
A powerful software tool that allows you to store, manipulate and retrieve
data in a variety of ways. Right Ans - Database Management Software
A combination of fields. Right Ans - Table
Another term for table. Right Ans - Relation
Features of a database that allow several users access to the same data item at
the same time Right Ans - concurrency control strategies
, Refers to the maintenance and assurance that the data in a database are
correct and consistent. Right Ans - Data Integrity
The ability to both read and modify a file. Right Ans - Read and Write
Privilege
A database management system which supports multiple users concurrently
is called? Right Ans - multiuser database system
The DBMS and database are stored at a single site that is used by several other
systems too access is what kind of database system? Right Ans -
Centralized Database System
A data block is the ____ storage unit of a database. Right Ans - smallest
logical
The actual database and the DBMS software are distributed from various sites
that are connected by a computer network is called? Right Ans -
In the early 1980s, many Canadian libraries used the _____ to convert their
manual card catalogues to machine-readable centralized catalogue systems.
Right Ans - GEAC 8000
What is an example of an object-oriented DBMS? Right Ans -
An _____ is a logical unit of database storage space allocation made up of
contiguous data blocks. Right Ans - Extent
The type of data models that preceded the relational model. Right Ans -
A database management system in which information is represented in the
form of objects as used in object-oriented programming is called? Right
Ans - object-oriented data model
The database ______ is a small binary file associated with only one database.
Right Ans - Control File
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 LeCrae. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
76799 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now