Download IS 312 Final Exam Prep: Questions and Answers and more Exams Information Systems in PDF only on Docsity!
IS 312 Final Exam 2025 | All Questions
and Correct Answers | Latest Exam |
Just Released
Gal runs a music store. He has a desktop computer in the back room that acts as a server. He has a point-of-sale terminal that connects to the desktop. He also has a notebook (using in-store wireless access to the Internet) that can be carried around the store to look up current items in stock, or to search for items from one of his suppliers for special orders. Which type of network does Gal have? a) Client-server b) Mainframe-based c) LAN d) WAN e) Peer-to-peer ---------CORRECT ANSWER-----------------LAN Which of the following is not a communications channel? a) Fiber-optic cable b) Satellite transmission c) Twisted-pair wire d) Integrated circuits e) Cellular radio ---------CORRECT ANSWER-----------------Integrated Circuits
Data are sent through a fiber-optic cable by a(n) _______. a) Optical switch b) Electromagnetic switch c) Laser d) Multiplexer e) Optical modem ---------CORRECT ANSWER-----------------Laser Which of the following statements is not true? a) SQL is the most popular query language used for interacting with a database. b) SQL uses typical key words in a search. c) Keying in SQL terms is more difficult than utilizing QBE in a search. d) A user fills out a form to construct a description of the data desired in a SQL search. e) All of the choices are true. ---------CORRECT ANSWER-----------------A user fills out a form to construct a description of the data desired in a SQL search For the following entity-relationship diagram, an attribute you would NOT expect to see in the Computer entity is a) manufacturer.
_____ is the acquisition and efficient use of resources in accomplishing organizational goals. a) Operational control b) Management control c) Strategic planning d) Expertise e) Wisdom ---------CORRECT ANSWER-----------------Management control _____ attempts to find the value of the inputs necessary to achieve a desired level of output. a) What-if analysis b) Qualitative analysis c) Sensitivity analysis d) Goal-seeking analysis e) Simulation ---------CORRECT ANSWER-----------------Goal-seeking analysis _____________ collects, processes, stores, analyzes, and disseminates information for a specific purpose. a) Information Technology b) Network System
c) Information System d) Information Network ---------CORRECT ANSWER-----------------Information System What does a systems analyst do? a) Manages an IS service b) Writes computer code. c) Interfaces between end users and programmers d) Forecasts technology trends e) Creates Web sites and pages ---------CORRECT ANSWER-----------------Interfaces between end users and programmers The list of all your purchases from Amazon (books bought, price paid, dates) is defined as ___________. a) data b) information c) knowledge d) experience e) wisdom ---------CORRECT ANSWER-----------------information
D. The amount of data increases exponentially E. All of these are reasons why managing data is difficult over time --------- CORRECT ANSWER-----------------E. Is a formal approach to managing data consistently across an entire organization. A. Database management B. Enterprise information management C. Data warehousing D. Data governance E. Data mart ---------CORRECT ANSWER-----------------Data governance Organizations are turning to data governance for which of the following reasons? A. They have too little data B. They are responding to federal regulations C. Their data are typically structured. D. Their data are usually located in the organization's databases E. Data across their organizations are generally consistent ---------CORRECT ANSWER-----------------They are responding to federal regulations Occurs when various copies of the data agree. A. Data isolation B. Data integrity
C. Data consistency D. Data redundancy E. Application/Data Dependence ---------CORRECT ANSWER-----------------Data consistency You have a checking account and a separate savings account in your neighborhood bank. You've recently moved and gave the bank your new address for your checking account. You forgot all about the savings account. About three months later you receive a letter about your savings account which was sent to the wrong address. this is an example of? A. Data redundancy B. Data inconsistency C. Data isolation D. Data security E. Data dependence ---------CORRECT ANSWER-----------------Data inconsistency Place the following Members of the data hierarchy in their correct order. Bit, field, record, byte, database file ---------CORRECT ANSWER-----------------bit- byte-field-record-file-database An___ is a logical grouping of related fields. A. Byte B. Field
A. Attribute B. Entity. C. Primary key D. Object E. File ---------CORRECT ANSWER-----------------Attribute What are the three distinct characteristics that distinguish big data from traditional day? A. volume, variety and veracity B. volume, velocity and verification C. volume, velocity and variety D. volume, verification and variety ---------CORRECT ANSWER-----------------Volume, velocity and variety Which of the following actions is typical first step that an organization might take towards managing big data? A. Developing data warehouses for decision making B. integrating information silos into a database environment C. translating databases to No SQL. D. purchasing knowledge management systems ---------CORRECT ANSWER----------- ------integrating information silos into a database environment
The process of moving data from various sources into the data warehouse is called? A. uploading B. extraction, transforming and loading C. online transaction processing D. master data management E. online analytical process ---------CORRECT ANSWER-----------------extraction, transforming and loading ......is a process that helps organizations identify, select, organize, disseminate, transfer, and apply expertise that are part of the organization's memory and typically reside inside the organization in an unstructured manner. A. Discovery B. Knowledge management C. Decision support D Online analytical processing E. Data mining ---------CORRECT ANSWER-----------------Knowledge management ....refers to the range of frequencies available in any communications channel A. Protocol B. Broadband C. Capacity D. Narrow-band E. Bandwidth ---------CORRECT ANSWER-----------------Bandwidth
D. Gateway E. File server ---------CORRECT ANSWER-----------------Router A...allows a device to physically connect to a local area network's communications medium A. File server B. network interface card C. Network operating system D. Communications channel E. Gateway ---------CORRECT ANSWER-----------------network interface card The function of.....is to convert digital signals to analog signals and vice-versa. A. Modems B. Multiplexers C. Front-end processors D. Servers E. Clients ---------CORRECT ANSWER-----------------Modems Which of the following is not a communications channel? A. Fiber-optic cable B. Satellite transmission C. Twisted-pair wire
D. Integrated circuits E. Cellular radio ---------CORRECT ANSWER-----------------Integrated circuits The cable medium with the highest bandwidth is..... A. Twisted-pair wire B. Coaxial cable C. Fiber-optic cable D. Cellular radio E. Copper cable ---------CORRECT ANSWER-----------------Fiber-optic cable In order to ensure that computers developed by different manufacturers can communicate,..... have been developed A. Protocols B. Client/server architectures C. WANs D. Application software packages E. Developmental architectures ---------CORRECT ANSWER-----------------Protocols The part of a network that handles the major traffic is the.... A.Front end B. Network interface C. Multiplexer
A(n).....is a network designed to serve the internal informational needs of a single organization. A. Global network B. Extranet C. Internet D. Intranet E. World Wide Web ---------CORRECT ANSWER-----------------Intranet Internet service providers connect to one another through... A. Internet connection points B. Common carrier connection points C. Network access points D. Network connection points E. An extranet ---------CORRECT ANSWER-----------------Network access points ....portals offer content from diverse communities and are intended for broad audiences A. Industrywide B. Personal C. Affinity D. Corporate E. Commercial ---------CORRECT ANSWER-----------------Commercial
Which of the following would not be a typical key word in a SQL search? A. SELECT B. FROM C. QBE D WHERE E. All of the choices are typical key words ---------CORRECT ANSWER----------------- QBE ER diagram consist of entities, attributes and..... A. Business rules B. Data dictionaries C. Relationships D. Cardinality ---------CORRECT ANSWER-----------------Relationships At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship? A. one-to-one B. one-to-many C. many-to-one D. many-to-many E. some-to-many ---------CORRECT ANSWER-----------------many-to-many
D. they usually utilize quantitative models E. They support all phases of the decision-making process ---------CORRECT ANSWER-----------------They support only lower- and middle-level managers Searching for valuable business information in a database, data warehouse, or data mart is referred to as.... A. Structured queries B. Database queries C. Data mining D. Query by example E. Expert system queries ---------CORRECT ANSWER-----------------Data mining At the end of a semester, a student knows that she must achieve a grade of 81 or higher on her final exam to get an A in the course. She has just performed what kind of analysis? A. What-if B. Qualitative C. Sensitivity D. Goal-seeking E. Simulation ---------CORRECT ANSWER-----------------Goal-seeking In the....phase of the decision-making process, managers construct a model that simplifies the problem.
A. Implementation B. Choice C. Design D. Intelligence E. COnsideration ---------CORRECT ANSWER-----------------Design Digital dashboards provide all of the following capabilities except: A. drill-down B. transaction processing C. Status access D. Key performance indicators E. Exception reporting ---------CORRECT ANSWER-----------------Transaction processing The primary distinguishing characteristic of geographical information systems is.... A. every record or digital object has a unique identifier B. every record or digital object is visible to the users C. every record or digital object must be accessed by programmers D. every record or digital object has an identified geographical location E. every record or digital object is encrypted ---------CORRECT ANSWER----------------
- every record or digital object has an identified geographical location
