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