What is the first step you should take in managing data for a firm? |
Identify the data needed to run the business. |
Which of the following best illustrates the relationship between entities and attributes? |
The entity CUSTOMER with the attribute ADDRESS |
Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables? |
Relational DBMS |
What are the relationships that the relational database is named for? |
Relationships between entities |
A characteristic or quality describing an entity is called a(n): |
Attribute |
The most basic business database is comprised of: |
five tables: for customers, employees, suppliers, parts, and sales. |
In a table for customers, the information about a single customer would reside in a single: |
Row |
In a relational database, a record is also called a(n): |
Tuple |
A field identified in a table as holding the unique identifier of the table’s records is called the: |
Primary key |
A field identified in a record as holding the unique identifier for that record is called the: |
Key field |
A schematic of the entire database that describes the relationships in a database is called a(n): |
Entity-relationship diagram. |
A one-to-one relationship between two entities is symbolized in a diagram by a line that ends |
In two short marks |
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends: |
With a crow’s foot preceded by a short mark. |
A table that links two tables that have a many-to-many relationship is often called a(n): |
Intersection relation |
The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called: |
Normalization |
Which of the following best describes the importance of creating an accurate data model for your business’s database? |
It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. |
You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table? |
One-To-One |
Relational database systems use ________ to ensure that relationships between coupled tables remain consistent. |
Referential integrity rules |
The smallest unit of data a computer can handle is called a: |
Bit |
A grouping of characters into a word, a group of words, or a complete number is called a record. |
False |
Every record in a file should contain at least one key field. |
True |
A foreign key is a field that links to a separate table. |
True |
A DBMS makes the: |
physical database available for different logical views. |
The logical view of a database: |
presents data as they would be perceived by end users. |
Which of the following allows users to add, change, delete, or retrieve data in a database? |
Data manipulation language |
In a relational database, the three basic operations used to develop useful sets of data are: |
select, project, and join. |
The select operation: |
creates a subset consisting of all records in the file that meet stated criteria. |
The project operation: |
creates a subset consisting of columns in a table. |
Which of the following is an automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security? |
Data dictionary |
Which of the following is the most prominent data manipulation language today? |
SQL |
What is the purpose of a DBMS’s data definition function? |
Structuring the database |
Both Oracle and Microsoft Access use SQL to retrieve information from a database. |
True |
DBMS simplify how end users work with databases by separating the logical and physical views of the data. |
True |
A DBMS is special software for creating, storing, organizing, and accessing data from a database. |
False |
A physical view shows data as it is organized on the storage media. |
True |
End users use a data manipulation language to manipulate data in the database. |
True |
MongoDB and SimpleDB are both examples of: |
NoSQL databases. |
Access is a: |
DBMS for desktop PC systems. |
In clustering, a data mining tool will find: |
new groupings within data. |
MySQL is a: |
popular open-source DBMS. |
Data mining is more ________ than OLAP. |
discovery driven |
All of the following are tools or technologies for extracting information from unstructured data sets except: |
SQL queries. |
DBMS typically include report-generating tools in order to: |
display data in an easier-to-read-format. |
Which of the following database types would be best suited for storing multimedia? |
Non-relational DBMS |
Pre-configured hardware-software systems that use both relational and non-relational technology optimized for analyzing large datasets are referred to as: |
Analytic platforms. |
Which of the following statements about data warehouses is not true? |
Data warehouse systems provide easy-to-use tools for managers to easily update data. |
A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because: |
it typically focuses on a single subject area or line of business. |
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as: |
Business intelligence |
Which of the following enables users to view the same data in different ways using multiple dimensions? |
OLAP |
OLAP is a tool that enables users to: |
obtain online answers to ad hoc questions in a rapid amount of time. |
Data mining is a tool for allowing users to: |
find hidden relationships in data. |
In terms of the data relationships found by data mining, associations refers to: |
occurrences linked to a single event. |
In terms of the data relationships found by data mining, sequences refers to: |
events linked over time. |
Which of the following would you use to find patterns in user interaction data recorded by web servers? |
Web usage mining |
Which of the following would you use to find out which websites with content related to database design were the most often linked to by other websites? |
Web structure mining |
Businesses use ________ tools to search and analyze unstructured data sets, such as emails and memos. |
text mining |
Hadoop is a(n): |
open-source software framework designed for distributing data-processing over inexpensive computers. |
A data ________ stores current and historical data of potential interest to decision makers throughout the company. |
Warehouse |
A(n) ________ is a dedicated computer in a client/server environment that hosts a DBMS. |
Database server |
Which of the following is an example of a company whose business model is based on access to large databases through the web? |
|
Links pointing to an online document are a sign of: |
Popularity |
Links coming out of an online document are a sign of: |
richness or variety of topics covered. |
Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function. |
database administration |
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources. |
data redundancy |
Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: |
data scrubbing. |
A(n) ________ is a structured survey of the accuracy and level of completeness of the data in an information system. |
data quality audit |
Common data quality problems include all of the following except: |
Internet connectivity problems. |
MIS-Chapter 6
Share This
Unfinished tasks keep piling up?
Let us complete them for you. Quickly and professionally.
Check Price