INF2603 Ch1 – The Database Approach – True / False – Flashcards
Unlock all answers in this set
Unlock answersquestion
Data and information are essentially the same thing.
answer
False. Data is raw fact. Information is processed data.
question
Data processing can be as simple as organizing data to reveal patterns.
answer
True
question
We are now said to be entering the "knowledge age."
answer
True
question
Information implies familiarity, awareness, and understanding knowledge as it applies to an environment.
answer
False KNOWLEDGE implies familiarity, awareness and understanding of INFORMATION as it applies to an environment.
question
Data constitute the building blocks of information.
answer
True
question
Metadata present a more complete picture of the data in the database than the data itself.
answer
True
question
The only way to access the data in a database is through the DBMS.
answer
True
question
Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests.
answer
False
question
The DBMS reveals much of the database's internal complexity to the application programs and users.
answer
False
question
One disadvantage of the DBMS is that it increases the risk of data security breaches.
answer
False The DBMS DECREASES the security risk.
question
An operational database is sometimes referred to as an enterprise database.
answer
False operational / OLTP / transactional / production database enterprise database refer to size - used by entire organisation, support many users
question
A data warehouse can store data derived from many sources.
answer
True
question
The same data might be simultaneously structured and unstructured depending on the intended processing.
answer
True
question
Corporations use only structured data.
answer
False Unstructured data is used to produce structured data. Both types are used.
question
Historically, a manual file system was composed of a system of file folders and filing cabinets.
answer
True
question
Initially the files within a computer file system were similar to manual files.
answer
True
question
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 Structural INDEPENDENCE exists when you can change the file structure without affecting the application's ability to access the data.
question
A query language is a procedural language.
answer
False A query language is a NON-PROCEDURAL language (user specifies WHAT without having to specify HOW).
question
One disadvantage of a database system over previous data management approaches is increased costs.
answer
True
question
One advantage of a database system over previous data management approaches is that the database system is considerably less complex.
answer
False Advantages: improved data sharing, data security, data integration improved data access, decision making, end-user productivity minimised data inconsistency
