MIS Expert Answers & Study Resources

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 11) A ________ is a networking device that detects the speed that a given device on a LAN can handle and communicates with it at that speed. A) switch B) bus C) SOHO LAN D) domain 12) The IEEE 802.3 protocol.

21) The VIEW tab is used to configure the appearance of Excel. A) True B) False 22) The HOME tab holds the most frequently used tools and selections. A) True B) False 23) You have entered a formula in the cell G9. Which of the following would occur if you press the F2 function key after.

56) Which of the following statements is true about protocols supporting Web services? A) XML is preferred for transmitting large volumes of data between servers and browsers. B) WSDL documents are read by developer tools to configure a programming environment. C) SOAP is a lower-level Internet protocol. D) The metadata in JSON is well-suited.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 30) The process of converting poorly structured tables into two or more well-structured tables is referred to as ________. A) replication B) normalisation C)actualisation D) integration 31) The data integrity problem can occur only if data are ________. A) replaced B) duplicated C) missing D).

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 7) Explain the database development process.     .

23) In Microsoft Access, a user has to define the relationships between tables before creating the tables. A) True B) False 24) In Microsoft Access, relationships can be defined by selecting the DATABASE TOOLS tab. A) True B) False 25) To create a relationship between one row of a table and an unlimited number of rows.

  23) The N:N notation indicates that the same number of entities are present on each end of the relationship. A) True B) False 24) 1:N means that more than one entity is allowed on each side of the relationship. A) True B) False 25) The crow's-foot notation shows the minimum number of entities that can be.

MULTIPLE CHOICE.  Choose the one alternative that best completes the statement or answers the question. 44) In Excel, ________ refers to whether the worksheet is printed normally or sideways on the page. A) orientation B) gridline C) alignment D) font 45) Which of the following is true about printing Excel spreadsheets? A) An option allows only the.

  9) Which of the following statements is true of ERP application programs? A) During the ERP development process, the development team sets configuration parameters that specify how ERP application programs will operate. B) There are virtually no limits to how much configuration can be done in an ERP application program. C) In order.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 43) The easiest time to change the database structure is ________. A) during the data modeling stage B) after creating database reports C) during the database designing stage D) after constructing the database 44) The easiest time to change the database.

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 28) What are the different types of relationships represented in a data model? 29) Explain the difference between maximum and minimum cardinality.     .

MULTIPLE CHOICE.  Choose the one alternative that best completes the statement or answers the question. 36) In Excel, if the user clicks the centre icons in the ________ section of the ribbon, the selected text will be centred both horizontally and vertically in the cell. A) alignment B) font C) styles D) editing 37) Selecting the.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 4) Which of the following is an example of a supply chain activity? A) sales prospecting B) procurement C) cash management D) scheduling 5) Which of the following is a manufacturing activity that must be included in a true ERP product? A).

47) Differentiate between private and public IP addresses. 48) What is a domain name? What is the procedure to get a domain name?     .

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 44) Data can be transferred from Excel to Access by creating a ________, which is a subset of the cells in a worksheet that has a unique name. A) specified label B) consolidation table C) named range D) calculated column 45).

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 49) Give a brief description of Microsoft's ERP products. 50) Give a brief description of Infor's ERP products.     .

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 43) How can Excel be used to graph Access data?     .

45) SAP's ERP products are relatively economical compared to other companies' products. A) True B) False 46) Infor Business Cloud is available as IaaS (infrastructure as a service). A) True B) False 47) PeopleSoft is an HR product developed in-house by Oracle. A) True B) False 48) Sage offers some components of its ERP products on the cloud as.

16) In Excel, the most frequently used tools and selections appear under the ________ tab. A) HOME B) DATA C) VIEW D) REVIEW 17) To save a worksheet in Excel, the Save option in the Edit menu is used. A) True B) False 18) In Excel, the wide bar of tools and selections that appears just under the.

  40) By default, for queries of two or more tables, Access shows only those rows that have value matches in both tables. A) True B) False 41) To create a report with data from two or more tables, we must use the ________. A) Report Design B) SharePoint lists C) Navigation tab D) Report Wizard 42) Which of.

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 41) How is a data model transformed into a database design? 42) What are the steps involved in transforming a data model into a relational database design?     .

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 51) Which of the following purposes does an HTTP protocol serve? A) determine IP address of devices on a network B) enable communication between programs C) provide reliable network for data communication D) divide network traffic into packets 52) The "S".

