MIS Chapter 5
Click all that applies to database approach to data management. A. Each distinct operational system uses data files dedicated to that system B. Information systems share a pool of related data through a common user interface C. Database approach reduces data redundancy D. Database approach increases data redundancy to improve performance and consistency of data
B and C
In Database as a Service (DaaS) A. Both database administration and data administration functions are handled by the service provider B. Both database administration and data administration functions are handled by the organization C. Database administration function is handled by the service provider and data administration function is handled by the organization D. Database administration function is handled by the organization and data administration function is handled by the service provider
C. Database admin= service provider and Data admib=organziation
Which is an example of a many to many relationship A. Class and Students B. Customers and orders C. Faculty teaching several classes, but a class taught by one faculty D. B and C only E. All of the above
Class and Students
A _________ is a collection of instructions and commands used to define and describe data and relationships in a specific database. A. data dictionary B. schema C. data definition language D. data manipulation language
Data Definition Language
The position of a ________ is a non-technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization A. data analyst B. data administrator C. database administrator D. data owner
Data administrator
With ________, the database is stored on a service provider's server and accessed by the client over a network, typically the Internet. A. Internet access B. Database as a Service C. Software as a Service D. Oracle
Database as a service
Starting from monthly sales data, if you wish to get weekly sales data, use the ________ feature. A. roll up B. drill down C. slice and dice D. extract data
Drill down? (not roll up)
A collection of data fields that are all related to one object, activity, or individual is called a file. A. True B. False
False
An attribute is a general class of people, places, or things for which data is collected, stored, and maintained. True False
False
DBMSs are used primarily for modeling data. True False
False
The cost of performing data cleansing is lower than data validation. True False
False
What is true about primary key? (I) Cannot have duplicate values (II) Cannot be null (III) Must be a single field A. (I) B. (II) C. (I) and (II) D. (I) and (III) E. All of the above
I and II
Which of the following statements is true of a database? A. It is accessed primarily for use by an organization's database administrator and data administrator B. It provides an essential foundation for an organization's knowledge management and artificial intelligence C. It is a collection of unstructured data D. It helps companies analyze information to open new market opportunities
It helps companies analyze information to open new market opportunities
______ is a special-purpose programming language for accessing and manipulating data stored in a relational database. A. Query by Example B. Access C. Structured Query Language D. Java
Structured Query Language (SQL)
If "color" is an attribute, then "green" is a data item A. True B. False
True
Which statement about concurrency control is correct? A. Concurrency control allows two or more users or applications to access the same data at the same time B. Without proper concurrency control, one of the updates might be incorrect C. Concurrency control is an important feature of a single user database D. Concurrency control cannot be enforced by the DBMS
Without proper concurrency control, one of the updates might be incorrect
You would use Query by Example, if _______ A. you wish to use a visual approach to query building B. you build a query from an example C. you use a template for reports D. you teach SQL with examples
You wish to use a visual approach to query building
_____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of handling A. data warehouse B. data mart C. big data D. knowledge base
big data
The smallest piece of data used by a computer is a (n)_______. A. entity B. byte C. bit D. character
bit
Suppose a new tech startup wants to define the data model. They would then________. A. collect and cleanse the data B. define user access privileges C. create the entity-relationship model D. acquire a new database management system
create the entity-relationship model
To ensure reliability and integrity, SQL, databases conform to four specific properties. Which of the following is NOT one of those four properties? A. atomicity B. durability C. isolation D. currency
currency
The structure of the database (schema) can be changed without affecting the sub-schema (user's view). This property is called A. atomicity B. data independence C. data redundancy D. data isolation
data independence
At Coast-to-Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in_________. A. data stewardship B. data lifecycle mangament C. database administration D. data management
data lifecycle management
A _______ is a subset of a data warehouse that is used by small and medium-sized businesses and departments within larger companies to support decision making. A. data dictionary B. data model C. data mart D. data mine
data mart
Kyle works for National Sporting Goods, where he manages critical data elements, such as identifying and acquiring new data sources, creating consistent reference data, and analyzing data for quality. Kyle is a_______. A. data steward B. data administrator C. database administrator D. data manager
data steward
Each attribute in a relational database model can be constrained to a range of allowable values called a _______. A. bandwidth B. scope C. slot D. domain
domain
______ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the function areas and departments within the organization. A. data selecting B. enterprise data modeling C. data cleansing D. social graph analysis
enterprise data modeling
A database is a collection of integrated and related________. A. fields B. attributes C. records D. files
files
A________ is a simple database program whose records have no relationship to one another. A. flat file B. schema C. relational system D. user view
flat file
For the _______ operation, it is required that the two tables have a common attribute. A. delete B. select C. project D. join
join
After entering data into a relational database, users can make all of the following basic data manipulations except A. projecting B. organizing C. selecting D. joining
organizing
A(n) ________ is a field or set of fields in a record that uniquely identifies the record. A. attribute B. entity C. primary key D. data item
primary key
The action of including only some columns for output while retrieving data is known as A. selecting B. joining C. projecting D. linking
projecting
A collection of fields all related to a single object, activity, or individual is a (n)________________. A. record B. file C. attribute D. character
record
Suppose you wish to find what tables are in a database, what fields they have and how they are related. You would review the_________. A. SQL commands B. attributes C. schema D. sample data
schema
Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database. In terms of the characteristics of big data, Haley is dealing with_________. A. volume B. variety C. velocity D. veracity
variety