CS401A's Prelims: Info Management Module 01

Question 1

Raw facts, or facts that have not yet been processed to reveal their meaning to the end user.

Answer 1

Data

Question 2

The result of processing raw data to reveal its meaning.

Answer 2

Information

Question 3

consists of transformed data and facilities decision making.

Answer 3

Information

Question 4

is a shared, integrated computer structure that houses a collection of data.

Answer 4

Database

Question 5

that is, raw facts of interest to the end user.

Answer 5

End-user data

Question 6

or data about data,

Answer 6

Metadata,

Question 7

through which the end-user data is integrated and managed.

Answer 7

Metadata,

Question 8

is a collection of programs that manages the database structure and controls access to the data stored in the database.

Answer 8

A Database Management System (DBMS)

Question 9

serves as the intermediary between the user and the database.

Answer 9

The DBMS (Database Management System)

Question 10

The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the

Answer 10

DBMS (Database Management System).

Question 11

The DBMS serves as the intermediary between the user and the database.

Answer 11

Improved data sharing

Question 12

The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS.

Answer 12

Improved data sharing

Question 13

A DBMS provides a framework for better enforcement of data privacy and security policies.

Answer 13

Improved data security

Question 14

Wider access to well-managed data promotes an integrated view of the organization’s
operations and a clearer view of the big picture.

Answer 14

Better data integration

Question 15

Data inconsistency exists when different versions of the same data appear in different places.

Answer 15

Minimized data inconsistency

Question 16

The DBMS makes it possible to produce quick answers to ad hoc queries.

Answer 16

Improved data access

Question 17

From a database perspective,
is a specific request issued to the DBMS for data manipulation

Answer 17

a query

Question 18

Better-managed data and improved data access make it possible to generate better-
quality information, on which better decisions are based.

Answer 18

Improved decision making

Question 19

The availability of data, combined with the tools that transform data into usable
information, empowers end users to make quick, informed decisions that can make the difference between success and failure in the global economy.

Answer 19

Increased end-user productivity

Question 20

can be used to build many different types of databases.

Answer 20

Database Management System (DBMS)

Question 21

A type of database that supports only one user at a time.

Answer 21

Single-user database

Question 22

Single user database that runs on personal computer.

Answer 22

Desktop database

Question 23

A type of database that supports multiple users at the same time.

Answer 23

Multiuser database

Question 24

A type of database that supports a relatively small number of users or a specific department
within an organization.

Answer 24

Workgroup database

Question 25

A type of database that is used by the entire organization and supports many users across many departments.

Answer 25

Enterprise database

Question 26

A type of database that supports data located at a single site.

Answer 26

Centralized database

Question 27

A type of database that supports data distributed across several different sites.

Answer 27

Distributed database

Question 28

A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS.

Answer 28

Cloud database

Question 29

A database that contains a wide variety of data used in multiple disciplines.

Answer 29

General-purpose database

Question 30

A type of database that contains data focused on specific subject areas.

Answer 30

Discipline-specific database

Question 31

A type of database designed primarily to support a company's day-to-day operations.

Answer 31

Operational database

Question 32

A type of database focused primarily on storing historical data and business metrics used for tactical or strategic decision making.

Answer 32

Analytical database

Question 33

refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.

Answer 33

Database Design

Question 34

A database that meets all user requirements does not just happen; its structure must be designed carefully.

Answer 34

Database Design

Question 35

# TRUE || FALSE The first step in constructing a physical database should be skipping the logical design and directly integrating the database structure.

Answer 35

FALSE | First step should be transforming logical design using best practices.

Question 36

# TRUE || FALSE Understanding the shortcomings of the file system enables you to understand the development of modern databases.

Answer 36

TRUE

Question 37

# TRUE || FALSE The file system method of organizing and managing data was a flawless improvement over the manual system, and the file system served as useful purpose in data management for over two (2) decades.

Answer 37

FALSE | The system was an improvement. Nonetheless, many flaws became evident.

Question 38

modern databases use a nonprocedural data manipulation language that allows the user to specify what must be done without specifying how.

Answer 38

Lengthy development times

Question 39

The need to write programs to produce even the simplest reports makes ad hoc queries impossible.

Answer 39

Difficulty of getting quick answers

Question 40

System administration becomes more difficult as the number of files in the system expands.

Answer 40

Complex system administration

Question 41

Even a simple file system with a few files requires creating and maintaining several file management programs.

Answer 41

Complex system administration

Question 42

Another fault of a file system data repository. Data sharing and security are closely related.

Answer 42

Lack of security and limited data sharing

Question 43

Sharing data among multiple geographically dispersed users introduces a log of security risks.

Answer 43

Lack of security and limited data sharing

Question 44

Making changes to an existing file structure can be difficult in a file system environment.

Answer 44

Extensive programming

Question 45

A data characteristic in which a change in the database schema affects data access, thus requiring changes in all access programs.

Answer 45

Structural dependence

Question 46

A data characteristic in which changes in the database schema do not affect data access.

Answer 46

Structural independence

Question 47

A data condition in which data representation and manipulation are dependent on the physical data storage characteristics.

Answer 47

Data dependence

Question 48

A condition in which data access is unaffected by changes in the physical data storage characteristics.

Answer 48

Data independence

Question 49

It exists when the same data is stored unnecessarily at different places.

Answer 49

Data redundancy

Question 50

Uncontrolled data redundancy sets the stage for the following:

Answer 50

Poor data security Data inconsistency Data-entry errors Data integrity problems

Question 51

Having multiple copies of data increases the chances for a copy of the data to be susceptible to unauthorized access.

Answer 51

Poor data security

Question 52

exists when different and conflicting versions for the same data appear in different places.

Answer 52

Data inconsistency

Question 53

are more likely to occur when complex entries are made in several different files or recur frequently in one or more files.

Answer 53

Data-entry errors

Question 54

# Occurs when there is inconsistent data is stored. For example, entering a nonexistent sales agent's name and phone number into a Customer file can mislead customers and cause errors in the system.

Answer 54

Data integrity problems

Question 55

# Occurs when there is inconsistent data is stored. For example, It is possible to enter a nonexistent sales agent's name and phone number into the Customer file, but customers are not likely to be impressed if the insurance agency supplies the name and phone number of an agent who does not exist.

Answer 55

Data integrity problems

Question 56

# What is it called when in which inconsistent change have been made to a database.

Answer 56

A data abnormality

Question 57

# What develops when not all of the required changes in the redundant data are made successfully.

Answer 57

A data anomaly