Deck 8: The Era of Big Data: Databases, Information Systems, and Artificial Intelligence

Question 1

Which type of database model arranges fields or records in related groups whereby each child record can have only one parent record?

A) hierarchical database
B) network database
C) distributed database
D) object-oriented database

Answer 1

A

Question 2

Which database model was developed to improve on the hierarchical model and deal with more complex data relationships?

A) relational
B) network
C) object-oriented
D) SQL

Answer 2

B

Question 3

The ________ uniquely identifies a record.

A) main field
B) primary field
C) high field
D) key field

Answer 3

D

Question 4

Which type of database model is similar to a hierarchical database but allows each child record to have more than one parent record?

A) hierarchical database
B) network database
C) distributed database
D) object-oriented database

Question 5

A field is a unit of data consisting of one or more ________.

A) characters
B) tables
C) records
D) bits

Question 6

A file (table)is a collection of related ________.

A) characters
B) tables
C) fields
D) records

Question 7

The ________ is the smallest unit of data the computer can store in a database.

A) character
B) bit
C) field
D) record

Question 8

Which of the following is NOT a task performed by the database administrator (DBA)?

A) determining user access privileges
B) assisting in establishing priorities for requests
C) installing hardware
D) developing user documentation

Question 9

A record (row)is a collection of related ________.

A) characters
B) tables
C) fields
D) files

Question 10

What are programs that help a database to be maintained,by creating,editing,and deleting data,records,and files?

A) information manager
B) data dictionary
C) report generator
D) DBMS utilities

Question 11

Which of these is NOT an example of relational database terminology?

A) tuples
B) attributes
C) qualities
D) relations

Question 12

The person who coordinates all activities and needs for an organization's database is the ________.

A) database administrator
B) database manager
C) database analyst
D) database master

Question 13

Which of these is a program that produces an on-screen or printed document from all or part of a database?

A) DBMS
B) data dictionary
C) report generator
D) DBMS utilities

Question 14

Which of these is the current standard database type used on microcomputers?

A) hierarchical
B) relational
C) network
D) object-oriented

Question 15

What is 1 byte of data also called?

A) character
B) field
C) record
D) file

Question 16

Which of the following statements / clauses is NOT a component of structured query language (SQL)?

A) SELECT ...FROM statement
B) WHERE clause
C) ORDER BY clause
D) WHEREBY clause

Question 17

In a database management system,the ________ is a document or file that stores the data definitions and descriptions of the structure of data used in the database.

A) metadata manager
B) data dictionary
C) report generator
D) DBMS utility

Question 18

Which type of database model connects data in different files through the use of a key field?

A) hierarchical database
B) network database
C) relational database
D) object-oriented database

Question 19

What is the software that controls the structure of a database and access to the data?

A) personal information manager
B) database management system
C) project management
D) network operating system

Question 20

Which of these is NOT a level of the data storage hierarchy?

A) bit
B) byte
C) record
D) metadata

Question 21

Which department of an organization recruits people?

A) human resources
B) marketing and sales
C) production (operations)
D) research and development

Question 22

Which type of database uses software written in small,reusable chunks as elements within database files?

A) hierarchical database
B) network database
C) distributed database
D) object-oriented database

Question 23

If you were in operational (lower)management,which type of computer-based information system would you probably use?

A) transaction processing system (TPS)
B) management information system (MIS)
C) decision support system (DSS)
D) executive support system (ESS)

Question 24

A system that combines various technologies such as voice mail,fax machines,and others in order to reduce manual labor and increase productivity is a(n)________ system.

A) transaction processing
B) office information
C) decision support
D) executive support

Question 25

The ________ manager is concerned with long-range planning and decisions.

A) operational
B) tactical
C) strategic
D) principal

Question 26

If you were in top management,which type of computer-based information system would you use?

A) transaction processing system (TPS)
B) office automation system (OAS)
C) executive support system (ESS)
D) operational support system (DSS)

Question 27

The ________ manager makes low-level decisions by following a well-defined set of routine procedures.

A) operational
B) tactical
C) strategic
D) principal

Question 28

A computer-based information system that uses data recorded by transaction processing system as input into programs that produce routine reports as output is a(n)________ system.

A) office automation
B) executive support
C) management information
D) decision support

Question 29

A computer-based information system that provides a flexible tool for analysis and helps managers focus on the future is a(n)________ system.

A) office automation
B) decision support
C) executive support
D) transaction processing

Question 30

The ________ manager makes tactical decisions to implement the strategic goals of an organization.

A) operational
B) tactical
C) strategic
D) principal

Question 31

What is a special database of cleansed data and metadata called?

A) data warehouse
B) relational database
C) shared database
D) data area

Question 32

A computer-based information system that keeps track of the transactions needed to conduct business is a(n)________ system.

A) transaction processing
B) office automation
C) executive support
D) decision support

Question 33

Which function of an organization oversees advertising and promotion?

A) human resources
B) marketing and sales
C) production (operations)
D) research and development

Question 34

Which of the following statements about managers is incorrect?

A) Top-level managers make long-term decisions.
B) Lower management makes operational decisions.
C) Operational managers make analytical decisions.
D) Middle-level managers make tactical decisions.

Question 35

Which of the following is the computer-assisted process of sifting through and analyzing vast amounts of data to extract meaning and discover new knowledge?

A) data mining
B) e-commerce
C) data warehousing
D) business-to-business systems

Question 36

What describes contents of a data warehouse?

A) omega data
B) metadata
C) data area
D) warehouse data

Question 37

What is the process of removing errors and inconsistencies from data called?

A) data cleansing
B) data polishing
C) data buffing
D) data manipulation

Question 38

Data that is so large and complex that it cannot be processed using conventional methods is called _________.

A) metadata
B) data fusion
C) Big Data
D) online analytical processing

Question 39

In a business organization,a recorded event having to do with routine business activities is a ________.

A) model
B) transaction
C) operation
D) contract

Question 40

An easy-to-use decision support system that specifically supports strategic decision making is a(n)________ system.

A) executive support
B) office automation
C) decision support
D) transaction processing

Question 41

The ________ test is used to determine if computers have achieved the level of human intelligence.

A) Gunther
B) singularity
C) Turing
D) rationality

Question 42

Bits,bytes,fields,records,files,databases,and networks are the different levels of data stored in a data storage hierarchy.

Question 43

The database administrator coordinates all related activities and needs for an organization's database.

Question 44

Key fields are necessary so that records can be identified,retrieved and processed.

Question 45

A collection of related fields is a record.

Question 46

A file is a collection of related fields.

Question 47

A field of data is a collection of records.

Question 48

A data dictionary is a document or a file that stores the data definitions and descriptions of the structure of data used in the database.

Question 49

A set of interactive computer programs that help users solve problems that would otherwise require the assistance of a human specialist is a(n)________ system.

A) expert
B) AI
C) professional
D) decision

Question 50

In network database model was developed in part to solve some of the problems of the rigid hierarchical database model.

Question 51

A database management system (DBMS)is a collection of programs that controls the structure of a database and access to the data.

Question 52

A byte of data is the same as a character.

Question 53

A database analyst is responsible for coordinating and managing all the activities of a database.

Question 54

A field within a record that is chosen to uniquely identify the record is the main field.

Question 55

The field of artificial intelligence,which would not be possible without database technology,includes all BUT which one of these fields?

A) expert systems
B) transaction processing systems
C) robotics
D) natural language processing

Question 56

The components of an expert system include all BUT which one of these?

A) speech recognition
B) knowledge base
C) inference engine
D) user interface

Question 57

If a database model arranges fields or records in related groups (like a family tree),it is an organizational chart database.

Question 58

DBMS utilities are programs used to generate on-screen or printed documents from part or all of a database.

Question 59

In a hierarchical database,there are no limits or restrictions to the number of possible links among records.

Question 60

One use of virtual reality is to build ________ to represent the behavior of physical or abstract systems and use them to train people in realistic situations.

A) robotics
B) simulators
C) natural language systems
D) strong AI

Question 61

To reach the DSS level of sophistication in information technology,an organization must have first established TPS and MIS systems.

Question 62

In an object-oriented database,an object can be data in any form,as well as instructions on the action to be taken on the data.

Question 63

Big Data aims to tap web data and other data that is outside corporate databases.

Question 64

Data mining is the process of removing errors and inconsistencies from data.

Question 65

A special database of cleansed data is a data dictionary.

Question 66

A transaction processing system is a computer-based information system that provides a flexible tool for analysis and helps managers to focus on the future.

Question 67

Structured query language (SQL)is the standard query language used to create,modify,maintain,and query relational databases.

Question 68

Most popular database management programs provide a graphical query-building tool to aid users who do not have a thorough knowledge of SQL.

Question 69

A hypertext database,or web database,is a type of object-oriented database.

Question 70

Human resources department is the same as the personnel department.

Question 71

Management information systems use data recorded by a TPS as input into programs that produce routine reports as output.

Question 72

An object-oriented database uses software written in small,reusable chunks as elements within the database file.

Question 73

The database of transactions stored in a TPS provides the basis for management information systems and decision support systems.

Question 74

Operations managers oversee nonmanagement employees and are likely to use transactional processing systems.

Question 75

Office automation systems,which combine various technologies,are used throughout all levels of an organization.

Question 76

The type of manager who is concerned with long-range planning and decisions is an operations manager.

Question 77

A hierarchical database is more flexible than a network database.

Question 78

Metadata is "cleansed" data about data; it shows the origin of the data,the transformations it has undergone,and summary information about it.

Question 79

In a relational database,there are no access paths down through a particular hierarchy.

Question 80

The relational database model is more flexible than the hierarchical and the network database models.