Multiple Choice

18.Consider the following SQL query. Which item best describes the results of the query?

SELECT VendorID, Sum(POTotal)

FROM [Purchase Orders]

GROUP BY VendorID

• Displays all purchase order lines for all vendors.
• Displays the vendor ID and all purchase order totals in the purchase orders table.
• Adds new purchase order information to the purchase orders table.
• Displays the vendor ID and the sum of all purchase order totals for that vendor.

19.Which of the following isnotone of the building blocks used for creating UML Class Diagrams?

• Associations.
• None of these other choices are used in UML Class Diagrams.
• Events.
• Classes.

20.Which of the following about cloud computing isincorrect?

• Data stored in a cloud computing system is always secure.
• If the internet connection goes down the system will not function.
• Cloud computing is Internet-based computing where shared resources, software, and information are provided to firms on demand.
• Cloud computing can easily host enterprise system applications.

23.Which of the following would beleastlikely to be represented with a Unified Modeling Language (UML) Class?

• Trucks
• Currency
• Bank Account
• Employees

27.Which of following are possible options for minimum multiplicities?

• 0 and 1.
• 0 and *.
• 0, 1, and *.
• * and 1.

29.Which of the following isnotone of the typical challenges organizations face when implementing an ERP?

• Successfully completing a large project in an organization.
• Integrating with external business partners' information systems.
• Installing the ERP software.
• Converting data from legacy systems to the ERP.