Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Chapter 5

flashcards

questionsanswers
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
Created by: zaltman
 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards