Mathematic

Q: _____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

Q: A(n) _____ is a primary key from one table placed within a second table to establish a relationship between the two tables.

Q: The term relation often describes each _____ table or file in the relational model.

Q: The _____ uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Q: A(n) _____ is a collection of information that you organize and access according to the logical structure of that information.

Q: A(n) _____ contains the logical structure for the information.

Q: A primary key field cannot be _____.

Q: A(n) _____ allows you to specify the logical organization for a database and access and use the information within a database.

Q: The _____ helps you add, change, and delete information in a database and mine it for valuable information.

Q: A(n) _____ allows you to see the contents of a database file, make whatever changes you want, perform simple sorting, and query to find the location of specific information.

Q: A(n) _____ defines formats of reports and what information you want to see in a report.

Q: Data administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

Q: There is no way to examine the impact of proposed changes on an existing database.

Q: Data warehouses always uses 2D tables to store data.

Q: A data warehouse is a logical collection of information gathered from many different operational databases used to create business intelligence that supports business analysis activities and decision-making tasks.

Q: A hypercube is a two-dimensional representation of information.

Q: Data warehouses support transaction processing.

Q: Data-mining tools support the concept of OLTP in manipulating information to support decisions.

Q: Multidimensional analysis (MDA) tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

Q: A data mart is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

Q: An intelligent agent utilizes artificial intelligence to "discover" information in data warehouses.

Q: Intelligent agents are used in OLAP and in online searching.

Q: Data marts focus on the entire organization, while data warehouses focus on specific needs.

Q: Structured query language (SQL) is a standardized first-generation query language found in most DBMSs.

Q: There can be duplicate primary keys in the same file in a database.

Q: QBE allows you to query by pointing, clicking, and dragging, unlike SQL.

Q: Foreign keys uniquely identify records.

Q: The data dictionary includes query optimization facilities.

Q: A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Q: Query optimization facilities are used to create backups just in case the database is damaged or lost.

Q: If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database, the database will typically generate an error message. This message indicates that an integrity constraint has been violated.

Q: Database security and network security are the same thing.

Q: A physical view represents how the users view the data.

Q: The acronym DBMS stands for Database Marketing System and is a type of database designed to support the marketing function within a business.

Q: A database management system (DBMS) allows you to specify the logical organization for a database and access and use the information within a database.

Q: The logical view of information focuses on how you arrange and access information to meet the needs of the business.

Q: If you need to add a new field to a database, you would use the data manipulation system.

Q: The data manipulation subsystem is often the interface between the user and the information contained in the database.

Q: Report generators help you quickly define formats of reports and what information you want to see in a report.

Q: Query-by-example (QBE) tools help you graphically design the answer to a question.

Q: The data administration subsystem is used to create the data dictionary.

Q: Backup and recovery facilities are included in the data administration subsystem.

Q: The data definition subsystem includes security management facilities.

Q: Which organizational function is responsible for the more technical and operational aspects of managing information repositories? A.Database administration B.Strategic management C.Information resource planning D.Operational planning

Q: A primary key must consist of one and only one field.

Q: Which organizational function is responsible for developing security procedures for an organization? A.Data security B.Data protection C.Information resource management D.Database administration

Q: What is the difference between data administration and database administration? A.Data administration focuses on strategic management whereas database administration focuses on operational issues B.Data administration focuses on OLTP whereas database administration focuses on OLAP C.Data administration and database administration are terms that can be used interchangeably D.Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data

Q: What is the term used to describe the sharing of information regardless of title or department. A.Open source B.Data mining C.Information sharing D.Data distribution

Q: A key consideration in today's business environment is ______ or the assigning of responsibility for ensuring the quality of information. A.Accountability B.Information ownership C.Data security D.Data management and control

Q: If your student information had two different birth dates for you, your data would not be considered _____.A.LegitimateB.CorrectC.CleanD.Acceptable

Q: Business intelligence is knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations.

Q: Operational databases are databases that support OLAP.

Q: Online analytical processing (OLAP) is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

Q: If an employee needs to change the details of a specific customer order, he/she would use OLTP (online transaction processing).

Q: XYZ, Corp. would like to determine advertising strategies for customers who buy high-priced products. It would use OLTP on its data warehouse.

Q: A database is a collection of information that you organize and access according to the logical structure of that information.

Q: A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

Q: Assume you have an order entry database with an Order file and a Customer file. The Order Date field most likely would be the common field used to relate the two files.

Q: A database actually consists of three parts: information, the logical structure of that information, and tables.

Q: Which of the following functions plans for, oversees the development of, and monitors the information resources of an organization? A.Data administration B.Strategic management C.Information resource planning D.Operational planning

Q: A data dictionary is a two-dimensional table used to store data within a relational database.

Q: What type of software tool is used to query information stored in a data warehouse? A.OLTP B.Analytical C.Data-mining D.Decision support

Q: Data-mining tools include all but which of the following? A.Query-and-reporting B.Intelligent agents C.Data manipulation D.Statistical

Q: In a data warehouse, which tool would you use to build reports quickly and without having to write programming code? A.Application generator B.Intelligent agents C.Multidimensional analysis tools D.Query-and-reporting tools

Q: In a data warehouse, which artificial intelligence tools allows you to discover information and build intelligence? A.Query-by-example B.Query-and-reporting C.Hypercube D.Intelligent agent

Q: Which data warehouse tools are slice-and-dice techniques that allow you to view multidimensional information from different perspectives? A.Query-and-reporting B.Intelligent agents C.OLTP D.Multidimensional analysis

Q: If you were viewing information from different perspectives, you would be _____. A.Turning the cube B.Making decisions C.Creating hyperlinks D.Applying fuzzy logic

Q: What is the difference between multidimensional analysis and statistical analysis? A.Multidimensional analysis is a higher level of mathematical analysis than normal statistical analysis B.Multidimensional analysis uses a form of fuzzy logic whereas statistical analysis is objective C.Statistical analysis requires a step-by-step approach to data analysis; multidimensional analysis does not D.Statistical analysis is a mathematical approach to understanding information; multidimensional analysis is a way of viewing information from different perspectives

Q: If you were to perform a regression analysis, what type of data warehouse tool would you use? A.Statistical B.Multidimensional analysis C.Production analysis D.Hypercube

Q: Which of the following contains a subset of a data warehouse in which only a focused portion of the data is kept? A.Data mart B.Intelligent agent C.Business intelligent subsystem D.Operational database

Q: Which of the following is a smaller, more focused data warehouse? A.Data warehouse B.Data mart C.Operational database D.OLAP

Q: If you were working for a large pharmaceutical company and building a sales report on current prescription writing habits of doctors, what type of information repository would you be most likely working with? A.Data warehouse B.Operational database C.Transactional database D.Data mart

Q: If you were comparing information from various divisions of an organization for instance, sales, marketing, and production, what type of information repository would you most likely work with? A.Data mart B.Data warehouse C.Hypercube database D.Data mining

1 2 3 … 39 Next »

Subjects