MIS Chapter 3 Study Test

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Olgerthasko
O
Olgerthasko
Community Contributor
Quizzes Created: 4 | Total Attempts: 3,077
| Attempts: 2,276
SettingsSettings
Please wait...
  • 1/46 Questions

    _____ is the process of reinstalling the backup information in the event the information was lost.

    • Recovery
    • Recycling
    • Retrieval
    • Reproduction
Please wait...
About This Quiz

This quiz assesses knowledge in Management Information Systems (MIS), focusing on data security, OLAP applications, integrity constraints in databases, and primary key identification. It is designed to enhance decision-making and technical management skills relevant to information systems.

MIS Chapter 3 Study Test - Quiz

Quiz Preview

  • 2. 

    A(n) _____ helps you specify the logical organization for a database and access and use the information within a database.

    • DBMS

    • ERP

    • CRM

    • EIS

    Correct Answer
    A. DBMS
    Explanation
    A DBMS (Database Management System) is a software that helps in organizing and structuring a database, allowing users to efficiently access and utilize the information stored within it. It provides a set of tools and functionalities for creating, managing, and manipulating databases, ensuring data integrity, security, and efficient retrieval. With a DBMS, users can define the structure of the database, create tables, define relationships between tables, and perform various operations like querying, inserting, updating, and deleting data. Therefore, a DBMS is essential for specifying the logical organization of a database and facilitating easy access and utilization of information.

    Rate this question:

  • 3. 

    A(n) _____ is a field or group of fields that uniquely describes each record.

    • Identifying key

    • Relational key

    • Primary key

    • Main key

    Correct Answer
    A. Primary key
    Explanation
    A primary key is a field or group of fields that uniquely identifies each record in a database table. It is used to ensure the uniqueness and integrity of the data within the table. The primary key is crucial for maintaining data consistency and for establishing relationships between tables in a relational database. It allows for efficient searching, sorting, and indexing of records.

    Rate this question:

  • 4. 

    _____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions.

    • Query-by-example

    • Business intelligence

    • Information analysis

    • SQL

    Correct Answer
    A. Business intelligence
    Explanation
    Business intelligence refers to collective information that gives you the ability to make effective, important, and often strategic business decisions. It involves gathering and analyzing data from various sources to provide insights and support decision-making processes. Business intelligence tools and techniques help organizations to understand their market, competitors, customers, and internal operations better, thereby enabling them to make informed decisions that can drive growth and success.

    Rate this question:

  • 5. 

    What is the most popular model for creating databases?

    • Hierarchical database model

    • Object-oriented database model

    • Ecological database model

    • Relational database model

    Correct Answer
    A. Relational database model
    Explanation
    The relational database model is the most popular model for creating databases because it organizes data into tables with rows and columns, allowing for efficient storage and retrieval of information. This model uses relationships between tables, defined by keys, to establish connections and maintain data integrity. It provides a flexible and scalable structure, making it suitable for various applications and industries. Additionally, the relational model supports complex queries and allows for easy data manipulation and analysis, making it a preferred choice for database management systems.

    Rate this question:

  • 6. 

    A _____ is simply a copy of the information stored on a computer.

    • Photocopy

    • Replica

    • Duplicate

    • Backup

    Correct Answer
    A. Backup
    Explanation
    A backup is a duplicate copy of the information stored on a computer. It is created to ensure that data can be recovered in case of loss, damage, or accidental deletion. Backups are essential for protecting important files and preventing data loss.

    Rate this question:

  • 7. 

    _____ is the science of fact-based decision making.

    • Statistics

    • Synthesis

    • Analytics

    • Deduction

    Correct Answer
    A. Analytics
    Explanation
    Analytics is the science of fact-based decision making. It involves the use of data, statistical analysis, and mathematical models to extract insights and make informed decisions. By analyzing data, patterns and trends can be identified, allowing businesses and organizations to make strategic decisions and solve complex problems. Analytics helps in understanding customer behavior, optimizing processes, improving efficiency, and identifying opportunities for growth. It plays a crucial role in various industries, such as marketing, finance, healthcare, and sports, by providing valuable insights that drive decision-making processes.

    Rate this question:

  • 8. 

    Which data administration facility allows you to control who has access to what information and what type of access those people have?

    • Security management facilities

    • Query optimization facilities

    • Reorganization facilities

    • Concurrency control facilities

    Correct Answer
    A. Security management facilities
    Explanation
    Security management facilities allow you to control who has access to what information and what type of access those people have. These facilities provide the necessary tools and mechanisms to enforce security policies, manage user accounts, authenticate users, and grant or revoke privileges. By using security management facilities, organizations can ensure that only authorized individuals can access sensitive information and that they have the appropriate level of access based on their roles and responsibilities.

    Rate this question:

  • 9. 

    What must you define before adding any information to a relational database?

    • The intended audience

    • The physical hardware structure

    • The administrative rights of users

    • The logical structure of the database

    Correct Answer
    A. The logical structure of the database
    Explanation
    Before adding any information to a relational database, it is necessary to define the logical structure of the database. This includes determining the tables, relationships between tables, and the attributes or columns within each table. By defining the logical structure, it provides a framework for organizing and storing the data efficiently and accurately. It also helps ensure data integrity and allows for effective querying and retrieval of information from the database.

    Rate this question:

  • 10. 

    _____ facilities find the "shortest route" to the information you want so you don't have to.

    • Backup and recovery facilities

    • Query optimization facilities

    • Change management facilities

    • Concurrency control facilities

    Correct Answer
    A. Query optimization facilities
    Explanation
    Query optimization facilities are designed to find the most efficient way to retrieve information from a database. They analyze the structure of the query and the available indexes and statistics to determine the optimal execution plan. By doing so, they can minimize the time and resources required to retrieve the desired information, thus providing the "shortest route" to the information. This helps to improve the overall performance and efficiency of the database system.

    Rate this question:

  • 11. 

    If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) ____.

    • Identifying field

    • Relational field

    • Primary key

    • Principle key

    Correct Answer
    A. Primary key
    Explanation
    In a database, a primary key is a field or combination of fields that uniquely identifies each record. In this scenario, if the phone number is used as a unique identifier for customers in a clothing store, it would be considered a primary key. This means that each customer would have a different phone number associated with them, allowing for easy and accurate identification of individual customers.

    Rate this question:

  • 12. 

    A(n) _____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.

    • Hypercube

    • Digital dashboard

    • Intelligent agent

    • Neural network

    Correct Answer
    A. Digital dashboard
    Explanation
    A digital dashboard is a tool that presents information from multiple sources in a customized format for knowledge workers. It allows them to access and analyze key data in a user-friendly way, making it easier to make informed decisions and track progress towards goals. By displaying relevant information on a computer screen, a digital dashboard helps individuals stay organized and efficient in their work.

    Rate this question:

  • 13. 

    Which type of constraint ensures the quality of information in a relational database?

    • Environmental constraint

    • Business constraint

    • Integrity constraint

    • Production constraint

    Correct Answer
    A. Integrity constraint
    Explanation
    Integrity constraints are used to ensure the quality and accuracy of information in a relational database. These constraints define rules and restrictions on the data that is stored in the database, ensuring that it remains consistent and reliable. They enforce rules such as data type validation, uniqueness of values, referential integrity, and domain constraints. By enforcing these constraints, the integrity of the data is maintained, preventing inconsistencies and errors in the database.

    Rate this question:

  • 14. 

    A(n) _____ key is a primary key of one file that appears in another file.

    • Foreign

    • Secondary

    • Identifying

    • Duplicate

    Correct Answer
    A. Foreign
    Explanation
    A foreign key is a primary key of one file that appears in another file. This means that the foreign key in the second file references the primary key in the first file, creating a relationship between the two files. This relationship allows for data integrity and the ability to connect related information between the two files.

    Rate this question:

  • 15. 

    Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

    • Hierarchical

    • File-based

    • Relational

    • Conventional

    Correct Answer
    A. Relational
    Explanation
    A relational database model organizes and accesses information based on its logical structure rather than its physical structure. In a relational database, data is stored in tables with rows and columns, and relationships between tables are established using keys. This allows for efficient querying and manipulation of data, as well as flexibility in adding or modifying the structure of the database without affecting the data itself.

    Rate this question:

  • 16. 

    Which term refers to a specific piece of information that is stored in a database file?

    • Relation

    • Category

    • Class

    • Attribute

    Correct Answer
    A. Attribute
    Explanation
    An attribute refers to a specific piece of information that is stored in a database file. It represents a characteristic or property of an entity in the database. Attributes define the different types of data that can be stored in a database table, such as names, dates, numbers, or descriptions. By organizing data into attributes, databases can efficiently store and retrieve information based on specific criteria.

    Rate this question:

  • 17. 

    _____ are the technology tools that directly support OLTP.

    • OLAP and Hypercubes

    • Databases and DBMSs

    • EIS and DSS

    • CRM and ERP

    Correct Answer
    A. Databases and DBMSs
    Explanation
    Databases and DBMSs are the technology tools that directly support OLTP (Online Transaction Processing). OLTP involves managing and processing real-time transactions, such as sales, orders, and payments, in a database system. Databases store and organize the data, while DBMSs (Database Management Systems) provide the software and tools to manage and manipulate the data efficiently. Therefore, databases and DBMSs play a crucial role in supporting OLTP operations.

    Rate this question:

  • 18. 

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

    • Database

    • Data dictionary

    • Data mart

    • Data mine

    Correct Answer
    A. Database
    Explanation
    A database is a collection of information that is organized and accessed based on the logical structure of that information. It allows for efficient storage, retrieval, and manipulation of data, making it easier to manage and analyze large amounts of information. Databases are commonly used in various applications and industries to store and retrieve data in a structured and organized manner.

    Rate this question:

  • 19. 

    A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?

    • Online analytical processing (OLAP)

    • Geographic information systems (GIS)

    • Enterprise resource planning (ERP)

    • Decision support systems (DSS)

    Correct Answer
    A. Online analytical processing (OLAP)
    Explanation
    The senior manager in this scenario is analyzing internal and external information to analyze marketing campaigns and their effect on customer buying habits. This requires a tool that can handle large amounts of data and provide analytical capabilities. Online analytical processing (OLAP) is a type of application that allows users to analyze multidimensional data from different perspectives. It is specifically designed for complex analysis and reporting tasks, making it the most suitable option for the senior manager in this situation.

    Rate this question:

  • 20. 

    What type of software tool is used to query information stored in a data warehouse?

    • OLTP

    • Data dictionary

    • Data-mining

    • Decision support

    Correct Answer
    A. Data-mining
    Explanation
    Data-mining is the correct answer because it is a software tool used to query information stored in a data warehouse. Data-mining involves extracting patterns and valuable insights from large sets of data, allowing users to analyze and discover relationships, trends, and patterns within the data. This tool is specifically designed for decision support and helps organizations make informed business decisions based on the data stored in their data warehouse.

    Rate this question:

  • 21. 

    A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

    • Data mine

    • Data warehouse

    • Data dictionary

    • Data entry

    Correct Answer
    A. Data warehouse
    Explanation
    A data warehouse is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks. It is designed to store large amounts of historical and current data in a structured and optimized manner, allowing for efficient retrieval and analysis. The data warehouse consolidates data from various sources, cleanses and transforms it, and organizes it in a way that is conducive to reporting, analysis, and data mining. By providing a centralized and integrated view of data, a data warehouse enables businesses to make informed decisions based on accurate and consistent information.

    Rate this question:

  • 22. 

    Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

    • Strategic management

    • Database administration

    • Information resource planning

    • Operational planning

    Correct Answer
    A. Database administration
    Explanation
    Database administration is responsible for the more technical and operational aspects of managing information repositories. This function involves tasks such as designing, implementing, and maintaining databases, ensuring data security and integrity, and optimizing database performance. Database administrators also handle tasks like data backup and recovery, user access management, and troubleshooting database issues. They play a crucial role in ensuring that information repositories are well-managed and meet the organization's needs.

    Rate this question:

  • 23. 

    In a data warehouse, which data-mining tool would you use to quickly build reports without having to write programming code?

    • Application report generator

    • Artificial intelligence

    • Multidimensional analysis tools

    • Query-and-reporting tools

    Correct Answer
    A. Query-and-reporting tools
    Explanation
    Query-and-reporting tools are the data-mining tools that would be used to quickly build reports without having to write programming code in a data warehouse. These tools allow users to retrieve and analyze data from the warehouse using a user-friendly interface, eliminating the need for programming skills. They provide a simplified way to create and customize reports based on specific requirements, making them a convenient choice for non-technical users who need to generate reports efficiently.

    Rate this question:

  • 24. 

    _____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.

    • KPIs

    • DPIs

    • QBEs

    • SQLs

    Correct Answer
    A. KPIs
    Explanation
    KPIs, or Key Performance Indicators, are the most essential and important quantifiable measures used in analytics initiatives to monitor the success of a business activity. KPIs help organizations track progress towards their goals and objectives, providing a clear understanding of performance and identifying areas for improvement. They are specific, measurable, and relevant metrics that enable businesses to evaluate their performance and make data-driven decisions. DPIs, QBEs, and SQLs are not commonly used terms in the context of monitoring business success, making KPIs the correct answer.

    Rate this question:

  • 25. 

    If you were to perform a regression analysis, what type of data warehouse tool would it be?

    • Statistical

    • Multidimensional analysis

    • Production analysis

    • Hypercube

    Correct Answer
    A. Statistical
    Explanation
    A regression analysis is a statistical technique used to determine the relationship between a dependent variable and one or more independent variables. It involves analyzing the statistical significance of the coefficients to understand the impact of the independent variables on the dependent variable. Therefore, if you were to perform a regression analysis, you would require a statistical data warehouse tool that can handle the analysis and provide the necessary statistical calculations and outputs.

    Rate this question:

  • 26. 

    _____ ensure the validity of database updates when multiple users attempt to access and change the same information.

    • Backup and recovery facilities

    • Query optimization facilities

    • Change management facilities

    • Concurrency control facilities

    Correct Answer
    A. Concurrency control facilities
    Explanation
    Concurrency control facilities ensure the validity of database updates when multiple users attempt to access and change the same information. These facilities help in managing the simultaneous access and modification of data by multiple users, preventing conflicts and maintaining data integrity. They ensure that only one user can make changes to a particular piece of data at a time, thereby avoiding data inconsistencies and ensuring the accuracy and reliability of the database.

    Rate this question:

  • 27. 

    Which type of application requires that you know the physical location of information before you are able to access it?

    • CRM

    • ERP

    • Spreadsheets

    • Word processor

    Correct Answer
    A. Spreadsheets
    Explanation
    Spreadsheets require that you know the physical location of information before you are able to access it. In spreadsheets, data is organized in rows and columns, and each cell has a specific address or location. To access or retrieve data from a spreadsheet, you need to know the specific cell or range of cells where the information is located. This is different from other applications like CRM or ERP, where data is typically stored in a database and can be accessed through queries or search functions without the need to know the physical location.

    Rate this question:

  • 28. 

    Which application supports the manipulation of information to support decision making?

    • OLTP

    • CRM

    • ERP

    • OLAP

    Correct Answer
    A. OLAP
    Explanation
    OLAP (Online Analytical Processing) is the correct answer because it supports the manipulation of information to support decision making. OLAP allows users to analyze large amounts of data from various perspectives and dimensions, enabling them to make informed decisions based on the insights gained. It provides advanced data analysis capabilities such as multidimensional data modeling, data mining, and forecasting, which are essential for decision-making processes.

    Rate this question:

  • 29. 

    Which of the following functions plans for, oversees the development of, and monitors the information resource of an organization?

    • Data administration

    • Strategic management

    • Data manipulation

    • Operational planning

    Correct Answer
    A. Data administration
    Explanation
    Data administration is the correct answer because it involves planning for, overseeing the development of, and monitoring the information resource of an organization. This function ensures that the organization's data is properly managed, organized, and utilized to support its goals and objectives. It involves tasks such as data governance, data quality management, data security, and data lifecycle management. Data administration plays a crucial role in ensuring the effective and efficient use of data within an organization.

    Rate this question:

  • 30. 

    Databases that support OLTP are most often referred to as ____.

    • OLAP

    • Data warehouses

    • Relational databases

    • Operational databases

    Correct Answer
    A. Operational databases
    Explanation
    Databases that support OLTP (Online Transaction Processing) are commonly known as operational databases. These databases are designed to handle real-time transactional operations, such as inserting, updating, and deleting data. They are optimized for high-speed data processing and are typically used in day-to-day business operations where quick and frequent data access is required. OLAP (Online Analytical Processing) databases, on the other hand, are used for complex data analysis and reporting purposes. Data warehouses are large repositories of data that are used for decision-making and analytics. Relational databases are a type of database management system that organizes data into tables with predefined relationships.

    Rate this question:

  • 31. 

    _____ is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

    • Data mart

    • Data mine

    • Data dictionary

    • Database

    Correct Answer
    A. Data mart
    Explanation
    A data mart is a subset of a data warehouse that contains a focused portion of the data warehouse information. It is designed to serve the needs of a specific group or department within an organization. By keeping only relevant and necessary data in the data mart, it allows for easier and faster access to information for analysis and decision-making purposes. This helps to improve efficiency and effectiveness in addressing specific business requirements.

    Rate this question:

  • 32. 

    If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a _____ tool.

    • Data administration

    • Query-by-example

    • Data definition

    • Data manipulation

    Correct Answer
    A. Query-by-example
    Explanation
    If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a query-by-example tool. This tool allows users to retrieve data from a database by specifying examples or templates of the desired information. In this scenario, the tool would allow the user to input specific criteria or examples of student records and course records to generate schedules for the students.

    Rate this question:

  • 33. 

    SQL is:

    • A standardized fourth generation language found in most DBMSs.

    • A storage tool that holds the data and definitions for a database.

    • An administrative tool that allows you to set access rights for database users.

    • A programming language that can be used instead of a DBMS.

    Correct Answer
    A. A standardized fourth generation language found in most DBMSs.
    Explanation
    SQL (Structured Query Language) is a standardized fourth generation language found in most DBMSs (Database Management Systems). It is used for managing and manipulating relational databases. SQL allows users to create, modify, and retrieve data from databases. It provides a set of commands and syntax for performing various operations such as querying, inserting, updating, and deleting data. Being a standardized language, SQL is widely supported by different database systems, making it a common language for interacting with databases.

    Rate this question:

  • 34. 

    If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view is it?

    • Logical view

    • High-level view

    • Subjective view

    • Physical view

    Correct Answer
    A. Logical view
    Explanation
    A logical view of a database refers to the way in which data is organized and presented to users. It focuses on the conceptual representation of data, allowing users to see only the information they need in a format that is meaningful to them. This view abstracts the underlying physical structure of the database and provides a simplified and user-friendly interface for accessing and manipulating data. Therefore, if you can see only the necessary information in the desired format, it indicates that you are looking at a logical view of the database.

    Rate this question:

  • 35. 

    Which of the following is true of data administration and database administration?

    • Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data.

    • Data administration focuses on OLTP whereas database administration focuses on OLAP.

    • Data administration and database administration are terms that can be used interchangeably.

    • Data administration focuses on strategic management whereas database administration focuses on operational issues.

    Correct Answer
    A. Data administration focuses on strategic management whereas database administration focuses on operational issues.
    Explanation
    Data administration and database administration have distinct focuses. Data administration is concerned with strategic management, which involves setting policies, standards, and guidelines for the use and management of data within an organization. On the other hand, database administration deals with operational issues, such as ensuring the availability, performance, and security of the database system. These two roles complement each other in effectively managing and utilizing data within an organization.

    Rate this question:

  • 36. 

    What term is used to describe the use and distribution of information regardless of title or department?

    • Open source information

    • Info mining

    • Information sharing

    • Info distribution

    Correct Answer
    A. Information sharing
    Explanation
    Information sharing is the term used to describe the use and distribution of information regardless of title or department. It refers to the practice of sharing information among individuals and departments within an organization, as well as with external stakeholders. This allows for the free flow of information, promoting collaboration, transparency, and efficiency. By sharing information, organizations can harness the collective knowledge and expertise of their employees, leading to better decision-making and problem-solving.

    Rate this question:

  • 37. 

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

    • Online analytical processing (OLAP)

    • Business intelligence (BI)

    • File management systems (FMS)

    • Online transaction processing (OLTP)

    Correct Answer
    A. Online transaction processing (OLTP)
    Explanation
    Online transaction processing (OLTP) is the correct answer because it involves the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information. OLTP systems are designed for real-time transaction processing, such as recording sales, processing orders, or updating customer information. These systems are optimized for high-speed data entry and retrieval, ensuring that transactions are processed quickly and accurately. OLTP is commonly used in applications like banking, e-commerce, and inventory management, where real-time data processing is essential for business operations.

    Rate this question:

  • 38. 

    If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?

    • Logical view

    • Physical view

    • Stored view

    • Objective view

    Correct Answer
    A. Physical view
    Explanation
    A programmer would see the physical view of the database if they needed to view information as it is stored. The physical view represents how the data is actually stored on the disk, including the file structure, data organization, and storage details. It provides a low-level perspective of the database, allowing programmers to understand and work with the underlying storage structure. This view is important for tasks such as optimizing performance, managing disk space, and troubleshooting issues related to the physical storage of the data.

    Rate this question:

  • 39. 

    If the file containing your student information appears in two different places with two different birth dates, your data would not be considered ____.

    • Legitimate

    • Valid

    • Clean

    • Acceptable

    Correct Answer
    A. Clean
    Explanation
    If the file containing the student information appears in two different places with two different birth dates, it indicates that there may be inconsistencies or errors in the data. In this context, the term "clean" refers to data that is accurate, consistent, and free from any discrepancies or anomalies. Therefore, if the data is not clean, it cannot be considered reliable or trustworthy.

    Rate this question:

  • 40. 

    A data warehouse is:

    • A large hardware environment that supports multiple platforms.

    • A logical collection of information used to create business intelligence.

    • An operational database system used to manage and analyze transactional data.

    • An accumulation of all operational data stored by large organizations.

    Correct Answer
    A. A logical collection of information used to create business intelligence.
    Explanation
    A data warehouse is a logical collection of information used to create business intelligence. This means that it is not a physical hardware environment or an operational database system. Instead, it is a centralized repository where data from various sources is stored, organized, and transformed into a format that is optimized for reporting and analysis. The purpose of a data warehouse is to provide a unified view of data from different systems and enable organizations to gain insights and make informed decisions based on that data.

    Rate this question:

  • 41. 

    Which data manipulation tool allows you to graphically design the answer to your business questions?

    • Report generators

    • Application reports

    • Query-by-example tools

    • Data administration tools

    Correct Answer
    A. Query-by-example tools
    Explanation
    Query-by-example tools allow users to graphically design the answer to their business questions. These tools provide a user-friendly interface where users can specify their criteria and conditions using a graphical representation, rather than writing complex queries or code. This makes it easier for non-technical users to manipulate and analyze data, as they can visually design their queries and see the results in real-time. Query-by-example tools are commonly used in business intelligence and data analysis to quickly and efficiently retrieve and analyze data.

    Rate this question:

  • 42. 

    Which part of a relational database contains the logical structure for the information?

    • Data dictionary

    • Relation

    • Query

    • SQL

    Correct Answer
    A. Data dictionary
    Explanation
    A data dictionary is a part of a relational database that contains the logical structure for the information. It serves as a repository for metadata, providing information about the database such as the names, definitions, and relationships of the tables, columns, and constraints. The data dictionary helps in maintaining data integrity, ensuring that the database remains consistent and accurate. It is used by database administrators, developers, and users to understand the structure and organization of the database, making it an essential component for managing and accessing data effectively.

    Rate this question:

  • 43. 

    What does it mean for a data warehouse to be multidimensional?

    • The database stores data, facts, and definitions for all stored information.

    • Data can be linked to other sources of internal and external information.

    • The files stored in a warehouse contain several layers of columns and rows.

    • Customer information can be related to sales, departmental, and organizational information.

    Correct Answer
    A. The files stored in a warehouse contain several layers of columns and rows.
    Explanation
    A multidimensional data warehouse refers to the structure of the files stored in the warehouse, which contain several layers of columns and rows. This means that the data is organized in a way that allows for analysis and reporting across multiple dimensions, such as time, geography, and product categories. This structure enables users to easily navigate and explore the data from different perspectives, facilitating complex queries and generating meaningful insights.

    Rate this question:

  • 44. 

    Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

    • Query reporting tools

    • SQL reports

    • Report generators

    • Application reports

    Correct Answer
    A. Report generators
    Explanation
    Report generators are data manipulation tools that allow users to quickly define the formats of needed business reports from information stored in a database. These tools provide a user-friendly interface that allows users to easily select the desired data fields, apply filters, and customize the layout and formatting of the reports. With report generators, users can generate reports that meet their specific business requirements without the need for complex coding or SQL queries.

    Rate this question:

  • 45. 

    Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

    • Security management facilities

    • Query optimization facilities

    • Reorganization facilities

    • Concurrency control facilities

    Correct Answer
    A. Reorganization facilities
    Explanation
    Reorganization facilities in a DBMS continually maintain statistics concerning how the DBMS engine physically accesses information. These facilities are responsible for optimizing the physical storage and layout of data in the database, ensuring efficient access and retrieval. By monitoring and analyzing the access patterns and performance of the database engine, reorganization facilities can make recommendations for restructuring the data to improve overall system performance. This includes tasks such as reorganizing indexes, redistributing data, and optimizing storage allocation.

    Rate this question:

  • 46. 

    Data warehouses exist to support:

    • MRP

    • OLAP.

    • OLTP.

    • SQL.

    Correct Answer
    A. OLTP.
    Explanation
    Data warehouses exist to support OLAP (Online Analytical Processing). OLAP is a type of software that enables users to analyze multidimensional data from different perspectives. It allows for complex queries and aggregations, making it ideal for decision-making and business intelligence purposes. On the other hand, OLTP (Online Transaction Processing) is a type of software that supports transaction-oriented applications, such as order processing and inventory management. While data warehouses may interact with OLTP systems to extract data, their main purpose is to store and organize data for OLAP analysis. Therefore, OLTP is the correct answer.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 13, 2012
    Quiz Created by
    Olgerthasko
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.