Quiz
ACCT310 - Ch 1, 2, 3, 4
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (135)
1Bob's manager complains that Bob suffers from "Analysis Paralysis," that is, he spends too much time reviewing endless reports and is reluctant to make decisions. Bob most likely suffers from ________.
- AData gridlock.
- BData redundancy.
- CInformation overload.
- DDiscretionary information.
2An example of an AIS that primarily addresses internal business processes includes:
- AEnterprise systems.
- BCustomer relationship management software.
- CSupply chain software.
- DB2B transaction software.
3The IT strategic roles of AIS investments are classified as:
- ADigitize, Report, Transform
- BValue creation, Value Destruction, Value Neutral
- CAutomate, Informate, Transform
- DAutomate, Digitize, Transport
4The role of accounting information systems include all except:
- AUser
- BOperator
- CEvaluator
- DManager
5The correct order of effects in the value chain are:
- AInbound Logistics → Operations → Service.
- BInbound Logistics → Operations → Shipping.
- CInbound Logistics → Operations → Outbound Logistics.
- DInbound Logistics → Outbound Logistics → Marketing & Sales.
6EBay uses information technology to sell goods on the internet. This would be an example of the ________ strategic role.
- AInformate - up.
- BInformate - down.
- CTransform.
- DAutomate.
7According to a recent study, the informate-up IT strategic role is defined as systems that:
- AFundamentally redefine business processes and relationships.
- BProvide information about business activities to senior management.
- CProvide information about business activities to all employees.
- DReplace human labor in automating business processes.
8Which of the following are considered to be mandatory information required by a regulatory body?
- AThe total dollar value of fireworks that are sold on July 4.
- BFinancial reports for the Securities and Exchange Commission.
- CThe amount of taxes saved by a merger.
- DThe cost to build an all-new Starbucks restaurant in Abu Dhabi.
9Which of the following is usually the primary objective for companies when creating mandatory information?
- AEnsure proper controls over business processes.
- BThe value of the information exceeds the cost to produce it.
- CImprove business decisions
- DMinimize cost.
10One common way of measuring the effectiveness of the Supply Chain is through the fill rate. Which of the following best describes the fill rate?
- AThe rate at which the stock in warehouse storage bins increases.
- BThe average amount of time it takes for the organization to fulfill customers' orders.
- CThe number of items per hour that receiving employees can move from the receiving dock to the warehouse.
- DThe percentage, in monetary value, of a supplier's order which is actually delivered to the organization.
11The Information Value Chain is defined as:
- AA centralized database that collects data from throughout the firm.
- BThe flow of materials, information, payments, and services.
- CThe use of computer technology to provide information about business activities to employees across the firm.
- DThe overall transformation of data from a business need to the ultimate decision.
12Effective use of Supply Chain Management software is generally expected to provide all of the following benefits except:
- AReduced gross margins.
- BReduced inventory carrying costs.
- CBetter communications with suppliers.
- DLower production costs.
13The income statement account most likely affected by an AIS investment in customer relationship management (CRM) would be:
- AUnearned Revenue.
- BSelling, General and Administrative Expenses.
- CRevenues.
- DCost of Goods Sold.
14Accounting information systems:
- AInclude records, processes and reports.
- BReport only accounting information.
- CAre for computer games.
- DAre always computerized.
15 Consider the non-profit organization Doctors without Borders (Médecins Sans Frontières), a Nobel Peace Prize winning organization that provides medical services in war zones and developing countries. For this type of organization, which of the following would likely be the best measure of business value.
- ADonations raised.
- BLives saved.
- CFund balance (i.e., the net of revenues less expenditures).
- DVolunteers deployed.
16The income statement line item most likely affected by an AIS investment in supply chain that would interface with suppliers would be:
- AResearch and Development Expenses.
- BRevenues.
- CCost of Goods Sold.
- DSelling, General and Administrative Expenses.
17Customer Relationship Management is defined as:
- AA system used to connect a firm's suppliers with a firm's customers.
- BA system used to manage and nurture a firm's interactions with its current and potential customers.
- CA system used to track a customer's past purchases.
- DA system used to advertise current items on sale to customers.
18Activity-based costing is an example of:
- Adiscretionary information
- Bmandatory information
- Cinformation overload
- Denterprise system
19A simple information system includes all but the following elements except:
- AReporting.
- BProcessing.
- CInput.
- DStorage.
20A supply chain:
- ARefers to the supplies needed to build products.
- BDoes not apply to a service firm like an accounting firm.
- CRefers to the flow of materials, information, payments and services.
- DIs similar in function and purpose to the value chain.
21Which of the following systems would a company be most likely to employ for the primary purpose of generating additional sales revenue?
- ACRM
- BSCM
- COCR
22Support activities in the value chain do not include:
- AAccounting and Finance.
- BProcurement.
- CHuman Resource Management.
- DFirm Infrastructure.
23Discretionary information is most likely to be used in which of the following activities?
- AFiling a 10-K with the SEC.
- BManagement decision-making.
- CPreparing required Environmental Protection Agency emissions reports.
- DPayroll tax reporting.
24The primary transformation of data into information takes place in which of the following activities?
- AProcessing
- BInput
- COutput
- DData
25Which of the following most accurately describes IFAC's description of accounting and IT?
- AAccounting is an important peripheral discipline to IT.
- BIt is difficult to conceive of accounting independent from IT.
- CIT is an important peripheral discipline to accounting.
- DAccounting and IT are indistinguishable from one another.
26Which designation is for CPAs with a broad range of technology knowledge and experience?
- ACertified Information Technology Professional (CITP).
- BCertified Public Accountant (CPA).
- CCertified Internal Auditor (CIA).
- DCertified Information Systems Auditors (CISA).
27The Sarbanes-Oxley Act of 2002 requires that a company's attest auditors be able to perform which of the following activities?
- ADesign and implement the controls used in the AIS.
- BEvaluate the internal controls in an AIS.
- CTake over the company's AIS if necessary.
- DAssess the value of a company's IT assets.
28Which of the following is not a characteristic of useful information?
- AFeedback value.
- BRepresentational Faithfulness.
- CTimeliness.
- DEasy to understand.
29
Business Value is defined as:- AThe monetary value of a business.
- BItems, events and interactions that determine the financial health and well-being of the firm.
- CThe cost to acquire a business by an outsider.
- DThe overall value of taking data and transforming it in to information needed for decision making.
30Which designation would be most appropriate for those professionals possessing IT audit, control and security skills?
- ACertified Internal Auditor (CIA).
- BCertified Information Technology Professional (CITP).
- CCertified Public Accountant (CPA).
- DCertified Information Systems Auditors (CISA).
31A dental practice implemented an upgrade to its AIS that provides the dentists with daily and weekly patient and financial summaries. The practice's upgrade is an example of which IT strategic role?
- AInformate - down
- BTransform
- CAutomate
- DInformate - up
32The income statement line item most likely affected by an AIS investment in enterprise systems would be:
- ASelling, General and Administrative Expenses.
- BCost of Goods Sold.
- CRevenues.
- DUnearned Revenue.
33Many hospitals and doctor's offices are beginning to digitize the medical records of their patients. This is an example of the ________ strategic role.
- ATransform.
- BInformate - down.
- CAutomate
- DInformate - i[
34According to a recent study, the transform IT strategic role is defined as systems that:
- AFundamentally redefine business processes and relationships.
- BProvide information about business activities to all employees.
- CProvide information about business activities to senior management.
- DReplace human labor in automating business processes.
35Which of the following is NOT a primary activity in the Value Chain?
- AOutbound Logistics.
- BMarketing.
- CInformation Technology.
- DInbound Logistics.
36A supply chain system does not include information about:
- ACurrent suppliers.
- BAvailability of inventory.
- CProspective customers.
- DCurrent customers.
37Investors reward companies most that announce IT initiatives with which type of strategic role?
- AInformate – up.
- BTransform.
- CAutomate.
- DInformate – down.
38One of the most important ways that ERPs benefit organizations and their business processes is:
- AReducing the amount of time to complete business processes by eliminating all controls associated with the processes.
- BPreventing external business partners from accessing the organization's data.
- CInformation is stored in many specialized, distributed databases that each serve separate business processes.
- DCurrent information is made available to all users involved in the activities and decisions associated with a company's business processes.
39Which of the following best describes the purpose of an event in a Business Process Modeling Notation (BPMN) activity diagram?
- ADescribes the sequence of workflow.
- BAffects the flow of the business process.
- CShows where the work takes place.
- DControls branching and merging.
40Which of the following is a difference between Business Process Modeling Notation (BPMN) activity diagrams and flowcharts?
- AFlowcharts have symbols to represent the start and end of a process.
- BFlowcharts can be annotated with text.
- CBPMN symbols can show a variety of intermediate events that affect the sequence flow.
- DBPMN diagrams show the sequence flow of activities.
41Which of the following is not a common element of activity models regardless of the specific modeling notation?
- AEvents to start and stop the workflow.
- BSequence of flow between tasks.
- CMultiplicities.
- DDecision points that affect the process flow.
42Which of the following is not a Business Management Support role of the Accounting/Finance Function in Business?
- AInvestment appraisal.
- BPlanning, budgeting and forecasting
- Cmanagement information
- Dfinancial consolidation, reporting and analysis
43Which of the following is not a Stewardship and Reporting role of the Accounting/Finance Function in Business?
- AStatutory reporting.
- BHuman Resource management.
- CTax returns.
- DRegulatory compliance.
44Which of the following best describes a business model?
- AA sequence of business activities.
- BA simple, abstract representation of a business process or processes.
- CAn evaluation of potential business process improvements.
- DNone of the options are correct.
45Which of the following best describes the purpose of an activity model?
- AAn activity model describes the sequence of workflow in a business process.
- BAn activity model depicts data structures.
- CAn activity model constrains and guides process operations.
- DNone of the options are correct.
46Which of the following best describes a Business Process Modeling Notation (BPMN) message flow?
- AAffects the flow of a business process.
- BShows the sequence of activities in a process.
- CShows branching and merging in a business process.
- DShows interactions between participants in a process.
47Which of the following best describes the purpose of a gateway in a Business Process Modeling Notation (BPMN) activity diagram?
- AAffects the flow of the business process.
- BShows where the work takes place.
- CDescribes the sequence of workflow.
- DControls branching and merging.
48Which of the following is not part of the business analysis process?
- AAscertaining information about current and future business processes.
- BDocumenting current and future business processes.
- CUsing IT to make finance and accounting processes more efficient and effective.
- DUsing business process modeling tools.
49Which of the following symbols depicts an intermediate event?
- AA circle with a double line perimeter
- BAn arrow.
- CA circle with a wide single line perimeter.
- DA rectangle.
50Which of the following best describes why the Sarbanes-Oxley Act of 2002 (SOX) made documentation of business processes essential for businesses?
- ASOX requires managers to assess and attest to the company's internal controls structures and procedures.
- BSOX mandates that accountants create the business rules and documentation associated with a company's business processes.
- CSOX allows thorough documentation of business processes to act as a substitute for a full review of internal control structures and procedures.
- DSOX explicitly states that business processes must be documented.
51Which of the following best describes how business models help companies manage complexity?
- AAlthough business models are a simplification of the actual processes they represent, they incorporate the processes' essential elements.
- BBecause business models can't exceed one page, managers can understand how the business works at a glance.
- CBusiness models must display every detailed task and activity, which allows managers to visualize the complexity inherent in its business processes.
- DBusiness models' limitations force managers to simplify the company's actual processes.
52Activity models are analogous to which of the following?
- AA car's steering system.
- BThe prototype for a new car model.
- CA blueprint.
- DThe instructions in a recipe.
53In order to perform their required roles and be valuable business partners, accountants must understand all of the following except:
- AWhat risks the business faces, and how internal controls can mitigate those risks.
- BHow the business delivers value, interacts with other businesses, and is a good corporate citizen.
- CHow the business identifies and designs its products and services.
- DHow the business collects data, summarizes it, and communicates business information.
54A boundary event in a BPMN activity model:
- AOccurs as a message leaves a pool.
- BTakes place at the edge of a swimlane.
- COccurs at the border of a pool.
- DIs attached to the edge of an activity pool.
55Which of the following is not a purpose of documentation?
- ADetermining staffing.
- BEstablishing accountability.
- CDescribing current processes.
- DTraining.
56Message flows in BPMN activity diagrams indicate an exchange between:
- AActivities in the same swimlane.
- BGateways in different swimlanes.
- CParticipants in different pools.
- DEvents in the same pool.
57Which of the following symbols is used to depict different organizations in one Business Process Modeling Notation (BPMN) diagram?
- AMessage flow
- BPool
- CGateway
- DIntermediate event
58A pool in a BPMN activity model represents.
- AA logical activity
- BA department or functional area
- CAn entire organization/entity
- DA specific individual
59Which of the following symbols depicts an activity
- Aarrow
- Brectangle
- Ccircle with a wide single line perimeter
- Dcircle with a double line perimeter
60A pool in a BPMN activity model represents.
- AA logical activity.
- BA department or functional area.
- CAn entire organization/entity.
- DA specific individual.
61Which of the following is not an Accounting/Finance Operations role of the Accounting/Finance Function in Business?
- AFinancial close – completing period end accounts.
- BFinancial consolidation, reporting and analysis.
- CPeople management.
- DStakeholder assurance.
62Which of the following is not a valid BPMN gateway type?
- AExclusive gateway.
- BSerial gateway.
- CParallel gateway.
- DInclusive gateway.
63Business models provide value in all of the following areas except which one?
- AEliciting requirements for new systems.
- BSpecifying systems requirements.
- CEmployee performance appraisal.
- DManaging complexity
64Which of the following best describes the purpose of swimlanes (or lanes)?
- ADepict the sequence of tasks in a process.
- BDepict different departments of the same organization in a process.
- CDepict different organizations involved in a process.
- DDepict interactions between organizations in a process.
65Process documentation does not include which of the following?
- AUser manuals
- Bprocess models
- Cbusiness rules
- DExternal audit workpapers.
66When connecting to an opaque external pool in a BPMN activity diagram, message flows connect to:
- AThe appropriate data store.
- BThe nearest sequence flow.
- CThe edge of the swimlane.
- DThe edge of the opaque pool.
67When creating a BPMN activity model, which of the following is most accurate?
- AThe resulting BPMN activity model should closely match the structure of the subsequent database.
- BDifferent modelers given the same set of facts about a business process should develop similar models of the process.
- CAll activity models should include gateways.
- DModeling is an artistic endeavor; therefore different modelers given the same set of facts about a business process will likely develop very different models of the process.
68Which of the following is not a building block for Business Process Modeling Notation (BPMN) diagrams?
- AAssociations
- BSequence flows
- CEvents
- DGateways
69Which of the following best describes the difference between a Business Process Modeling Notation (BPMN) gateway and a flowcharting decision diamond?
- AOnly the gateway shows branching of the sequence flow.
- BOnly the decision diamond shows branching of the sequence flow.
- CThe gateway only represents branching and not the decision that results in branching.
- DThe decision diamond can depict more branching options.
70Associations in UML Class DIagrams should include a description in which of the following situations:
- AThe business purpose of the association is not clear.
- Bthe decision criterion affecting the process flow direction is not clear.
- CThe attributes of the related class are not clear.
- DAssociations should always include descriptions.
71Consider an association between a Cash Disbursements class and a Cash Accounts class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Cash Accounts class are 1..1. Which of the following is the best way to implement that association in your database?
- APost the primary key of Cash Disbursements as a foreign key in Cash Accounts.
- BCreate a linking table.
- CPost the primary key of Cash Accounts as a foreign key in Cash Disbursements.
- DNone of the options are correct.
72Consider an association between a Cash Disbursements class and a Vendors class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cash Disbursements class are 0..* and the multiplicities next to the Vendors class are 1..1. Which of the following is the best way to implement that association in your database?
- APost the primary key of Vendors as a foreign key in Cash Disbursements.
- BCreate a linking table.
- CPost the primary key of Cash Disbursements as a foreign key in Vendors.
- DNone of the options are correct.
73Consider an association between a Cities class and a Neighborhoods class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Cities class are 1..1 and the multiplicities next to the Neighborhoods class are 1..*. Which of the following is the best way to implement that association in your database?
- APost the primary key of Neighborhoods as a foreign key in Cities.
- BPost the primary key of Cities as a foreign key in Neighborhoods.
- CNone of the options are correct.
- DCreate a linking table.
74Consider an association between a Customers class and a Sale class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Customers class are 1..1 and the multiplicities next to the Sale class are 0..*. Which of the following is the best way to implement that association in your database?
- APost the primary key of Customers as a foreign key in Sales.
- BCreate a linking table.
- CPost the primary key of Sales as a foreign key in Customers.
- DNone of the options are correct.
75Consider an association between a Deliveries class and a Shipping Companies class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Deliveries class are 0..* and the multiplicities next to the Shipping Companies class are 1..1. Which of the following is the best way to implement that association in your database?
- ACreate a linking table
- BPost the primary key of Shipping Companies as a foreign key in Deliveries.
- CPost the primary key of Deliveries as a foreign key in Shipping Companies.
- DNone of the options are correct.
76Consider an association between a Pet Owners class and a Pets class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Pet Owners class are 1..1 and the multiplicities next to the Pets class are 1..*. Which of the following is the best way to implement that association in your database?
- APost the primary key of Pet Owners as a foreign key in Pets.
- BPost the primary key of Pets as a foreign key in Pet Owners.
- CCreate a linking table.
- DNone of the options are correct.
77Consider an association between a Sales class and an Inventory class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Sales class are 0..* and the multiplicities next to the Inventory class are 1..*. Which of the following is the best way to implement that association in your database?
- ACreate a linking table.
- BPost the primary key of Inventory as a foreign key in Sales.
- CPost the primary key of Sales as a foreign key in Inventory.
- DNone of the options are correct.
78Consider an association indicating professional licensing status between an Accountant class and a States class in a Unified Modeling Language (UML) Class diagram. The multiplicities next to the Accountants class are 0..* and the multiplicities next to the States class are 0..*. Which of the following is the best way to implement that association in your database?
- APost the primary key of States as a foreign key in Accountants.
- BPost the primary key of Accountants as a foreign key in States.
- CCreate a linking table.
- DNone of the options are correct.
79Entity-relationship diagrams (ERDs) are similar in content and purpose to Unified Modeling Language (UML) Class diagrams. Which of the following is not a basic building block of ERDs?
- AEntities
- BRelationships
- CAssociations
- DAttributes
80Logical database structure models, including UML Class Diagrams, must be able to describe which of the following?
- AThe operations performed on the database.
- BThe entities in the domain of interest.
- CThe activities performed in the business process.
- DThe Bachman diagram.
81The following UML class diagram should result in how many tables in the relational database? (Items, Purchase Orders, Vendors, Employees)
- A6
- B5
- C4
- D7
82The following UML class diagram should result in how many tables in the relational database? (plants, landscaping jobs, employees, customers)
- A7
- B5
- C4
- D6
83What is the best description of the relationship between employee and vehicle in the following UML class diagram?
- Azero-to-one
- Bone-to-many
- Cone-to-one
- Dzero-to-zero
84What is the best description of the relationship between employee and vehicle in the following UML class diagram?
- Aone-to-many
- Bone-to-zero
- Cone-to-one
- Dzero-to-many
85What is the best description of the relationship between instructor and course in the following UML class diagram?
- Aone-to-many
- Bzero-to-many
- Cmany-to-many
- Done-to-zero
86When implementing the database from a UML class diagram, associations should be mapped to which of the following?
- Afields
- Btables
- Cforeign keys
- Drelationships
87When implementing the database from a UML class diagram, attributes should be mapped to which of the following?
- ATables.
- BIndexes.
- CRelationships.
- DFields.
88Which attribute in the following class would make the best primary key?
- Acustomer ID
- Bcustomer name
- Ccustomer
- Demail
89Which of the following are possible options for minimum multiplicities?
- A* and 1
- B0 and *
- C0 and 1
- D0, 1, and *
90Which of the following UML class diagrams depicts an aggregation relationship?
- A
- B
- C
- D
- A
91Which of the following best describes the purpose of a primary key?
- AUniquely identifies each instance of class.
- BMatches values of foreign keys in other classes.
- CIndicates the minimum multiplicities for an association
- DAllows linking two or more tables
92Which of the following is a well-formed business rule?
- ACustomers may not be under 18.
- BCustomers must pay in US dollars
- CCustomers must be over 18.
- DAll of these are well-formed business rules.
93Which of the following is most similar to the relationship between the UML class diagram and the database?
- AThe relationship between cooking instructions and ingredients.
- BThe relationship between a blueprint and building.
- CThe relationship between driving directions and a map.
- DThe relationship between raw materials and finished goods.
94Which of the following best describes an association
- Athe relationship between two classes.
- Bthe lines in a UML class diagram.
- CA group of classes.
- Dthe number of times one class is related to another.
95Which of the following is not a best practice in preparing Unified Modeling Language (UML) Class diagrams?
- AModel each process separately.
- BOpt for simplicity.
- CAvoid confusing abbreviations.
- DAvoid crossing lines whenever possible.
96Which of the following is not a category of operational decision used in creating business rules?
- AEvent
- BOpportunity
- CRisk
- DCalculation
97Which of the following is not a criterion for selection of a primary key?
- ALonger key values are better than shorter key values.
- BThe primary key should be controlled by the organization assigning it.
- CThe primary key cannot be NULL
- DPrimary keys with sequential values make it easier to spot gaps in the data.
98Which of the following is not a form of business rules?
- ACompulsory
- BAllowed
- CObligatory
- DProhibited
99Which of the following is not a step in a using a Unified Modeling Language (UML) Class model to prepare a database?
- AMap associations to foreign keys
- BMap classes to tables
- CMap attributes to table fields
- DMap associations to primary keys.
100Which of the following is not a valid enforcement level for business rules?
- AAuthorization
- BPost-override
- CPre-override
- DStrict Enforcement
101Which of the following is not one of the building blocks used for creating UML Class Diagrams?
- AEvents
- BClasses
- CAssociations
- DNone of the other options are used in UML Class DIagrams
102Which of the following is not something a model of database structures must be able to describe?
- AThe sequence that entities are accessed.
- BThe cardinalities that describe how many instances of one entity can be related to another.
- CThe attributes or characteristics of the entities and relationships.
- DThe entities or things in the domain of interest.
103Which of the following statements about foreign keys is not true?
- AA foreign key cannot be NULL
- BForeign keys support a defined association
- CForeign key must match values of the linked primary key
- DA foreign key can be a combination of attributes
104Which of the following would be least likely to be represented with a Unified Modeling Language (UML) Class?
- AThe number of trucks used in the delivery
- BThe customer receiving the delivery
- CThe employee driving the truck
- DTrucks
105A query in a program language can be used to
- Aupdate data
- Bretrieve data
- Creport data
- Dall of these choices are correct
106Access offers modules, which are defined by users to automate processes like opening a specific form.
- ATrue
- BFalse
107An enterprise resource planning system has which of the following advantages over multiple independent functional systems?
- AIncreased amount of data redundancy since more than one module contains the same information.
- BIncreased responsiveness and flexibility while aiding in the decision-making process.
- CReduction in costs for implementation and training.
- DModifications can be made to each module without affecting other modules.
108Classes could be grouped into Resources (R), Entities (E), and Assets (A) in data modeling.
- ATrue
- BFalse
109Classes in a relational database model for AISs are typically grouped into all of the following categories except:
- AEvents
- BActivities
- CResources
- DAgents
110Consider the following SQL query. Which item best describes the results of the query?
SELECT VendorID, Sum(POTotal)
FROM [Purchase Orders]
GROUP BY VendorID- ADisplays the vendor ID and all purchase order totals in the purchase orders table.
- BAdds new purchase order information to the purchase orders table.
- CDisplays the vendor ID and the sum of all purchase order totals for that vendor.
- DDisplays all purchase order lines for all vendors.
111ERPs are useful to auditors for which of the following reasons?
- AERPs use cloud computing technology, which allows auditors to review transactions from anywhere.
- BERPs track details regarding creation, modification, and use of transactions throughout the organization in a single system.
- CERPs are required by the Sarbanes-Oxley Act of 2002.
- DERPs are spread across multiple logical databases, allowing auditors to minimize disruption to processing when reviewing ERP activity.
112Each attribute in a table can have several names
- Atrue
- Bfalse
113In Access, users can edit database information in reports.
- AFalse
- BTrue
114In Microsoft Access, we use "Forms" for:
- AData entry
- BData storage
- CData retrieve.
- DTwo of these choices are correct.
115In Microsoft Access, we use "Tables" for:
- AData storage
- BData entry
- CData retrieve
- DTwo of these choices are correct.
116In Microsoft Access, we use tables in a database for:
- AData storage
- BData retrieval
- CData entry
117In a database, while queries allow the user to access, read and report on desired data, the responsibility of actually making physical changes to the relational database belongs to the Database Management System (DBMS).
- ATrue
- BFalse
118In a hierarchical data model, data elements are related in many-to-many relationships.
- ATrue
- BFalse
119Queries in Access are utilized by users to enter data into tables and view existing records.
- ATrue
- BFalse
120SQL is based on relational algebra and allows a user to query and update the database.
- ATrue
- BFalse
121The "Where" SQL clause can be used to link two tables.
- ATrue
- BFalse
122The property of the primary key in a table in Microsoft Access should be set to:
- AThe Required field = "Yes", and the Indexed field = "Yes (No Duplicates)".
- BThe Required field = "NO" and the Indexed field = "Yes (No Duplicates)".
- CThe Required field = "NO" and the Indexed field = "Yes (Duplicated)".
- DThe Required field = "Yes" and the Indexed field = "Yes (Duplicated)".
123What kind of data model is most commonly used as a basis for today's enterprise systems?
- Athe relational model
- Bthe hierarchical model
- CThe network model
124Which of the following Microsoft Access objects is used to integrate data from one or more queries and/or tables in order to present information useful to decision makers?
- AReports
- BForms
- CTables
- DMacros
125Which of the following correctly describes the Referential Integrity Rule?
- AThe primary key of a table must have data values (Cannot be null).
- BThe data value for a foreign key could be null
- CEach attribute in a table must have a unique name
- DValues of a specific attribute must be of the same type
126Which of the following is considered a class in the relational database model?
- ACash
- BCustomer
- CSale
- DAll of these choices are correct
127Which of the following is not one of the objects used in Microsoft Access?
- ASites
- BTables
- CMacros
- DForms
128Which of the following items does not represent a UML class diagram object and its resulting database object?
- AMultiplicities - Records
- BAttributes - Fields
- CAssociations - Relationships
- DClasses - Tables
129Which of the following operators would be used in a SQL query designed to simply display database records?
- ADISPLAY
- BSELECT
- CVIEW
- DINSERT
130Which of the following resources is usually not modeled as an entity (table) in an REA data model?
- ACash
- BInventory
- CAccounts receivable
- DPPE
131Which of the following statements best describes the entity integrity rule?
- AAll values of an attribute must be of the same data type.
- BA record's foreign key value must be null.
- CA record's primary key must have a data value.
- DA database entity must fit within the REA model.
132Which of the following tasks cannot be performed through queries in access?
- ACreate and update relationships
- BCalculations of data
- CData sorting
- DRetrieve and display data
133Which set of multiplicities correctly shows the relationship between the Cash Collection table and the Sales table in modeling cash sales?
- ACash Collection (1..1) – Sale (1..N).
- BCash Collection (1..N) – Sale (1..N).
- CCash Collection (1..N) – Sale (1..1).
- DCash Collection (1..1) – Sale (1..1).
134Which set of multiplicities correctly shows the relationship between the Cash Receipts table and the Sale table for an organization that allows customers to buy on credit and pay in multiple installments?
- ACash Receipts (1..1) – Sale (N..M).
- BCash Receipts (1..N) – Sale (0..N).
- CCash Receipts (1..1) – Sale (1..1).
- DCash Receipts (0..N) – Sale (1..1).
135Which type of data models alllows each record to have multiple parent and child records.
- Athe hierarchical model
- Bthe network model
- Cthe relational model
Information
- Description
- Quiz on ACCT310 - Ch 1, 2, 3, 4, created by Jenna Williams on 17/04/2019.
- Author
- Jenna Williams
- Language
- English
- Views
- 869
- History
- Created on 17 Apr 2019 · updated on 22 Apr 2019
- Tags
- Rating
- No ratings yet Rate this quiz