Is an information analysis tool that involves the automated discovery of patterns and relationships in a data warehouse?

focusNode

Inhaltsverzeichnis Show

What is the process that is used to find patterns and relationships among data in large databases?
Is a collection of instructions and commands used to define and describe data and relationships in a specific?
What is a special purpose programming language for assessing and manipulating data stored in a relational database?
Is a database that holds business information from many sources in the enterprise covering all aspects of the company's processes products and customers?

Didn't know it?
click below

Knew it?
click below

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

flashcards

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

What is the process that is used to find patterns and relationships among data in large databases?

Data mining is the process of sorting through large data sets to identify patterns and relationships that can help solve business problems through data analysis. Data mining techniques and tools enable enterprises to predict future trends and make more-informed business decisions.

Is a collection of instructions and commands used to define and describe data and relationships in a specific?

Data definition language (DDL) a collection of instructions and commands used to define and describe data and data relationships in a specific database. Data dictionary. a detailed description of all data used in the database.

What is a special purpose programming language for assessing and manipulating data stored in a relational database?

SQL is a declarative programming language designed to store, retrieve, manage or manipulate data within a Relational Database Management System.

Is a database that holds business information from many sources in the enterprise covering all aspects of the company's processes products and customers?

A data warehouse is a database that holds business information from many sources in the enterprise, covering all aspects of the company's processes, products, and customers.

Is an information analysis tool that involves the automated discovery of patterns and relationships in a data warehouse?

flashcards

What is the process that is used to find patterns and relationships among data in large databases?

Is a collection of instructions and commands used to define and describe data and relationships in a specific?

What is a special purpose programming language for assessing and manipulating data stored in a relational database?

Is a database that holds business information from many sources in the enterprise covering all aspects of the company's processes products and customers?

zusammenhängende Posts

What is an measure of the sensitivity of demand to a change in another variable?

What term is used to describe the discovery collection and analysis of evidence?

Winrar das archiv hat entweder ein unbekanntes format oder ist beschädigt

Which information must match on the patients ID band and the requisition quizlet?

Which of the following are underlying assumptions of cost volume profit analysis?

Younger adults are less able to ignore distracting information than older adults.

Which directory in the Linux root directory contains a file that contains information about the CPU S?

Which of the following are components of a SWOT analysis choose every correct answer quizlet?

Elston company compiled the following financial information as of december 31, 2022:

Which of the following represents the steps in the information processing theory?

Werbung

NEUESTEN NACHRICHTEN

Which incentive plans are specifically designed to promote group performance

According to the flsa, which individual is most likely a nonexempt employee?

Reactive and protective behaviors designed to avoid action, blame, or change are termed ________.

The machiavellian personality is characterized by the will to manipulate and the desire for power.

Ist ein mann in brunn gefallen noten

Which of the following biometric authentication systems is the most accepted by users?

Was ist der Unterschied zwischen Hanf und CBD?

Wie viele noten braucht man für eine zeugnisnote sachsen-anhalt

Wie fühlt man sich wenn man schwanger ist am anfang

Kann man Basaltemperatur auch tagsüber Messen?

Werbung

Populer

Werbung

Um

Legal

Hilfe

Sozial