Ch 11

Question 1

what uniquely identifies a record in a database table

Answer 1

primary key

Question 2

what retrieves specific date from one or more tables to answer a question

Answer 2

queries

Question 3

which is used to create databases that have more complicated types of data, such as images, audio, and video

Answer 3

object oriented databases

Question 4

which is the process of discovering relationships between data items

Answer 4

data mining

Question 5

what is a decentralized electronic database of digital currency transactions

Answer 5

blockchain

Question 6

a DBMS uses what to create a query

Answer 6

SQL- structured query language

Question 7

collectively, applications that are used to analyze data in info systems, so it can be used to make decisions, are called

Answer 7

business intelligence tools (BI)

Question 8

what is the branch of science concerned with making computers behave like humans

Answer 8

artificial intelligence AI

Question 9

what is a part of an expert system that contains expert info and accumulated experience in a particular field

Answer 9

knowledge base

Question 10

a ____ layers datasets that may include maps, imagery, and tablesq

Answer 10

GIS - geographical info system

Question 11

what are the 8 primary levels of the National Map

Answer 11

1) aerial photos
2) elevation
3) geographic names
4) hydrography
5) boundaries
6) transportation
7) structures
8) land cover

Question 12

what is layers or datasets of geographically referenced info about Earth’s surgace

Answer 12

GIS - geographically info system

Question 13

in a GIS each layer holds

Answer 13

data about a particular kind of feature

Question 14

identify 3-4 goals of the Human Genome Project

Answer 14

identify all the 20,000- 25,000 genes in human DNA
determine the sequences of 3 billion chemical base pairs that compose human DNA
store this info in databases
improves tools for data analysis
transfers related technologies to the private sector
address the ethical, legal, and social issues (ELSI) that may arise from the project

Question 15

the Human Genome Project HGP ran from

Answer 15

1990 to 2003

Question 16

who coordinated the Human Genome Project HGP

Answer 16

the U.S department of Energy and the National Insitutes of Health

Question 17

what is the application of info technology to the field of biology

Answer 17

bioinformatics

Question 18

what searches across multiple local, state, and national DNA profile databases

Answer 18

CODIS - combined DNA index system

Question 19

true or false: next generation identification is not automated

Answer 19

false

Question 20

what is a national fingerprint and criminal history system maintained by the FBI and used by local, state, and federal law enforcment

Answer 20

integrated automated fingerprint indentification system IAFIS

Question 21

what is the largest biometric database in the world

Answer 21

integrated automated fingerprint identification system (IAFIS)

Question 22

as of September 2014, the IAFIS has been replaced with what

Answer 22

the next generation identification NGI

Question 23

what is a vehicle that does not rely on human intervention at all

Answer 23

autonomous cars

Question 24

cognitive computing gets better over time because

Answer 24

it learns from its interactions

Question 25

cognitive computing doesn't have all the info in a knowledge base but can

Answer 25

analyze outside data, both structured and unstructured

Question 26

what is a comp programmed to make decisions in real- life situations

Answer 26

expert system

Question 27

what simulates the judgement and behavior of a human expert and consists of 2 parts

Answer 27

expert system

Question 28

expert systems consists of what 2 parts

Answer 28

knowledge base and inference engine

Question 29

what contains expert knowledge and accumulated experience in a particular field

Answer 29

knowledge base

Question 30

what is a set of rules for applying the knowledge base to each particular situation

Answer 30

inference engine

Question 31

what is the branch of science concerned with making comps behave like humans

Answer 31

artificial intelligence

Question 32

what analyzes the links customers click as they visit a website and can help predict sales

Answer 32

click stream data mining

Question 33

what is a term that means the collection of large amounts of data from multiple sources- both internal and external thats used for ongoing analysis and decision making

Answer 33

big data

Question 34

big data is too large to use

Answer 34

DMBs

Question 35

what applications that are used to analyze data in info systems to help make decisions

Answer 35

business intelligence tools

Question 36

what are some examples of business intelligence tools

Answer 36

data mining, data warehousing, DLAP, decision support systems

Question 37

what is designed to help make decisions in situations where there is uncertainty about the possible outcomes of those decisions

Answer 37

decision support systems

Question 38

what provides info on daily operations and takes data from the transaction processing systems then puts the data into reports and simulations

Answer 38

management info system MIS

Question 39

what is a decentralized electronic database or distributed ledger of digital currency transactions

Answer 39

blockchain

Question 40

once recorded a block chain cannot be

Answer 40

deleted or changed

Question 41

each block in a block chains has a unique

Answer 41

hash

Question 42

what converts the data into an encrypted output of a fixed length

Answer 42

hash

Question 43

durability refers to

Answer 43

once transactions are done, they cant be undone

Question 44

isolation refers to

Answer 44

each transaction must occur seperately and must be independent

Question 45

consistency refers to

Answer 45

being consistent with its own operating rules

Question 46

atomicity refers to

Answer 46

a transaction will either happen fully or not

Question 47

what links multiple operations together and ensures that all operations in a transaction are completed without error

Answer 47

transaction processing system TPS

Question 48

what includes software and hardware that improve the productivity of employees by automating common tasks

Answer 48

office support systems

Question 49

office support systems requires a network

Answer 49

for electronic communication and storage

Question 50

what is people, hardware, and software that support data intensive applications

Answer 50

info system

Question 51

what are some examples of relational keywords

Answer 51

SELECT FROM WHERE AND

Question 52

what reduces data entry errors by using validation rules, such as data type, data length, acceptable values, and required values

Answer 52

data validation

Question 53

what reduces the size of a database makes it easier to keep records up to date, and increases query speed

Answer 53

data normalization

Question 54

what defines the kind of data that you can enter in a field

Answer 54

data type

Question 55

what defines all the fields and the type of data each field will contain

Answer 55

data dictionary

Question 56

what software is used to create and manage data in a database

Answer 56

database management system DBMS

Question 57

what is a central repository for all the data that an enterprise uses, including internal databases and external sources

Answer 57

data warehouses

Question 58

what discovers relationships between data items

Answer 58

data mining

Question 59

what enables a use to selectively extract and view data from different points of view

Answer 59

online analytical processing OLAP

Question 60

OLAP can also be used for

Answer 60

data mining

Question 61

what is optimized for storing and utilizing data

Answer 61

multidimensional database MDB

Question 62

what consists of both the data that describes the object and the processes that can be applied to it

Answer 62

object

Question 63

where is data stored as objects, which are used by modern programming languages

Answer 63

object- oriented databases (OODB)

Question 64

what breaks up the many to many relationships into one to many relationships

Answer 64

bridge table

Question 65

what is multiple records from a table can link to multiple records in another table

Answer 65

many to many relationships

Question 66

what is a record in one table is linked to a single record in another table

Answer 66

one to one relationships

Question 67

in one to one relationships the two tables are linked by the same

Answer 67

primary key

Question 68

what is the least common relationship database

Answer 68

one to one relationship

Question 69

what is the most common relationship database

Answer 69

one to many relationship

Question 70

what consists of multiple tables that are related by common info and reduces data redundancy

Answer 70

relational database

Question 71

what is the simplest database

Answer 71

flat

Question 72

what consists of a single list of items database

Answer 72

flat

Question 73

what displays data from a table or a query in a format that is easy to read and print

Answer 73

report

Question 74

what retrieves specific data from 1 or more tables

Answer 74

query

Question 75

what makes it easier to look at specific info on the screen

Answer 75

forms

Question 76

what is the special field in a record that uniquely identifies the record in the table

Answer 76

primary key

Question 77

each row in a table is called

Answer 77

a record

Question 78

a record contains the

Answer 78

info for a single entity

Question 79

each column in a table is

Answer 79

field

Question 80

what is a single peice of info in a record within a database

Answer 80

field

Question 81

what is a database object in which data is stored, arranged in rows and columns

Answer 81

table

Question 82

what is a collection of info that is organized in a useful way

Answer 82

database