6) With a WAN, an organisation can place communications lines wherever it wants because all lines reside on its premises. A) True B) False 7) A protocol is a set of rules that programs on two communicating devices follow. A) True B) False 8) A LAN would be used to connect computers located in Seattle and.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 36) ________ offers ERP software particularly for businesses in construction and real estate, and for non-profit organisations. A) Infor B) SAP C) Sage D) Oracle 37) In the future, which of the following Microsoft products is likely to be a true.

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 45) Explain the role of users in designing a database.     .

  21) Which of the following statements is true of cable lines? A) Cable lines generally use standard protocols. B) Performance of cable lines is stable irrespective of the number of users sending and receiving data. C) Cable lines provide high-speed data transmission using telephone cables. D) The signals from cable modems do not interfere.

  18) Thin-client mobile applications can be differentiated from native mobile applications in that thin-client mobile applications ________. A) run only on the operating system for which they are programmed B) are limited by the capabilities of the browser C) are usually developed using Objective-C, Java, or VB.Net D) are developed by professional programmers only 19).

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 8) Which of the following is a highly popular technique for creating a data model with which the developers describe the content of a database by defining what is to be stored in the database and.

  16) Devices such as wireless mice and keyboards use ________ to connect to the computer. A) broadband B) Bluetooth C) routers D) cables 17) Which of the following protocols is commonly used by wired LAN? A) EVDO B) DSL C) IEEE 802.3 D) WiMax 18) Which of the following is the protocol commonly used for wireless LAN? A) LISTSERV B) IEEE 802.3 C).

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 39) How are group totals created in Access?     .

  35) Normalisation is the process of converting a poorly structured table into two or more well-structured tables. A) True B) False 36) The data integrity problem can occur only if data are missing. A) True B) False 37) The general goal of normalisation is to construct tables such that every table has a single topic or.

  14) ERP vendors design application programs to be configurable so that development teams can alter them to meet customer requirements without changing program code. A) True B) False 15) An ERP solution includes a database design, initial configuration data, and the company's operational data. A) True B) False 16) Stored procedure is a computer program stored.

  13) Import/export is the process of transferring data from one computer system to another. A) True B) False 14) In Excel and Access, import/export maintains an active connection to the source of the data. A) True B) False 15) If users change the Access data, the imported data in Excel will be out-of-date until it is.

  38) ________ is the language that is commonly used for coding Web pages. A) VPN B) DSL C) XML D) HTML 39) Which of the following is the second tier in the three-tier architecture arrangement? A) server tier B) database tier C) user tier D) client tier 40) A ________ receives requests from users via the Web server, takes some.

  13) In a university, each adviser can advise multiple students, but each student can have only one adviser. In a data model, this can be best represented by a(n) ________. A) N:M relationship B) 1:N relationship C) 1:1 relationship D) N:N relationship 14) A(n) ________ notation signifies that an adviser can be related to many.

ESSAY.  Write your answer in the space provided or on a separate sheet of paper. 9) What is a spreadsheet? 10) Explain the process of naming the rows, columns, and cells in Microsoft Excel.     .

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 29) Differentiate between native and thin-client mobile applications.     .

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 3) What is the primary purpose of an ERP system?     .

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 33) In Microsoft Access, the Totals button is present in the ________ section of the Design tab. A) Query Setup B) Query Type C) Import/Export D) Show/Hide 34) An organisation stores the details of its employees using Access. The Employee table.

5) In Excel, the intersection of a row and a column is called a ________. A) gridline B) cell C) ribbon D) node 6) The rows in an Excel spreadsheet are identified by letters, and the columns are identified by numbers. A) True B) False 7) An Excel workbook is a collection of one or more spreadsheets. A) True B).

  18) Entities have attributes that describe characteristics of the entity. A) True B) False 19) An identifier is an attribute whose value is associated with every entity in the data model. A) True B) False 20) Entities have relationships to attributes but not to each other. A) True B) False 21) In an entity-relationship (E-R) diagram, a line is.

49) What are the different tiers in the three-tier architecture? 50) What is the difference between a Web server and a commerce server?     .

1) ________ is a suite of applications, a database, and a set of inherent processes for consolidating business operations into a single, consistent, computing platform. A) Customer relationship management B) Warehouse management system C) Enterprise resource planning D) Supply chain management 2) The primary purpose of an ERP system is integration. A) True B) False     .

  23) Native mobile applications can be developed by technically oriented Web developers and business professionals. A) True B) False 24) Professional programming languages such as Objective-C and VB.Net are preferred to develop thin-client mobile applications. A) True B) False 25) The limits on native applications are usually budgetary and not technological. A) True B) False 26) Thin-client applications are.

6) In Microsoft Access, the Description of fields is used to ________. A) define rules for how each field should behave B) document the details of each field C) specify the data types of the fields D) define how the fields should behave in case of exceptions 7) Which of the following is a valid.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 40) Which of the following shows the correct sequence of steps for formatting the currency values in Microsoft Excel? A) Data ? Editing ? Currency B) Home ? Number ? Currency C) Data ? Number ? Currency D) Home ?.

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 35) All modern DBMS products can process the ________ query language. A) DB10 B) MySQL C) HTML D) SQL 36) Which of the following statements is true about queries in Access? A) Queries can include fields from only one table. B) Only rows.

  11) Access opens a new database by creating a default table named Table A. A) True B) False 12) In Access, to modify the design of a default table, one must select the Relationships option in the DESIGN tab. A) True B) False 13) Every field in Microsoft Access must have a Description associated with it. A).

ESSAY. Write your answer in the space provided or on a separate sheet of paper. 45) What is the TCP/IP Protocol architecture? Where is the application layer protocol? 46) What is HTTP? How does it work?     .

2) Which of the following is true of a data model? A) It is created after the database is designed. B) It is a logical representation of the structure of data. C) It is an attribute whose value is associated with only one entity instance. D) It does not describe the relationships among data. 3).