Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Mis Exam 1 part 2

Total questions: 90

Worksheet time: 45mins

Name
Class
Date
1.

A collection of related data that is stored in a central location or in multiple locations.  

a)

Database

b)

Data hierarchy

c)

Database Management System

d)

Data Dictionary

2.

The belief that computing technology has created a large gap between the technology rich and the technology poor is referred to as the _______________.

a)

Technical economy

b)

Digital Divide

c)

Computing gap

d)

Digital Economic Index

3.

PII stands for _____________________.

a)
  • Privacy, Intelligence, Interaction

b)
  • Personally Identifiable Information

c)
  • Privileged Information Institute

d)
  • Personal Identification Indicator

4.

A "set of moral principles" or "the principles of conduct governing an individual or a group" are definitions for the term ____________.

a)

Morality

b)

Religion

c)

Ethics

d)

Social Values

5.

The European Union has much stricter privacy protection than the United States.

a)

True

b)

False

6.

The structure and organization of data, which involves fields, records, and files.

a)

Database

b)

Data hierarchy

c)

Database Management System

d)

Data Dictionary

7.

What is ethically right is the same no matter what culture or background one is from.

a)

True

b)

False

8.

A software for creating, storing, maintaining, and accessing database files. A ____ makes using databases more efficient. 

a)

Database

b)

Data hierarchy

c)

Database Management System

d)

Data Dictionary

9.

Stores definitions, such as data types for fields, default values, and validation rules for data in each field.

a)

Database

b)

Data hierarchy

c)

Database Management System

d)

Data Dictionary

10.

Records in files are organized and processed in numerical or sequential order, typically the order in which they were entered. 

a)

Sequential File Access System

b)

Random File Access System

c)

Index Sequential Access Method (ISAM)

11.

Records can be accessed in any order, regardless of their physical locations in storage media. This method of access is fast and very effective when a small number of records need to be processed daily or weekly. 

a)

Sequential File Access System

b)

Random File Access System

c)

Indexed Sequential Access Method (ISAM)

12.

Records can be accessed sequentially or randomly, depending on the number being accessed.

For a small number, random access is used, and for a large number, sequential access is used. 

a)

Sequential File Access System

b)

Random File Access System

c)

Indexed Sequential Access Method (ISAM)

13.

Involves how data is stored on and retrieved from storage media, such as hard disks, magnetic tapes, or CDs

a)

Physical View

b)

Logical View

14.

Involves how information appears to users and how it can be organized and retrieved. 

a)

Physical View

b)

Logical View

15.

Determines how data is created, represented, organized, and maintained. It usually contains data structure, operations, and integrity rules. 

a)

Data Model

b)

Hierarchical Model

c)

Network Model

d)

Relational Model

16.

The relationships between records form a tree-like structure. Records are called nodes, and relationships between records are called branches. The node at the top is called the root, and every other node (called a child) has a parent. Nodes with the same parents are called twins or siblings

a)

Data Model

b)

Hierarchical Model

c)

Network Model

d)

Relational Model

17.

Similar to the hierarchical model, but records are organized differently. Unlike the hierarchical model, each record in the _______ model can have multiple parent and child records. 

a)

Data Model

b)

Hierarchical Model

c)

Network Model

d)

Relational Model

18.

Uses a two-dimensional table of rows and columns of data. Rows are records (also called tuples), and columns are fields (also referred to as attributes). 

a)

Data Model

b)

Hierarchical Model

c)

Network Model

d)

Relational Model

19.

A collection of data from a variety of sources used to support decision-making applications and generate business intelligence. 

a)

Data Warehouse

b)

Primary Key

c)

Foreign Key

d)

Normalization

20.

Uniquely identifies every record in a relational database. Examples include student ID numbers, account numbers, Social Security numbers, and invoice numbers. 

a)

Data Warehouse

b)

Primary Key

c)

Foreign Key

d)

Normalization

21.

A field in a relational table that matches the primary key column of another table. It can be used to cross-reference tables. 

a)

Data Warehouse

b)

Primary Key

c)

Foreign Key

d)

Normalization

22.

Improves database efficiency by eliminating redundant data and ensures that only related data is stored in a table. 

a)

Data Warehouse

b)

Primary Key

c)

Foreign Key

d)

Normalization

23.

a standard fourth-generation query language used by many DBMS packages, such as Oracle 11g and Microsoft SQL Server. ___ consists of several keywords specifying actions to take.

a)

Structured Query Language (SQL) 

b)

query by example (QBE)

c)

Create, read, update, and delete (CRUD)

d)

Database administrators (DBA)

24.

you request data from a database by constructing a statement made up of query forms. With current graphical databases, you simply click to select query forms instead of having to remember keywords, as you do with SQL. You can add AND, OR, and NOT operators to the ___ form to fine-tune the query

a)

Structured Query Language (SQL) 

b)

query by example (QBE)

c)

Create, read, update, and delete (CRUD)

d)

Database administrators (DBA)

25.

Refers to the range of functions that data administrators determine who has permission to perform certain functions. 

a)

Structured Query Language (SQL) 

b)

query by example (QBE)

c)

Create, read, update, and delete (CRUD)

d)

Database administrators (DBA)

26.

Found in large organizations, design and set up databases, establish security measures, develop recovery procedures, evaluate database performance, and add and fine-tune database functions. 

a)

Structured Query Language (SQL) 

b)

query by example (QBE)

c)

Create, read, update, and delete (CRUD)

d)

Database administrators (DBA)

27.

Found in large organizations, design and set up databases, establish security measures, develop recovery procedures, evaluate database performance, and add and fine-tune database functions. 

a)

data-driven Web site

b)

distributed database management system (DDBMS)

28.

 Acts as an interface to a database, retrieving data for users and allowing users to enter data in the database. 

a)

data-driven Web site

b)

distributed database management system (DDBMS)

29.

Approach to a distributed DBMS addresses how tables are divided among multiple locations. There are three variations: horizontal, vertical, and mixed.

a)

Fragmentation

b)

Replication

c)

Allocation

d)

Object-oriented databases

e)

Encapsulation

30.

Approach to a distributed DBMS has each site store a copy of the data in the organization’s database. 

a)

Fragmentation

b)

Replication

c)

Allocation

d)

Object-oriented databases

e)

Encapsulation

31.

Approach to a distributed DBMS combines fragmentation and replication, with each site storing the data it uses most often. 

a)

Fragmentation

b)

Replication

c)

Allocation

d)

Object-oriented databases

e)

Encapsulation

32.

Both data and their relationships are contained in a single object. An object consists of attributes and methods that can be performed on the object’s data. 

a)

Fragmentation

b)

Replication

c)

Allocation

d)

Object-oriented databases

e)

Encapsulation

33.

Refers to the grouping into a class of various objects along with their attributes and methods—meaning, grouping related items into a single unit. This helps handle more complex types of data, such as images and graphs. 

a)

Fragmentation

b)

Replication

c)

Allocation

d)

Object-oriented databases

e)

Encapsulation

34.

Refers to new objects being created faster and more easily by entering new data in attributes.

a)

Inheritance

b)

Extraction, transformation, and loading (ETL)

c)

Online transaction processing (OLTP)

d)

Online analytical processing (OLAP)

35.

Refer to the processes used in a data warehouse. It includes extracting data from outside sources, transforming it to fit operational needs and loading it into the end target (database or data warehouse

a)

Inheritance

b)

Extraction, transformation, and loading (ETL)

c)

Online transaction processing (OLTP)

d)

Online analytical processing (OLAP)

36.

Used to facilitate and manage transaction-oriented applications, such as point-of-sale, data entry, and retrieval transaction processing. It generally uses internal data and responds in real-time. 

a)

Inheritance

b)

Extraction, transformation, and loading (ETL)

c)

Online transaction processing (OLTP)

d)

Online analytical processing (OLAP)

37.

Generates business intelligence. It uses multiple sources of information and provides multidimensional analysis, such as viewing data based on time, product, and location. 

a)

Inheritance

b)

Extraction, transformation, and loading (ETL)

c)

Online transaction processing (OLTP)

d)

Online analytical processing (OLAP)

38.

Used to discover patterns and relationships. 

a)

Data Mining Analysis

b)

Data Mart

39.

Usually a smaller version of a data warehouse, used by a single department or function. 

a)

Data Mining Analysis

b)

Data Mart

40.

uses data and statistical methods to gain insight into the data and provide decision-makers with the information they can act on. 

