AIS 5-8 Missed Questions
Which of the following can be used to detect fraud occurrences in near real time?
Business analytics
A knowledge base:
Is a collection of a company's files and documents, Is analogous to a database, Generally contains proprietary information
Which of the following is true about recursive relationships?
They occur between two different instances of an entity
_________ is a special code or password that enables programmers to bypass the security features of the program to access the program.
Back door
Describe the basic differences between ES and NN
NNs develop their own knowledge base and continue to learn
Coding schemes on relational databases do not include:
Normalized coding
Which of the following situations is not a segregation of duties violation within the revenue cycle?
The AR clerk reconciles the AR subledger to the Control account in the general ledger on a monthly basis and investigates discrepancies.
Which statement is true regarding knowledge management?
The primary enabler is information technology
Explain when a database designer might use a relationship table in constructing a relational database.
To link two relational tables in a M:N relationship
Dependencies cause several problems, called _______ _______:
Update anomalies
All of the following is true of databases
1) A collection of data within an interconnected series of files is a centralized database 2) Decentralized data is when the system must store and maintain multiple versions of the same data in different files 3) Business event data are copied periodically into a separate database (a data warehouse).
Intelligent Agents:
1. Are frequently used by search engines 2. Perform their tasks without further direction from the user 3. Are sometimes called "bots"
Organizations use a database management system to:
1. Coordinate the activities of functional areas 2. Simplify the tasks of creating, accessing, and managing a centralized database 3. Provide data useful to managers
In entity-relationship modeling the designer:
1. Draws a diagram of the relational model 2. Identifies how the things are related to each other 3. Identifies the entities
All of the following are true about composite primary keys:
1. Is created by breaking the key down into its component sub-attributes 2. Is formed from the primary keys of two other tables 3. Is needed in M:N relationships
A tuple is:
1. One employee in an instance of the EMPLOYEE relation 2. A set of data that describes a single instance of the entity represented by a relation 3. A row in a relational database
A well-documented application typically includes:
1. Systems documentation 2. Program documentation 3. Operations run and user manuals
What advantages do intelligent agents have in the operation of a decision support system?
1. They can perform time-consuming tasks 2. They can collect specific information from the Internet or large data warehouses 3. They can identify factors that should be considered when using a system for decision making
Which of the following is an objective in the development of an REA model?
1. To incorporate financial and non-financial data, and accounting and non-accounting data 2. To identify the data required by managers and other users to perform effectively 3. To integrate the data in a way that allows those users to efficiently access the information needed
Which of the following statements is true concerning normalization?
2NF does not contain partial dependencies
What is an entity-relationship model (E-R model)?
A diagram of the relational model
Relationships are:
Associations between entities.
What is referential integrity?
Can serve as an effective control
What factors distinguish DSS from EIS?
DSSs can provide "recommendations", but EISs do not usually do so
A major difference between the centralized database approach and the applications approach is decoupling, also known as _______ ______:
Data independence
The first step in E-R modeling is to:
Determine users' requirements for the database
Which of the following is not a control goal of information processes?
Ensure security of resources
In a relational database, a separate relational table is created for each ______.
Entity
When does functional dependence exist?
If a value for the first attribute determines a single value for the second attribute
Which of the following cannot be the maximum cardinalities of two relational tables?
M:0
Which of the following is true about an entity in a relational database?
Is represented as a table
A key attribute:
Is the attribute whose value is unique
A primary key:
Is used for linking database tables together
Why have knowledge management systems become important?
Knowledge management systems help capture, store, organize, present, distribute, and control access to the knowledge base
Which of the following is not a part of monitoring control plans?
Monitoring, and observing the work of others
______ ______is a process by which organizations select objectives, establish processes to achieve objectives, and monitor performance.
Organizational governance
Which type of control plan influences the effectiveness of the control plans at lower levels of the control hierarchys?
Pervasive control plan
______control plans relate to a multitude of goals and processes and business _______control plans relate to the technology used to implement the process
Pervasive, process
Program change controls:
Provide assurance that all modifications to programs are authorized and documented
Which approach to developing models of accounting databases ensures that a system captures all data related to business events?
Resources-events-agents
The difference between risks and opportunities is:
Risks could have a negative impact and opportunities could have a positive impact on the organization's objectives.
_________ are unauthorized instructions inserted into a program to systematically steal very small amounts.
Salami slicing
Which of the following objectives are high-level goals aligned with and supporting the organization's mission?
Strategic
The participation constraint:
Specifies the degree of participation
Which of the following is not one the steps in the three step strategy for effectively identifying the relationships that should be included in a database model?
Specify the degree of minimum participation of one entity in the relationship with the other entity
A ________ guides the IT organization in establishing and meeting user information requirements.
Steering committee
Which of the following procedures would an entity most likely include in its BDP?
Store duplicate copies of files in a location away from the computer center
The SOX section that establishes an independent board to oversee public company audits is:
Title I - Public Company Accounting Oversight Board
The SOX section that requires a company's CEO and CFO to certify quarterly and annual reports is:
Title III - Corporate Responsibility
What is a partial dependency?
When an attribute is dependent on a portion of the primary key, not on the entire key