Information and Database MCQs – CISA

Share on facebook
Share on twitter
Share on linkedin
Share on pinterest
Share on reddit
Share on whatsapp

SHARE THIS

Database – is defined as a collection of structured data. Its structure is determined by the data themselves rather than the needs of a particular software
Information and Database MCQs

Information and Database MCQs

Database – is defined as a collection of structured data. Its structure is determined by the data themselves rather than the needs of a particular software application or group of users. Here on MCQs.club we have written easy Multiple-Choice Questions on Information and Database, that fully cover MCQs on Database management System Multiple Choice Questions with Answers, Database mcqs, DBMS mcqs. These DBMS MCQ Questions with Answers are useful for Business management exams, Professional Accountancy exams and Competitive exams.

  1. Database – is defined as a collection of structured data. Its structure is determined by the data themselves rather than the needs of a particular software application or group of users.
    1. The above is correct
    2. The above is incorrect
  1. An effective database will:
    1. Avoid redundancy of data
    2. Support use by a wide variety of software applications and user groups
    3. Be capable of adapting to changing data capture and storage requirements
    4. All of the above
  1. Database Management System (DBMS) –
    1. Are system software that aid in organizing, controlling and using the data needed by application programs.
    2. Provides the facility to create and maintain a well-organized database
    3. Provides functions such as normalization to reduce data redundancy, decrease access time and establish basic security measures over sensitive data
    4. All of the above
  1. Database Management System (DBMS) can control user access at which of the following levels?
    1. User and the database
    2. Program and the database
    3. Program and data field
    4. User and data field
    5. All of the above
  1. The advantages of Database Management System (DBMS) include:
    1. Data independence for application systems
    2. Ease of support and flexibility in meeting changing data requirements
    3. Transaction processing efficiency
    4. Reduction of data redundancy
    5. All of the above
  1. Data elements required to define a database are called metadata. Types of metadata are:
    1. Conceptual schema
    2. External schema
    3. Internal schema
    4. All of the above
  1. The functional capabilities Data dictionary and Directory systems (DD/DS) provides include:
    1. Validates the definition provided to ensure the integrity of the metadata
    2. Interrogation and reporting facilities that allow the DBA to make inquires on the data definition.
    3. Prevents unauthorized access or manipulation of the metadata
    4. All of the above

  1. Benefits/Advantages of using Data dictionary and Directory systems (DD/DS) include:
    1. Enhancing documentation
    2. Providing common validation criteria
    3. Facilitating programming by reducing the needs for data definition
    4. Standardizing programming methods
    5. All of the above
  1. Data Modeling – is a technique in software engineering where a specific data model is created for an information system by means of data modeling techniques like database management system.
    1. True
    2. False
  1. Types of Database Organization include:
    1. Hierarchical
    2. Network
    3. Relational
    4. All of the above
  1. Disadvantages of Databases include:
    1. A large database can be more complex than a file processing system.
    2. Larger databases also require more memory, storage and processing power than file processing systems
    3. Both A&B
    4. None
  1. What controls should be to ensure database integrity?
      1. Establish definition standards and closely monitor for compliance
      2. Establish and implement data backup and recovery procedures to ensure database availability
      3. Establish controls to ensure only authorized personnel can update the database
      4. Perform database reorganization to reduce unused disk space and verify defined data relationships
      5. Follow database re-structuring procedures when making logical, physical and procedural changes
      6. Minimize the ability to use non-system means, for instance, those outside security control, to access the database
    1. (I) (II) and (VI) only
    2. (III) (IV) and (VI) only
    3. All of the above
    4. None
  1. Data Warehouse –
    1. There is an initial setup phase during which relevant information is extracted from different networked data sources, transformed and cleansed as necessary, fused with information from other sources and then loaded into a centralized data store
    2. It offers higher availability and better query performance than the on-demand approach because all data can be retrieved directly from one single dedicated site.
    3. Both A&B
    4. None
  1. Management Information Systems (MIS) can be viewed as being constructed to serve various levels and aspects of management activities in the organizational hierarchy. The levels represent decision made in organizations including:
    1. Strategic planning decisions
    2. Managerial control decisions
    3. Operational control decisions
    4. All of the above

  1. Office Automation Systems (OAS) –
    1. Helps with the need for solutions that can handle all the office updates, tasks, functions and ensure that aspects like raw data storage, managing electronic business data.
    2. It collects, stores and oversees the aspects of a business effectively without any error.
    3. Both A&B
    4. None
  1. Transaction Processing System (TPS) – Represent the lowest and the most basic use of information within an organization, and are an integral part of the operation of the organization.
    1. The above is correct
    2. The above is incorrect
  1. Management Information Systems (MIS) –
    1. A set of formalized procedures designed to provide managers all levels with appropriate information from all relevant sources.
    2. They generate information for monitoring performance and maintaining coordination.
    3. MIS extracts process and summarize data from the TPS and provide periodic reports to managers.
    4. All of the above
  1. Management Information Systems (MIS) reports can be classified by content or time. In terms of content, reports may be:
    1. Comprehensive
    2. Summary
    3. Exception reports
    4. All of the above
  1. In terms of time Management Information Systems (MIS) produces:
    1. Historical reports
    2. Status reports
    3. Predictive reports
    4. All of the above
  1. Program library management systems – Provide several functional capabilities to facilitate effective and efficient management of data center software inventory.
    1. True
    2. False
  1. Capabilities of Program library management system include:
    1. Integrity
    2. Update and Reporting
    3. Interface
    4. All of the above

  1. Which of the following would not be considered an end-user of an information system?
    1. A student who accesses information on a website
    2. A programmer who write code for a software module
    3. A customer who uses a credit card in an EFTPOS machine
    4. A sales assistant in a video shop who searches a database for a specific title
  1. TPS generally contains at least two types of files:
    1. Master files and Transaction files
    2. Data files and Image files
    3. Index files and Sequential Access files
    4. Direct and Random-Access files
  1. The language used application programs to request data from the DBMS is referred to as the:
    1. DML
    2. DDL
    3. Query language
    4. All of the above

—More to come soon—

Read more
Read more
Read more

Leave a Reply

Sign up for Free MCQs

Success is awaiting for you

JOIN US

MCQsClub login

Welcome to the Club

Log in to continue. IT'S FREE

OR