a)

Business Analytic

b)

Big Data

41.

Data so voluminous that conventional computing methods are not able to efficiently process and manage it. 

a)

Business Analytic

b)

Big Data

42.

Data can be counted

a)

Quantitative Data

b)

Qualitative Data

43.

Data can be descriptive

a)

Quantitative Data

b)

Qualitative Data

44.

Processed data that possess context, relevance, and purpose. 

a)

Information

b)

Knowledge

c)

Explicit Knowledge

d)

Tacit Knowledge

45.

A certain area is human beliefs or perceptions about relationships among facts or concepts relevant to that area

a)

Information

b)

Knowledge

c)

Explicit Knowledge

d)

Tacit Knowledge

46.

typically refers to knowledge that can be expressed into words or numbers.

a)

Information

b)

Knowledge

c)

Explicit Knowledge

d)

Tacit Knowledge

47.

Includes insights and intuitions, and is difficult to transfer to another person by means of simple communications.

a)

Information

b)

Knowledge

c)

Explicit Knowledge

d)

Tacit Knowledge

48.

storing non-numeric data that is brief, generally under 256 characters. The database designer can identify the maximum length of the text. 

a)

Text

b)

Number

c)

Boolean

d)

Currency

e)

Paragraph text

49.

Storing numbers. There are usually a few different number types that can be selected, depending on how large the largest number will be.  

a)

Text

b)

Number

c)

Boolean

d)

Currency

e)

Paragraph text

50.

A special form of the number data type that formats all values with a currency indicator and two decimal places.  

a)

Text

b)

Number

c)

Boolean

d)

Currency

e)

Paragraph text

51.

A data type with only two possible values, such as 0 or 1, “true” or “false”, “yes” or “no”. • Date/Time: a special form of the number data type that can be interpreted as a number or a time.  

a)

Object

b)

Number

c)

Boolean

d)

Currency

e)

Paragraph text

52.

This data type allows for text longer than 256 characters. 

a)

Object

b)

Number

c)

Boolean

d)

Currency

e)

Paragraph text

53.

This data type allows for the storage of data that cannot be entered via keyboard, such as an image or a music file. 

a)

Object

b)

Number

c)

Boolean

d)

Currency

e)

Paragraph text

54.

Describes how data is organized and the relationship among records 

a)

Data Structure

b)

Operations

c)

Integrity Rules

55.

Which of the following is not an objective of Normalization.

a)

Ensure data timeliness

b)

Reduce data redundancy

c)

Ensure data integrity

56.

Describes methods, calculations, and so forth that can be performed on data, such as updating and querying data 

a)

Data Structure

b)

Operations

c)

Integrity Rules

57.

Define the boundaries of a database, such as maximum and minimum values allowed for a field, constraints (limits on what type of data can be stored in a field), and access methods 

a)

Data Structure

b)

Operations

c)

Integrity Rules

58.

Collected from within an organization and can include transaction records, sales records, personnel records, and so forth

a)

Internal Data

b)

External Data

59.

comes from a variety of sources and is often stored in a data warehouse. Competitors, customers, suppliers, distribution networks, and tax records are some examples of sources of this data

a)

Internal Data

b)

External Data

60.

A data warehouse should be designed so that is meets the criteria of data normalization.

a)

True

b)

False

61.

is used to analyze data and build models without being explicitly programmed to do so

a)

A data mart

b)

Machine Learning

c)

Artificial Intelligence

d)

Business Analytics

62.

The multidimensional data stored in a Data warehouse are sometimes called _______________.

a)

Integrated Data

b)

Supervised

c)

Standardized

d)

Hypercubes

63.

_______________________________ is a fourth-generation language that can be used stand-alone or can be embedded in other computer languages to work with a relational database.

a)

SQL

b)

Microsoft Access

c)

QBE

d)

Pythone

64.

_______________________ database is where data is organized into tables containing tuples and attributes.

a)

Relational

b)

Sequential

c)

Indexed

d)

Random-Access

65.

A set of rules specifying the legal and ethical use of a system and the consequences of non-compliance

a)

Acceptable Use Policy

b)

Accountability

c)

Nonrepudiation

66.

Refers to issues involving both the user’s and the organization’s responsibilities and liabilities

a)

Acceptable Use Policy

b)

Accountability

c)

Nonrepudiation

67.

A method for binding all the parties to a contract

a)

Acceptable Use Policy

b)

Accountability

c)

Nonrepudiation

68.

An unsolicited e-mail sent for advertising purposes. 

a)

Spam

b)

Cookies

c)

Digital Divide

69.

Small text files with unique ID tags that are embedded in a Web browser and saved on the user’s hard drive. 

a)

Spam

b)

Cookies

c)

Digital Divide

70.

Information technology and the Internet have created a __________. Computers are still not affordable for many people. The ________ has implications for education

a)

Spam

b)

Cookies

c)

Digital Divide

71.

Generated by Web server software, record a user’s actions on a Web site. 

a)

Log Files

b)

Intellectual Property

c)

Cybersquatting

d)

Virtual Organization

e)

Green Computing

72.

A legal umbrella covering protections that involve copyrights, trademarks, trade secrets, and patents for “creations of the mind” developed by people or businesses

a)

Log Files

b)

Intellectual Property

c)

Cybersquatting

d)

Virtual Organization

e)

Green Computing

73.

Registering, selling, or using a domain name to profit from someone else’s trademark

a)

Log Files

b)

Intellectual Property

c)

Cybersquatting

d)

Virtual Organization

e)

Green Computing

74.

Networks of independent companies, suppliers, customers, and manufacturers connected via information technologies so they can share skills and costs and have access to each other’s markets

a)

Log Files

b)

Intellectual Property

c)

Cybersquatting

d)

Virtual Organization

e)

Green Computing

75.

Involves the design, manufacture, use, and disposal of computers, servers, and computing devices (such as monitors, printers, storage devices, and networking and communications equipment) in such a way that there is minimal impact on the environment. 

a)

Log Files

b)

Intellectual Property

c)

Cybersquatting

d)

Virtual Organization

e)

Green Computing

76.

The ability to control information about oneself is one definition of __________.

a)

Privacy

b)

Data Literacy

c)

Information Ethics

d)

Programming

77.

_____________ is a method for binding all the parties to a contract.

a)

Accountability

b)

Privacy

c)

Acceptable Use

d)

Nonrepudiation

78.

Junk e-mail or an unsolicited e-mail sent for advertising purposes is often referred to as __________.

a)

Spam

b)

Ham

c)

Intrusion of privacy

d)

Cookies

79.

A set of rules specifying the legal and ethical use of a system and the consequence of non-compliance is called an ___________________.

a)

Accountability policy

b)

Acceptable use policy

c)

Nonrepudiation policy

d)

Privacy policy

80.

Employers who monitor their employee's email and/or digital interactions have violated privacy law.

a)

True

b)

False

81.

Small text files with unique ID tags that are embedded in a Web browser and saved on the user's computer are called _______________.

a)

Spam

b)

Programs

c)

Cookies

d)

Web-bots

82.

A code of ethics has legal authority over those within the organization.

a)

True

b)

False

83.

_____________ refers to Internet service providers and government agencies treating all data on the Internet equally and not blocking or censoring information.

a)

Nonrepudiation

b)

No censorship

c)

Internet censorship

d)

Net neutrality

84.

You can feel safe giving your personal information to legitimate business because enforcement of federal laws has been strong.

a)

True

b)

False

85.

A ________________ for a company outlines a set of acceptable behaviors for a professional or social group.

a)

Acceptable Use Policy

b)

Code of ethics

c)

Code of conduct

d)

Accountability Statement

86.

A work of the mind or intellect is referred to as _______________.

a)

Copyright

b)

Intellectual Property

c)

Trademark

d)

Partent

87.

The Fair Use doctrine gives unlimited use to copywritten materials for the purpose of education.

a)

True

b)

False

88.

Computing that promotes a sustainable environment and consumes the least amount of energy is considered _________________.

a)

Responsible Computing

b)

Green Computing

c)

Environmental Computing

d)

Sustainable Computing

89.

Poor work habits and bad ergonomics are most often found to be the cause for health complaints directed to the use of computing in the workplace.

a)

True

b)

False

90.

If an individual invents a new product or process, their new product or process may be protected by use of a _____________.

a)

Copyright

b)

Trademark

c)

Intellectual Property

d)

Patent