flashcards
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
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
Normal Size Small Size show me how
Created by:
zaltman