Filters
Question type

Study Flashcards

Ben works at a top accounting firm in Sydney and his responsibilities include writing letters,memos and emails,along with generating reports for financial analysis and marketing materials for products.Ben's duties provide value-added to his company and would be categorised as occurring at the different ____________.


A) Information levels
B) Information formats
C) Information granularities
D) Information focus

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

Correct Answer

verifed

verified

Which of the following is not an advantage to a data-driven website?


A) Development
B) Minimising human error
C) Increasing update costs
D) More efficient

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

Correct Answer

verifed

verified

Your textbook discussed a record store example where one user could perform a query to determine which recordings had a track length of four minutes or more,and another user could perform an analysis to determine the distribution of recordings as they relate to the different categories.What database advantage is this an example of?


A) Increased scalability and performance
B) Increased information security
C) Reduced information redundancy
D) Increased flexibility

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

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 warehouses tackle ethical issues,data marts tackle hypothetical issues
C) Data warehouses have a more organisation-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 D)

Correct Answer

verifed

verified

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


A) Is the name spelled correctly?
B) Is the email address invalid?
C) Does the name and the phone values have the exact same information?
D) Is aggregate information in agreement with detailed information?

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

Correct Answer

verifed

verified

Gender can be referred to in many ways (male,female,M/F,1/0) in a data warehouse.What is this an example of?


A) Information scaling
B) Streamlining data points
C) Standardising information
D) Standardising protocols

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

Correct Answer

verifed

verified

Describe a database,a database management system and the relational database model.

Correct Answer

verifed

verified

Which of the following represents the different information granularities?


A) Detail,summary,aggregate
B) Document,presentation,spreadsheet,database
C) Individual,department,enterprise
D) None of the answers is correct

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

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 between 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) A) and B)
F) B) and D)

Correct Answer

verifed

verified

The financial industry uses business intelligence to predict hardware failures.

A) True
B) False

Correct Answer

verifed

verified

The core components of any system,regardless of size,are a database and a database management system.

A) True
B) False

Correct Answer

verifed

verified

Databases offer many security features including passwords to provide authentication,access levels to determine who can access the data,and access controls to determine what type of access they have to the information.

A) True
B) False

Correct Answer

verifed

verified

Which of the following represents the different information levels?


A) Detail,summary,aggregate
B) Document,presentation,spreadsheet,database
C) Individual,department,enterprise
D) None of the answers is correct

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

Correct Answer

verifed

verified

Which of the following is not a primary trait of information?


A) Transactional
B) Analytical
C) Timeliness
D) Quantity

E) A) and D)
F) All of the above

Correct Answer

verifed

verified

What is data mining?


A) The common term for the representation of multi-dimensional 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 behavioor and guide decision making
D) Process of analysing data to extract information not offered by the raw data alone

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

Correct Answer

verifed

verified

What is one of the biggest pitfalls associated with real-time information?


A) It is only available to high-level executives due to the expense
B) It is only available in aggregate levels of granularity
C) It continually changes
D) It rarely changes

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

Correct Answer

verifed

verified

Redundancy is the duplication of data,or storing the same data in multiple places.

A) True
B) False

Correct Answer

verifed

verified

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

A) True
B) False

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) None of the above
F) B) and C)

Correct Answer

verifed

verified

What is the primary difference between an entity and an attribute?


A) An attribute is a table,an entity is a column from the attribute table
B) An entity is specific; whereas,an attribute is not data at all but brainstorming ideas that take place before the entity is created
C) An attribute refers to applications,and an entity refers to executives
D) An entity is a table that stores information about people,places or events; whereas,an attribute is a column or specific field of the data elements associated with an entity

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

Correct Answer

verifed

verified

Showing 41 - 60 of 79

Related Exams

Show Answer