Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Management
Q:
Timely information asks if the information is current with respect to the business needs.
Q:
Which of the following statements does not describe the Zappos database?
A. The Zappos database was highly scalable.
B. The Zappos database was highly flexible.
C. The Zappos database was highly secure.
D. The Zappos database was highly redundant.
Q:
Consistent information asks if the aggregate or summary information is in agreement with detailed information.
Q:
What is it called when a manager has so much data and information that he or she cannot make a decision?
A. data rich, information poor
B. data rich, content poor
C. data rich, communication poor
D. data rich, intelligence
Q:
Complete information asks if there is a value missing from the information.
Q:
What is data-driven website?
A. the person responsible for creating the original website content
B. includes data that change based on user action
C. information stored in a dynamic catalog, or an area of a website that stores information about products in a database
D. an interactive website kept constantly updated and relevant to the needs of its customers using a database
Q:
Accurate information asks if there is an incorrect value in the information.
Q:
What is a dynamic website?
A. the person responsible for creating the original website content
B. includes data that change based on user action
C. information stored in a dynamic catalog, or an area of a website that stores information about products in a database
D. an interactive website kept constantly updated and relevant to the needs of its customers using a database
Q:
If a manager identifies numerous information integrity issues, he or she should consider the reports generated from that data as invalid and not use them when making decisions.
Q:
What is dynamic information?
A. the person responsible for creating the original website content
B. the person responsible for updating and maintaining website content
C. includes fixed data incapable of change in the event of a user action
D. includes data that change based on user action
Q:
Information integrity issues occur when a system produces incorrect, inconsistent, or duplicate data.
Q:
What is static information?
A. the person responsible for creating the original website content
B. the person responsible for updating and maintaining website content
C. includes fixed data incapable of change in the event of a user action
D. includes data that change based on user action
Q:
Information integrity issues occur when the same data element has different values.
Q:
What is a content editor?
A. the person responsible for creating the original website content
B. the person responsible for updating and maintaining website content
C. includes fixed data incapable of change in the event of a user action
D. includes data that change based on user action
Q:
Real-time systems provide real-time information in response to requests.
Q:
What is a content creator?
A. the person responsible for creating the original website content
B. the person responsible for updating and maintaining website content
C. includes fixed data incapable of change in the event of a user action
D. includes data that change based on user action
Q:
Timely information must be up-to-the-second to be accurate.
Q:
What is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
A. dynamic website
B. data-driven website
C. static information
D. dynamic information
Q:
Information granularity means immediate, up-to-date information.
Q:
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
Q:
Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).
Q:
What includes data that change based on user actions?
A. content creator
B. content editor
C. static information
D. dynamic information
Q:
Reports for each sales person, product, and part are examples of detail or fine information granularities.
Q:
What includes fixed data incapable of change in the event of a user action?
A. content creator
B. content editor
C. static information
D. dynamic information
Q:
Organizational information comes at the same level, formats, and granularities.
Q:
Who is the person responsible for updating and maintaining website content?
A. content creator
B. content editor
C. static information
D. dynamic information
Q:
There are only two main primary traits that help you determine the value of information including timeliness and quality.
Q:
Who is the person responsible for creating the original website content?
A. content creator
B. content editor
C. static information
D. dynamic information
Q:
The four primary traits of the value of information include levels, formats, granularities, and type.
Q:
Which of the following is not an advantage to a data-driven website?
A. limit the amount of information displayed to customers
B. minimizing human error
C. increasing update costs
D. more efficient
Q:
Organizational information has three characteristics including timeliness, quality, and governance.
Q:
Which of the following is not an example of an advantage to using the Web to access organizational databases?
A. Web browsers are much easier to use than a computer based database.
B. The web interface requires few or no changes to the database model.
C. It is cleaner and virus-free.
D. It costs less.
Q:
Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.
Q:
Which of the statements below means the same as easy to manage content?
A. Website owners can make changes only with the aid of MIS professionals.
B. The website cannot organize customer data.
C. Users can update data-driven website with little or no training.
D. Users with extensive training can update data-driven websites.
Q:
The four primary traits of the value of information include type, timeliness, quality, and governance.
Q:
Which of the following offers an advantage of using a data-driven website?
A. easy to eliminate human errors
B. easy to manage content
C. easy to store large amounts of data
D. All of these are correct.
Q:
Organizational information has three characteristics including levels, formats, and granularities.
Q:
What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?
A. data-driven website
B. interactive website
C. database performing website
D. data processing website
Q:
Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).
Q:
Which of the following will enforce business rules vital to an organizations success and often require more insight and knowledge than relational integrity constraints?
A. quality business constraints
B. critical web constraints
C. business critical integrity constraints
D. web integrity constraints
Q:
Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract).
Q:
What are the rules that enforce basic and fundamental information-based constraints?
A. responsible integrity constraints
B. quality constraints
C. web integrity constraints
D. relational integrity constraints
Q:
What are rules that help ensure the quality of information?
A. information integrity
B. integrity constraints
C. information quality
D. information ethics
Q:
One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?
A. reduces disk space requirements
B. makes updating information easier
C. improves information quality
D. All of these are correct.
Q:
Which of the following is a business-critical integrity constraint?
A. System will not allow an entry for an order for a nonexistent customer.
B. System will not allow returns of fresh produce after 15 days past delivery.
C. System will not allow shipping a product to a customer who does not have a valid address.
D. system will not allow shipping of a nonexistent product to a customer.
Q:
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. mission-critical integrity constraint
Q:
Which of the following is a valid type of integrity constraint?
A. relational-critical integrity constraint
B. business integrity constraint
C. relational integrity constraint
D. business-critical integrity constraint
Q:
What are rules that enforce basic and fundamental information-based constraints?
A. information integrity
B. integrity constraint
C. business-critical integrity constraint
D. relational integrity constraint
Q:
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
Q:
Which of the following is true in regard to the elimination of redundant information?
A. uses additional hard disk space
B. makes performing information updates harder
C. improves information quality
D. All of these are correct.
Q:
What is the primary problem with redundant information?
A. It is difficult to determine which values are the most current.
B. It is often inconsistent.
C. It is difficult to determine which values are the most accurate.
D. All of these are correct.
Q:
What is information redundancy?
A. duplication of data
B. storing the same data in multiple places
C. storing duplicate data in multiple places
D. All of these are correct.
Q:
Which of the following is a disadvantage of database-stored information?
A. increased flexibility
B. increased performance
C. increased information redundancy
D. increased information integrity
Q:
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.
Q:
Which of the following is not an example of an advantage of using a relational database?
A. increased information quality
B. increased flexibility
C. decreased information redundancy
D. decreased information security
Q:
The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information. What is this an example of?
A. increased scalability and performance
B. increased information security
C. reduced information redundancy
D. increased flexibility
Q:
Which of the following focuses on how individual users logically access information to meet their own particular business needs?
A. physical view
B. logical view
C. data mart view
D. data view
Q:
Which of the following is correct in reference to a database?
A. A database can support only one logical view.
B. A database can support many physical views.
C. A database can support many logical views.
D. A database can support up to 3 logical views.
Q:
What is the logical view of information?
A. deals with the physical storage of information on a storage device such as a hard disk
B. deals with the logical storage of information on a storage device such as a hard disk
C. focuses on how users logically access information to meet their particular business needs
D. focuses on how users physically access information to meet their particular business needs
Q:
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. This is an advantage of which database example?
A. increased scalability and performance
B. increased information security
C. reduced information redundancy
D. increased flexibility
Q:
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
Q:
What is the role of a foreign key?
A. It is 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.
B. It is a unique way to identify each record.
C. Is a field that uniquely identifies a give record in a table.
D. All of these are correct.
Q:
What is a field that uniquely identifies a given record in a table?
A. foreign key
B. primary key
C. data mining key
D. DBMS key
Q:
What type of keys do you need to use to create a relational database model?
A. primary keys and secondary keys
B. primary keys and foreign keys
C. entity keys and attribute keys
D. relational keys and DBMS keys
Q:
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
Q:
Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?
A. entity
B. extraction
C. attribute
D. foreign key
Q:
Which of the following illustrates the primary concepts of the relational database model?
A. ethics, applications, keys, and relationships
B. entities, attributes, keys, and relationships
C. endeavor, aspire, control, and regulate
D. early, after, before, and future
Q:
What is a primary 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
Q:
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
Q:
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
A. entity
B. relationships
C. attribute
D. foreign Key
Q:
What compiles all of the metadata about the data elements in the data model?
A. data entity
B. data element
C. data attribute
D. data dictionary
Q:
What is a logical data structure that details the relationship among data elements using graphics or pictures?
A. data model
B. data element
C. data mining tool
D. data mart tool
Q:
What is the smallest or basic unit of information?
A. database management element
B. data element
C. data model
D. data integrity issue
Q:
What is the primary tool that retrieves information and helps users graphically design the answer to a question?
A. data mining tools
B. structured example language
C. query-by-example tool
D. relational query tool
Q:
Which of the following asks users to write lines of code to answer questions against a database?
A. structured query language
B. relational query language
C. structured elements
D. data mining tools
Q:
A database maintains information on ________.
A. inventory
B. transactions
C. employees
D. All of these are correct.
Q:
Which of the following systems allow users to create, read, update, and delete data in a relational database?
A. business intelligence system
B. informational database system
C. relational database management system
D. data mining system
Q:
What maintains information about various types of objects, events, people, and places?
A. database
B. data model
C. data mining
D. data intelligence
Q:
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
A. database element
B. database management system
C. data governance
D. data file
Q:
What is master data management?
A. occurs when the same data element has different values
B. occurs when a system produces incorrect, inconsistent, or duplicate data
C. refers to the overall management of the availability, usability, integrity, and security of company data
D. the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems