Principles of Information Systems 12th Edition by Ralph Stair - Test Bank Instant Download - Complete Test Bank With Answers Sample Questions Are Posted Below 1. A database, a database management system, and the application programs that use the data make up a database environment. a. True b. False …
$19.99
Principles of Information Systems 12th Edition by Ralph Stair – Test Bank
Instant Download – Complete Test Bank With Answers
Sample Questions Are Posted Below
1. A database, a database management system, and the application programs that use the data make up a database environment.
|
2. A field is typically a name, number, or combination of characters that describes an aspect of a business object.
|
3. A collection of data fields all related to one object, activity, or individual is called a file.
|
4. An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.
|
5. The specific value of an attribute is called a data entity.
|
6. Two sets of fields can have a common primary key.
|
7. Often, distinct yet related databases are linked to provide enterprise-wide databases.
|
8. Today, most organizations use the traditional approach to data management, where multiple information systems share a pool of related data.
|
9. To use the database approach to data management, no additional software is required.
|
10. A database must reflect the business processes of an organization.
|
11. When organizing a database, one of the key considerations includes determining who will have access to the collected data.
|
12. A data model is a diagram of data attributes and their relationships.
|
13. The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.
|
14. In the relational model, each row in a table represents an entity, and each column represents an attribute of that entity.
|
15. Oracle is currently the market leader in general purpose databases, with about three-fourths of the multibillion dollar database market.
|
16. In the context of relational database model, selecting involves combining two or more tables.
|
17. In the context of relational database model, projecting involves eliminating columns in a table.
|
18. One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.
|
19. The relational database model is currently the most widely used.
|
20. A database management system (DBMS) serves as an interface between an application program and a database.
|
21. One of the final steps in installing and using a large database involves “telling” the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.
|
22. A database administrator is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.
|
23. A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.
|
24. Unstructured data comes from sources such as word-processing documents and scientific research.
|
25. A data warehouse stores historical data that has been extracted from operational systems and external sources.
|
26. Online analytical processing involves the automated discovery of patterns and relationships in a data warehouse.
|
27. Online analytical processing and data mining are essentially the same thing.
|
28. Predictive analysis is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.
|
29. Competitive intelligence is espionage.
|
30. Counterintelligence turns data into useful information that is kept closely guarded to avoid this information from falling into the hands of the wrong employees.
|
31. Which of the following statements is true of a database?
|
32. The smallest piece of data used by a computer is a(n) _____.
|
33. A database is a collection of integrated and related _____.
|
34. A collection of fields all related to a single object, activity, or individual is a(n) _____.
|
35. A(n) _____ is a field or set of fields in a record that uniquely identifies the record.
|
36. _____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.
|
37. Each attribute in a relational database model can be constrained to a range of allowable values called a _____.
|
38. Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.
|
39. As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.
|
40. A _____ is a simple database program whose records have no relationship to one another.
|
41. _____ is a special-purpose programming language for accessing and manipulating data stored in a relational database.
|
42. A _____ is a description that involves “telling” the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.
|
43. A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
|
44. The position of a _____ is a nontechnical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.
|
45. Some databases use ______, which is a visual approach to developing queries and requests.
|
46. With _____, the database is stored on a service provider’s server and accessed by the client over a network, typically the Internet.
|
47. _____ is the term used to describe enormous and complex data collections that traditional data management software, hardware, and analysis processes are incapable of dealing with them.
|
48. Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.
|
49. A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.
|
50. _____ is an information-analysis tool that involves the automated discovery of patterns and relationships in a data warehouse.
|
51. ______ is a form of database processing that supports top-down, query-driven data analysis.
|
52. _____ is a form of data mining that combines historical data with assumptions about future conditions to forecast the outcomes of events.
|
53. Social graph analysis is a(n) _____ technique in which data is represented as networks where the vertices are the individual data points (social network users) and the edges are the connections among them.
|
54. _____ are quantifiable measurements that assess progress toward organizational goals and reflect the critical success factors of an organization.
|
55. The term _____ describes the steps an organization takes to protect information sought by “hostile” intelligence gathers.
|
56. Most of the data that an organization must deal with is _____ data, meaning that it is not organized in any predefined manner.
|
57. A(n) ______ consists of a group of programs that manipulate the database and provide an interface between the database and its users and other application programs.
|
58. Together, bits, characters, fields, records, files, and databases form the ______.
|
59. A collection of related records is called a(n) _____.
|
60. A(n) _____ is a field or set of fields that uniquely identifies a record.
|
61. A(n) _____ is a diagram of entities and their relationships.
|
62. Data modeling done at the level of an entire enterprise is called _____.
|
63. ______ use basic graphical symbols to show an organization of and relationships between data.
|
64. The _____ model has become the most popular database model.
|
65. In the relational database model, each row of a table represents a(n) _____.
|
66. Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, MySQL, and Sybas are databases based on the _____ model.
|
67. In a relational database model, the range of allowable values for a data attribute is called its _____.
|
68. In a relational database model, _____ involves combining two or more tables.
|
69. _____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.
|
70. A description that tells the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user is called a(n) _____.
|
71. A(n) _____ is a collection of instructions and commands used to define and describe data and relationships in a specific database.
|
72. A(n) _____ is a detailed description of all data used in a database.
|
73. _____ is a method of dealing with a situation in which two or more users or applications need to access the same record at the same time.
|
74. A(n) _____ is designed to store and retrieve data in a manner that does not rigidly enforce the atomic conditions associated with the relational database model in order to provide faster performance and greater scalability.
|
75. The _____ is a specific language, provided with a database management system (DBMS) that allows users to access and modify the data, to make queries, and to generate reports.
|
76. A(n) ______ is an individual who is expected to have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.
|
77. A(n) ______ is an individual responsible for defining and implementing consistent principles for a variety of data issues.
|
78. In the context of a database management system (DBMS), a(n) _____ interacts with other programs or applications and only indirectly interacts with people or users.
|
79. A(n) _____ is a database management system that stores the entire database in random access memory (RAM).
|
80. A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.
|
81. Briefly describe the hierarchy of data.
|
82. Differentiate between the traditional and the database approach to data management.
|
83. Briefly describe the relational database model.
|
84. Describe business intelligence (BI).
|
85. Explain entity-relationship (ER) diagrams.
|
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
Original price was: $30.00.$20.00Current price is: $20.00.
