Filters
Question type
Study Flashcards

What is data redundancy?


A) Duplication of data
B) Storing the same data in multiple places
C) Storing duplicate data in multiple places
D) All of the above

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

A data ______________ compiles all of the metadata about the data elements in the data model.

Correct Answer

verifed

verified

Which of the following is incorrect in reference to a database?


A) A database can be relational or network
B) Database information is accessed by logical structure
C) Database information is accessed by physical structure
D) Database users can have different views of information

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

Association ___________ reveals the relationship between variables along with the nature and frequency of the relationships.

Correct Answer

verifed

verified

Extraction,transformation,and loading is a process that extracts information from internal databases,transforms the information using a common set of enterprise definitions,and loads the information into an external database.

A) True
B) False

Correct Answer

verifed

verified

Which of the following would not be considered part of the timely characteristic of high-quality information?


A) Is the zip code missing in the address?
B) Is the information current with respect to business needs?
C) Is the customer address current?
D) Is the information updated weekly or hourly?

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

What is data mining?


A) The common term for the representation of multidimensional information
B) A particular attribute of information
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making
D) Process of analyzing data to extract information not offered by the raw data alone

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

What are the rules that help ensure the quality of information?


A) Information integrity
B) Integrity constraints
C) Relational integrity constraints
D) Business-critical integrity constraints

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

Most people request real-time information without understanding that continual __________ is one of its biggest pitfalls.


A) Improvements
B) Change
C) Clustering
D) Cleansing

E) None of the above
F) A) and B)

Correct Answer

verifed

verified

What are the primary differences between a data warehouse and a data mart?


A) Data warehouses make quick decisions,data marts make slow decisions
B) Data warehouse tackle ethical issues,data marts tackle hypothetical issues
C) Data warehouses have a more organization-wide focus,data marts have functional focus
D) Data warehouses have a physical focus,data marts have logical focus

E) B) and C)
F) A) and B)

Correct Answer

verifed

verified

Why do relational databases use primary keys and foreign keys?


A) To create an entity
B) To create physical relationships
C) To create logical relationships
D) To create an attribute

E) None of the above
F) B) and D)

Correct Answer

verifed

verified

What is a foreign key?


A) A field (or group of fields) that uniquely identifies a given entity in a table
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C) Characteristics or properties of an entity
D) A field (or group of fields) that uniquely identifies a given attribute in a table

E) B) and D)
F) B) and C)

Correct Answer

verifed

verified

What is stored in a dynamic catalog,or an area of a website that stores information about products in a database?


A) Dynamic website
B) Data-driven website
C) Static information
D) Dynamic information

E) A) and C)
F) C) and D)

Correct Answer

verifed

verified

The financial industry uses business intelligence to predict hardware failures.

A) True
B) False

Correct Answer

verifed

verified

A ____________ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.Stating that merchandise returns are allowed within 10 days of purchase is an example of a business rule.

Correct Answer

verifed

verified

Real-time ___________ provide real-time information in response to requests.

Correct Answer

verifed

verified

_____________ provides details about data.

Correct Answer

verifed

verified

Within the data warehouse model,the internal databases could include marketing,sales,inventory,and billing.

A) True
B) False

Correct Answer

verifed

verified

Static information includes data that change based on user actions.

A) True
B) False

Correct Answer

verifed

verified

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?


A) Relational integrity constraint
B) Business-critical integrity constraint
C) Information-critical integrity constraint
D) None of the above

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

Showing 81 - 100 of 284

Related Exams

Exam 1

Management Information Systems: Business Driven MIS

313 Questions

Exam 2

Decisions Processes: Value Driven Business

329 Questions

Exam 3

Ebusiness: Electronic Business Value

383 Questions

Exam 4

Ethics Information Security: MIS Business Concerns

342 Questions

Exam 5

Infrastructures: Sustainable Technologies

250 Questions

Exam 7

Networks: Mobile Business

268 Questions

Exam 8

Enterprise Applications: Business Communications

241 Questions

Exam 9

Systems Development and Project Management: Corporate Responsibility

289 Questions

Show Answer