CSC 105 ch 12 – Flashcards
Unlock all answers in this set
Unlock answersquestion
Which view of data deals with how the data is actually formatted and located?
answer
Physical view
question
A data field represents a(n)
answer
attribute.
question
Collectively, a person's name, address, and age would be called a
answer
record
question
A _____ in different tables can be used to integrate the data in a database.
answer
key field
question
A credit card bill that is processed at one shot - say the end of the month - is an example of
answer
batch processing
question
Having several instances of the same data is called
answer
data redundancy.
question
If Mr. Smith's bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a
answer
lack of data integrity.
question
The data manipulation subsystem can use query-by-example as well as
answer
SQL.
question
The feature of describing the entry field in a data dictionary form as 'text' is characteristic of
answer
data definition subsystem.
question
This type of database is organized into many tables with common data items (key fields) linking the tables to one another.
answer
Relational
question
_____ databases store not only data but also instructions to manipulate the data.
answer
Object-oriented
question
A common operational database is a type of
answer
shared database
question
If all the data in a database is not physically located in one place, it would be a(n)
answer
distributed database
question
Information collected by an organization from a variety of external and internal databases is stored in special type of database called a
answer
data warehouse.
question
The logical view of data focuses on meanings and content of the data.
answer
True
question
A record is a collection of related tables.
answer
False
question
Database tables can be related or connected to other tables by common key fields.
answer
True
question
The ATM works on the principle of real-time processing
answer
True
question
The DBA can create user forms and menus using the
answer
application generation subsystem
question
A nationwide airline reservation system is an example of this type of database model.
answer
Hierarchical model
question
A network database can utilize ____, special connections between nodes that allow multiple connections between records.
answer
pointers
question
In the object-oriented database model, this term is the equivalent to a field in a relational model
answer
Attributes
question
This commercial database offers news and information on legal, public records, and business issues.
answer
LexisNexis
question
Data redundancy results due to lack of data integrity.
answer
False
question
The company database may be stored on a mainframe and managed by a database administrator.
answer
True
