| questions | answers |
| 1. A(n) ____ is a group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs.
DBA
DBMS
IS
DBS | DBMS |
| 2. A(n) ____ is a skilled IS professional who directs all activities related to an organization's database.
DBA
DBMS
IDBP
DBS | DBA |
| 3. A ____ is the basic building block of information, consisting of uppercase letters, lowercase letters, numeric digits, or special symbols.
field
character
record
file | character |
| 4. A ____ is a collection of related data fields.
character
record
file
character | record |
| 5. A(n) ____ is a generalized class of people, places, or things for which data is collected, stored, and maintained.
field
entity
data item
attribute | entity |
| 6. A(n) ____ is a field or set of fields that uniquely identifies the record.
attribute
primary key
entity
data item | primary key |
| 7. The ____ approach to data management is an approach whereby each distinct operational system uses data files dedicated to that system.
standard
traditional
database
object oriented | traditional |
| 8. The ____ approach to data management is an approach whereby a pool of related data is shared by multiple application programs.
object oriented
database
standard
traditional | database |
| 9. The ____ of a database shows an abstract model of how the data should be structured and arranged to meet an organization's information needs.
logical design
physical design
virtual design
object oriented view | logical design |
| 10. ____ is a way of organizing data in which the logical database design= certain data entities are combined, summary totals carry ... to improve database performance.
Data modeling
Planned data redundancy
Enterprise data modeling
Data planning | Planned data redundancy |
| 11. ____ diagrams are data models that use basic graphical symbols to show the organization of and relationships between data.
Enterprise-resource
Enterprise-relationship
Entity-relationship
Database | Entity-relationship |
| 12. ____ diagrams help ensure that the relationships among the data entities = any application programs developed are consistent with business operations and user needs.
Enterprise-resource
Enterprise-relationship
Entity-relationship
Database | Entity-relationship |
| 13. The ____ is a database model that describes data in which all data elements are placed in two-dimensional tables.
database model
procedural model
relational model
object-oriented model | relational model |
| 14. The ____ for a particular attribute indicates what values can be placed in each of the columns of the relational table.
field
entity
data
domain | domain |
| 15. ____ refers to data manipulation that combines two or more tables.
Selecting
Projecting
Joining
Linking | Joining |
| 16. ____ refers to data manipulation that eliminates columns in a table.
Selecting
Joining
Projecting
Linking | projecting |
| 17. ____ refers to data manipulation that combines two or more tables using common data attributes to form a new table with only the unique data attributes.
Selecting
Projecting
Linking
Joining | Linking |
| 18. ____ is the process of looking for and fixing inconsistencies to ensure that data is accurate and complete.
Data cleanup
Data integrity
Data checking
Data entry | Data cleanup |
| 19. A ____ is a simple database program whose records have no relationship to one another.
single user database
relational database
multi-user database
flat file | flat file |
| 20. Microsoft Access and FileMaker Pro are examples of popular ____ DBMSs.
flat file
single-user
multiuser
standard | single-user |
| 21. A(n) ____ is a description of the entire database.
data model
schema
entity
key | schema |
| 22. A ____ is a collection of instructions and commands used to define and describe data and data relationships in a specific database.
database
data dictionary
data definition language
data manipulation language | data definition language |
| 23. ____ results in a more efficient use of system storage space.
Reduced data redundancy
Faster program development
Increased data reliability
Easier modification of data and information | Reduced data redundancy |
| 24. ____ is a method of dealing with a situation in which two or more people need to access the same record in a database at the same time.
Querying
Record protection
Concurrency control
Database management | Concurrency control |
| 25. ____ is a visual approach to developing database queries or requests.
Data cleanup
Data mining
Query by Example
Predictive analysis | Query by Example |
| 26. ____ refers to the commands that are used to manipulate the data in a database.
DML
DDL
QBE
DAL | DML |
| 27. In 1986, the American National Standards Institute (ANSI) adopted ____ as the standard query language for relational databases.
Java
C++
SQL
XML | SQL |
| 28. The ____ features of a database program allow you to select the records and fields to appear in reports.
input-control
report-control
output-control
summary-control | output control |
| 29. A ____ is a nontechnical position responsible for defining and implementing consistent principles for a variety of data issues.
database programmer
data programmer
database administrator
data administrator | database administrator |
| 30. ____ directly interact with people or users.
Front-end applications
Servers
Back-end applications
Mainframes | Front-end application |
| 31. Developing a seamless integration of traditional databases with the Internet is often called a(n) ____.
semantic database
integrated Web
semantic web
integrated database | semantic web |
| 32. A(n) ____ is a database that collects business information from many sources in the enterprise, covering all aspects of the company's processes,.
data warehouse
data mart
data mine
products, and customers
OLTP | products, and customers |
| 33. OLTP ____ and ____.
read and write data access for users; detailed transactions
read-only data access for users; detailed transactions | read and write data access for users; detailed transactions |
| 34. ____ put targeted business information into the hands of more decision makers.
Data mines
Data warehouses
Data marts
Data stores | Data marts |
| 35. ____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.
Data mining
Data manipulation
Data warehousing
Data cleanup | Data mining |
| 36. ____ bring the data warehouse concept—online analysis of sales,... that has been gathered from transaction processing systems—to small businesses and to departments within larger companies.
Data mines
Data warehouses
Data stores
Data marts | Data marts |
| 37. ____ is used in data-mining applications to groups customers based on who they are or on what they prefer.
Customer churn
Market basket analysis
Trend analysis
Market segmentation | Data marts |
| 38. ____ is t right information in a timely manner and usable form and analyzing it to have a positive impact on business strategy, tactics, or operations.
Business intelligence
Trend analysis
Knowledge management
Market analysis | Business intelligence |
| 39. ____ is one aspect of business intelligence that is limited to information about competitors and the ways that knowledge affects strategy, tactics, and operations.
Counterintelligence
Business intelligence
Knowledge management
Competitive intellig | Competitive intelligence |
| 40. The term ____ describes the steps an organization takes to protect information sought by “hostile” intelligence gatherers.
competitive intelligence
business intelligence
counterintelligence
knowledge management | counterintelligence |
| 41. ____ refers to systems designed to lock down data within an organization.
Data loss prevention
Predictive analysis
Business intelligence
Knowledge management | Data loss prevention |
| 42. A ____ is a database in which the data may be spread across several smaller databases connected via telecommunications devices.
spread database
relational database
distributed database
replicated database | distributed database |
| 43. A ____ is a database that holds a duplicate set of frequently used data.
spreadsheet database
distributed database
relational database
replicated database | replicated database |
| 44. ____ refers to software that allows users to explore data from a number of different perspectives.
Data mining
OTLP
OLAP
ODBC | OLAP |
| 45. A(n) ____ is a database that stores both data and its processing instructions.
relational database
flat file database
object-oriented database
single-user database | object-oriented database |
| 46. A(n) ____ is a DBMS capable of manipulating audio, video, and graphical data.
ORDBMS
OODBMS
AVDBMS
GRDBMS | ORDBMS |
| 47. ____ involves the use of a database to store and access data according to the locations it describes and to permit spatial queries and analysis.
Data mining
Spatial data technology
Virtual database systems
Location dependent data technology | Spatial data technology |
| 48. ____ is used to make sure that replicated databases are accurate, up to date, and consistent with each other.
Data synchronization
Data warehousing
Data replication
Data mining | Data synchronization |
| 49. Companies such as IBM have developed ____ to allow different databases to work together as a unified database system.
integrated information systems
relational management systems
communication systems
virtual database systems | virtual database systems |
| 50. ____ be used to improve financial risk management with information stored by investment type, currency type, interest rates, and time.
Data mining
Spatial data
Virtual database systems
Location dependent data technology | Spatial data |
