logo image

Bus 3500 Exam 1-MIS

a grouping of characteristics into a word, a group of words is called a record.
True
each characteristic or quality describing a particular entity is called an attribute
True
every record in a file should contain at least one key field
True
In normalization, complex groupings of data are streamlined to eliminate awkward
many-to-many relationships.
True
Many applications today require databases that can store and retrieve multimedia.
True
One of the drawbacks to OODBMS is that they cannot work with applets.
False
OODBMS are slower than relational DBMS.
True
A data warehouse may include information from legacy systems.
True
A data warehouse is typically comprised of several smaller data marts
False
DBMS simplify how end users work with databases by separating the logical and physical views
of the data.
True
OLAP is a key tool of BI.
True
OLAP is used to find hidden patterns and relationships in large databases, and infer rules from
these to infer future behavior.
False
Data mining can be a challenge to individual privacy.
True
Predictive analysis is a technique of data mining.
False
Implementing a Web interface for a database requires changes to the database itself.
False
Common Gateway Interface is a specification for processing data on a Web server.
True
In linking databases to the Web, the role of the application server is to host the DBMS.
False
A firm’s information policy lays out who is responsible for updating and maintaining the
information in a database system.
True
The use of different terms for identifying data in a firm?s various information systems is an
example of redundant data.
True
Data cleansing is the same process as data scrubbing.
True
Which of the following is not a true statement about MDM?
It is a quality-of-data concept that is used to identify a company?s most important data.
What is the first step you should take in managing data for a firm?
Identify the data needed to run the business
An example of a pre-digital database is a:
library’s card-catalog
Which of the following best illustrates the relationship between entities and attributes?
The entity CUSTOMER with the attribute ADDRESS
The type of logical database model that treats data as if they were stored in two-dimensional
tables is the:
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, products, 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.
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 is not a typical feature of DBMS?
Query wizard tool
Oracle Database Lite is a:
DBMS for small handheld computing devices.
Access is a
DBMS for desktop systems
My SQL is a:
popular open-source DBMS.
Microsoft SQL Server is a(n):
DBMS for midrange computers.
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 meets stated criteria.
The join operation:
combines relational tables to provide the user with more information than is otherwise
available
The project operation:
creates a subset consisting of columns in a table.
The data dictionary serves as an important data management tool by:
creating an inventory of data definitions contained in the database.
A n automated or manual file that stores information about data elements and data
characteristics such as usage, physical representation, ownership, authorization, and security is
the:
data dictionary.
The specialized language programmers use to add and change data in the database is called:
data definition language.
The most prominent data manipulation language today is:
SQL
DBMS typically include report-generating tools in order to:
display data in an easier-to-read format
The type of database management approach that can handle multimedia is the:
object-oriented DBMS.
Which of the following database types is useful for storing Java applets as well as handling large
numbers of transactions?
OODBMS
A data warehouse is composed of:
both historical and current data.
W hich 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.
The tool that enables users to view the same data in different ways using multiple dimensions is:
OLAP.
OLAP is a tool for enabling:
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
An alternative to using application server software for interfacing between a Web server and
back-end databases is:
HTML.
Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and
memos
Text mining
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
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 Web sites with content related to
database design were the most often linked to by other Web sites?
Web structure mining
What is the Primary Key of the Animals Table?
Pet Number
What is the Foreign Key of the Owners Table?
No Foreign Key Exists
What is the Primary Key of the Animal Owners Table?
Combined Key (Pet Number and Owner ID)
What are the Foreign Key(s) of the Animal Owners Table?
Both Pet Number and Owner ID
No Repeating Elements or Groups of Elements describes which Normal Form?
First Normal Form
No Partial Dependencies on a Concatenated Key describes which Normal Form?
Second Normal Form
No Dependencies on Non-Key Attributes describes which Normal Form?
Third Normal Form
The database table below is normalized to what normal form?
Tables that contain a Concatenated Primary Key and fields that rely on only part of the key, fail the test for which Normal Form?
Second Normal Form
What Normal Form process rids the database of repeating elements?
First Normal Form
Which data type should be used for a field containing zip code data in access
Text
Which data type should be used for a field containing Price data in Access
Currency
Which data type should be used for a field containing street address data in access?
Text
Which data type should be used for a field containing E numbers in Access?
Text
What type of key should be used for linking a table?
Foreign Key

Need essay sample on "Bus 3500 Exam 1-MIS"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy