INFS Visualizing Technology Ch.11

What ensures a person doesn't misspell a word in a field? A) Lookup lists B) Find Feature C) Master D) Inference

A) Lookup lists

Which is NOT a CODIS index? A) Arrestee B) Forensic C) Missing Persons D) Victims

D) Victims

What is a database a collection of? A) Spreadsheets B) Files C) Information D) Data

C) Information

What type of database allows data to be stored in data cubes? A) Multidimensional B) Relational C) Hierarchical D) Flat

A) Multidimensional

What are titles, authors, publication dates and ISBN numbers examples of in a database? A) Records B) Fields C) Tables D) Queries

A) Records

What can be used to print data or display it in an easy way to read? A) Report B) Table C) Record D) Form

A) Report

What improves over time by learning from its interactions? A) Difference Engine B) Cognitive Computing System C) Decision Support System D) Inference Engine

B) Cognitive Computing System

What type of database is an Excel spreadsheet an example of? A) Object-Oriented B) Flat C) Relational D) Hierarchical

B) Flat

What is Microsoft Office an example of? A) Geographic Information System (GIS) B) Office Support System (OSS) C) Transaction-Processing System (TPS) D) Structured Query Language (SQL)

B) Office Support System (OSS)

What do two tables use to link two records in a one-to-one relationship? A) Query B) Primary Key C) Foreign Key D) Form

B) Primary Key

What type of database is popular among businesses? A) Hierarchical B) Relational C) Multidimensional D) Flat

B) Relational

Which would make the best primary key in a table? A) Last name B) Social Security number C) First name D) Street Address

B) Social Security number

What data rule would prevent users from entering text in a date-time format? A) Manipulation B) Validation C) Monitoring D) Redundancy

B) Validation

What is an expert system programmed to do? A) use SQL statements to respond to requests B) make decisions in real-life situations C) search the web for experts D) present possible decision outcomes

B) make decisions in real-life situations

What is the test a transaction processing system uses to make sure transactions are fully completed? A) Consistency B) Isolation C) Atomicity D) Durability

C) Atomicity

What is the application of information technology used in the field of biology? A) Biofeedback B) Biocoenosis C) Bioinformatics D) Bioengineering

C) Bioinformatics

What makes a data entry easier to match layouts of paper? A) Reports B) Records C) Forms D) Queries

C) Forms

What allows users to selectively extract data from different viewpoints? A) An office support system (OSS) B) A transaction-processing system (TPS) C) Online analytical processing (OLAP) D) A decision support system (DSS)

C) Online analytical processing (OLAP)

What project was coordinated by the U.S. Department of Energy and the National Institutes of Health? A) ARPANET B) Integrated Automated Fingerprint Identification System C) Combined DNA Index System D) Human Genome Project

D) Human Genome Project

Which is a type of data that can be stored in an object-oriented database? A) Documents and spreadsheets B) Documents C) Spreadsheets D) Images, audio, and video

D) Images, audio, and video

Which is NOT an advantage of data normalization? A) Makes it easier to update records B) Increases query speed C) Reduces the database size D) Increases database development time

D) Increases database development time

What is a set of rules used to apply a knowledge base to each situation? A) Difference Engine B) Cognitive Computing System C) Decision Support System D) Inference Engine

D) Inference Engine

What is another name for the datasets that GIS made up of? A) Sets B) Information C) Datacaches D) Layers

D) Layers

What type of database does the science and telecommunication industry use? A) Multidimensional B) Relational C) Flat D) Object-Oriented

D) Object-Oriented

What relationship occurs when each vehicle record links several repair records, but each repair can only link to one vehicle? A) Simple Query B) Many-To-Many C) One-To-One D) One-To-Many

D) One-To-Many

What can GIS be used for by local municipalities? A) capture criminals B) budget for waste management facilities C) warn citizens of weather-related events D) design emergency routes

D) design emergency routes

Which is NOT a SQL relational keyword? A) WHERE B) QUIT C) FROM D) SELECT

B) QUIT

What stores data in rows and columns in a database? A) Field B) Table C) Cell D) Matrix

B) Table

What could be used to retrieve all of the phone numbers from a student release form? A) Table B) Report C) Query D) Form

C) Query