AIS Exam 2
31) If customers pay for each sales transaction with a separate check and are NOT permitted to make installment payments on any sales then the relationship between "sales" and "receive cash" events would most likely modeled as A.) 1:1 B.) 0:1 C.) 1:N D.) M:N E.) 0:M
A.) 1:1
36) In the MS access and other commonly used database "forms" are A.) A way to input data into the database B.) Tools for searching and extracting data from a database C.) Output of database queries D.) None of the above
A.) A way to input data into the database
6) All of the following are examples of economic events EXCEPT A.) Checking a customers credit card prior to processing a sales order B.) Receiving a raw materials from a supplier C.) Disbursing cash for inventoried purchase D.) Shipping product to a customer
A.) Checking a customers credit card prior to processing a sales order
15) The process of defining a database so that it faithfully represents all aspects of the organization including its interaction with external environment is called A.) Data modeling B.) Data designing C.) Data development D.) Data definition
A.) Data modeling
38) Which database integrity rule ensures each record may be retrieved from the database using a unique identifier A.) Entity integrity B.) Referential integrity C.) Domain integrity D.) Primary key integrity
A.) Entity integrity
2) The potential inconsistency problem could arise when there are multiple occurrences of a data item in a database. This is called the... A.) Update anomaly B.) Insert anomaly C.) Delete anomaly D.) Integrity anomaly E.) Adding anomaly
A.) Update anomaly
26) Which of the following would be TRUE when implementing this REA diagram into a relational database? SEE PICTURE B.) the primary key for cash receipts would be a foreign key for cash
B.) the primary key for cash receipts would be a foreign key for cash
10) How many tables are needed to implement and REA data model that has 5 distinct entities two M:N relations, three !:N relationships and one !:! relations in a relational database? A.) 5 B.) 7 C.) 8 D.) 10
B.) 7
24) Concerning REA models which of the following is FALSE? A.) Many financial statements accounts are represented as resources in the REA model B.) Accounts such as accounts receivable show up as entities in the REA model C.) Much of the info about an organizations assets that is traditional recorded in ledgers is stored in resource tables in an REA based relational database D.) Some accounts represent an imbalance between two related events in the REA model
B.) Accounts such as accounts receivable show up as entities in the REA model
1) The DBMS language that is used for data maintenance and updating of the database is referred to... A.) DDL B.) DML C.) DQL D.) SQL
B.) DML (data manipulation language)
23) Which of the following is NOT likely to be depicted as an entity in the REA data model? A.) Customer B.) Invoices C.) Sales D.) Delivery trucks
B.) Invoices
28) In a relational database, which of the following attributes would typically be included in the table that stores data about the vendor entity? A.) Invoice number B.) Outstanding balance C.) Product code D.) Inventory
B.) Outstanding balance
25) Supplier number is most likely to be a foreign key in which table? A.) Inventory-request goods B.) Receive goods C.) Supplier D.) Warehouse
B.) Receive goods
35) Which of the relationships below is most likely to be a many to many relationship? A.) CUSTOMERS, SALES ORDERS B.) SALES ORDERS, ITEMS C.) ITEMS, SO LINE D.) SO LINE, CUSTOMERS
B.) SALES ORDERS, ITEMS
5) Concerning the development of an REA model which of the following statements is TRUE? A.) Events that pertain to the entry of data are included in the REA model B.) The objective is to model the basic value-chain activity C.) REA diagrams model individual transactions and data collections D.) Information retrieval events are modeled as a evens in the REA model
B.) The objective is to model the basic value-chain activity
34) Which tables primary key has a concatenated primary key? A.) Customers B.) Sales orders C.) SO line D.) Items
C.) SO line
30) A relational database system contains the following inventory data: part number, description, quantity-on-hand, and reorder point. The individual items are called A.) Associations B.) Occurrences C.) Attributes D.) Relations
C.) Attributes
40) The _______ is typically in the position responsible for managing the enterprise/s databases A.) OLAP B.) OLTP C.) DBA (database administrator) D.) SDA
C.) DBA (database administrator)
Sale // _________ // take customer order 13) Which type of transaction is be represented by the diagram above? A.) Each sale is associated with a single order and there is a time lag between the time an order is take and delivery of the product B.) Each sale can be comprised of multiple orders and each order can be associated with one of more sales C.) Each sale is associated with a single order and there is not time lag between the time an order is taken and delivery of the product D.) Each sale can be comprised of multiple orders and each order can be associated with multiple sales or no sales
C.) Each sale is associated with a single order and there is not time lag between the time an order is taken and delivery of the product
12)Which of the following is LEAST likely to be an attribute of an employee table in a normalized database? A.) Employee full name B.) Employees supervisor name C.) Employee phone number D.) Employee address E.) Employee number
C.) Employee phone number
18) Which of the following statements is ONLY true about an integrated REA data model? A.) Every event must be linked to at least 2 agents B.) Every incremental (Get) event must be linked to a decreased (give) event C.) Every resource must be linked to at least one increment event and at least on decrement event D.) Every resource must be linked to at least on agent
C.) Every resource must be linked to at least one increment event and at least on decrement event
Receive inventory 3/_________ 0 / cash disbursements 16) Which type of transaction is represented by the diagram below? A.) Vendors send a bill for each inventory item purchased which is payable on receipt B.) A single purchase of inventory is paid for with multiple payments C.) Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept of allow installment payments D.) Some inventory purchases are paid for with multiple payments and some payments may apply to multiple purchases
C.) Inventory vendors send a monthly bill for merchandise delivered. The seller does not accept of allow installment payments
21) which of the following would most likely to have a concatenated primary key? A.) Inventory B.) Sales C.) Inventory- sales D.) Receiving goods E.) None of the above
C.) Inventory- sales
29) When assigned foreign keys in a 1:M association, in general A.) The primary key of each table should be embedded as a foreign key in the related table B.) The primary key on the (0,M) side of the relation should be embedded as the foreign key on the (1,1) side C.) Primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,M side) D.) None of the above is true
C.) Primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,M side)
32.) Scuz Bootes is a sexagenarian who has been doing custom choppers, piercings, and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle Washington . He has meticulous records of every job he has ever done, carefully hand written with the customer name and address, a description of the job, and an attached picture of the bike or body part before and after customization. His unique style had recently attracted the attention of national media after several celebrities sought him out and showcased his work. Business is booming. Consequently, Scuz has hired you to construct an accounting information system, beginning with the historical records. As you read through the records, you notice that some customers last names have different first names in different records. For example, R. Farmington Farnsworth (Custom Chopper), Bob Farnsworth (Tattoo), and Snake Farnsworth (Tattoos and piercings) all seem to be the same person. This is an example of what type of problem in the existing records? A.) Entity Integrity B.) Referential Integrity C.) Update Anomaly D.) Insert Anomaly E.) Delete Anomaly
C.) Update Anomaly
20) The constraint that all primary keys must have non-null data value is referred to as which of the following A.) normalization rule B.) referential integrity rule C.) entity integrity rule D.) relational data model rule
C.) entity integrity rule
27) A query that extracts, for a given time period, all purchases for which there is no corresponding disburse cash event will yield A.) A cash account ledger B.) A credit sales journal C.) An accounts receivable ledger D.) An accounts payable journal
D.) An accounts payable journal
Sale 3/__________ 0 3 receive cash 14) Which type of transaction is represented by the diagram above? A.) Cash and carry consumer retail sales B.) Consumer retail sales paid in installments to the seller C.) Business to business sales of nondurable goods D.) Business that allows customers to carry a balance and make installment payments
D.) Business that allows customers to carry a balance and make installment payments
33) Which filed in the SALES ORDERS table is foreign key? A.) SO number B.) SO date C.) Shipping D.) Customer ID
D.) Customer ID
39) Separating the database into related tables instead of using just one large table helps to eliminate A.) Deletion, update, and normalization problems B.) Update, insertion and creation problems C.) Insertion, update, and authorization problems D.) Deletion, update, and insertion problems
D.) Deletion, update, and insertion problems
17) Accountants may provide the greatest value to their organization by taking responsibility for data modeling. In which stages of the database design process does data modeling occur? A.) Only in the design stage B.) Only in system analysis stage C.) Only in implementation stage D.) In both system analysis stage and design stage E.) None of the above
D.) In both system analysis stage and design stage
22) In which of the following cases the relationship between entities is most likely NOT implemented by foreign keys? SEE PICTURE D.) Many to many relationship
D.) Many to many relationship
4) Which statement below is FALSE regarding the basic requirements of the relational data model? A.) Every column in a row must be single valued B.) All non-key attributes in a table should describe a characteristic about the object identified by the primary key C.) Foreign keys, if not null, must have values that correspond to the value of a primary key in another table D.) Primary keys can be null.
D.) Primary keys can be null.
3) Which is probably the most significant effect of database technology on accounting? A.) Replacement of double entry system B.) Change in the nature of financial reporting C.) Elimination of traditional records such as journals and ledgers D.) Quicker access to and greater use of accounting info in decision making
D.) Quicker access to and greater use of accounting info in decision making
19) A database model that represents all data as stored in 2 dimensional tables is the _______model A.) Tuple B.) Hierarchy C.) Object D.) Relational E.) Structured
D.) Relational
37) Nancy smith comes into espresso cage to provide her new address and you make the appropriate updates. When preparing a sales receipt for her a week later you notice nancy's old address appears on receipt. What does this indicate about the database? A.) The database is working correctly B.) Nancy smiths order was entered incorrectly C.) The same customer was entered into the database multiple times D.) The address info was updated for the wrong Nancy Smith
D.) The address info was updated for the wrong Nancy Smith
8) Concerning REA diagrams and relational databases, which of the following is TRUE? A.) Well designed relational database is the starting point for creating an REA diagram B.) A well designed REA diagram will result in the occasional update insert of delete anomaly problem in the relational database C.) Database design is generic for similar organizations D.) The design of a database is specific to the organization being modeled
D.) The design of a database is specific to the organization being modeled
9) Concerning enterprise wide REA diagrams which of the following is FALSE? A.) Merging 2 or more REA diagrams that contain the same resource entity does not require any changes to the cardinality pars in the individual diagrams B.) Merging 2 or more diagrams that contain a common event entity however often requires changing the minimum cardinalities associated w/ the other events to 0, to reflect the fact that the merged event may be connected to any one of several different events, but not to all of them simultaneously C.) The minimum cardinalities associated with agents may also have to be changed to 0. D.) all the above are true
D.) all the above are true
7) There are two basic ways to design a well-structured relational database. The method in which the database designer uses knowledge about how business processes work to draw a graphical picture of the elements to be included in the database is called A.) normalization B.) decentralization C.) geometric data modeling D.) semantic data modeling
D.) semantic data modeling
11) The concept of "duality" in the database means that and REA diagram must consists of ... A.) Two agents- one of them internal and the other external B.) Two events- one of them economic and the other support C.) Two resources- one increased and the other decreased by the same event D.) All of the above E.) None of the above
E.) None of the above
Database Picture..Edit
edit
