C182 Practice Exam A

C182 Practice Exam A 2023 Marcus has a summer job working at a real estate agency. He is entering client addresses into the company's computer system. At which stage of the DIKW hierarchy is Marcus working? a) data b) information c) knowledge d) wisdom a) data Which of the following statements describes the difference between information systems and information technology? a) There is no difference between information systems and Information Technology. b) An information system does not have to use computer hardware or software; whereas information technology requires the use of hardware and software. c) Information Technology is a broader concept and information systems provide the infrastructure for information technology d) An information system requires the use of computer hardware and software; whereas information technology refer only to networks and tools that facilitate communication b) An information system does not have to use computer hardware or software; whereas information technology requires the use of hardware and software Which of the following statements best represents the relevant characteristic of quality data? a) The data used applies to the question being andwered b) The data has been gathered using consistent, detailed collection processes c) The data has been inputted correctly and is accurate for its intended use d) The data is current enough to still serve its purpose for being accessed a) The data used applies to the question being answered __________ software works with hardware to provide a network service a) application b) windows operating system c) database management system d) windows server c) windows server In the _____________ design phase of the SDLC (system development life cycle) the system is described in abstract terms using modeling such as flowcharts, UML and entity-relationship diagrams a) analysis b) logical c) physical d) maintenance b) logical With _____ individuals no longer have to purchase hardware and software to manage tasks such as word processing, payroll, and e-mail a) SaaS(software as a service) b) IaaS(infratstructure as a service) c) PaaS(Platform as a Service) c) PaaS (Platform as a Service) With ____ an IT department resources (i.e. servers, data storage) are located outside of the organization and are accessible by anyone, anywhere a) SaaS(software as a service) b) IaaS(infratstructure as a service) c) PaaS(Platform as a Service) b) IaaS(infratstructure as a service) During this phase of Project Management, the projects scope and requirements are defined a) Executing and Controlling b) Initiation phase c) planning phase d) closing phase b) initiation phase This server addresses protocols such as: IMAP, POP3, SMTP, HTTP, MAPI, and MIME (email protocols) a) Web Server b) eMail server c) FTP server d) File server b) eMail server This type of software is made freely available as source code a) open source software b) public domain software c) shareware software d) freeware software a) open source software The ______ keyword in SQL is used to inform the DBMS what fields or attributes are of interest (and where they are located, i.e. which table/relation they can be found in) a) FROM b) SELECT c) WHERE b) SELECT The _______ keyword in SQL is used to inform the DBMS what tables are to be interrogated by the query and, if more than one table contains the data of interest how they are to be combined or joined a) INTO b) WHERE c) SELECT d) FROM c) SELECT A collection of organized databases is called? a) a database Management System b) a high-level program c) a data warehouse c) a date warehouse Which are both types of scripting languages? a) ASP and Python b) C++ and Pascal c) Python and C++ d) Pascal and ASP a) ASP and Python Which of the following aligns IT goals and organization goals? a) breaking organization goals into smaller goals will not relate to IT activities b) improving IT infrastructure to support rapid expansion to capture less market share c) IT goals include cloud computing and organization goals include real-time communication to contain costs while scaling quickly d) ensuring privacy and security of data shared by customers using cloud computing c) IT goals include cloud computing and organization goals include real-time communication to contain costs while scaling quickly During which generation did computers begin to see widespread use in business? a) Fourth generation b) First generation c) Third generation d) Second generation c) Third generation Which of the following best describes the purpose of expansion slots in modern computers? a) Expansion slots can be used to store programs and data b) Expansion slots allow additional processors to be connected to the mother board c) Expansion slots can be used to connect additional peripheral devices such as an external hard drive or monitor d) Expansion slots allow additional cards to be connected to the motherboard that interface with peripheral devices d) Expansion slots allow additional cards to be connected to the motherboard that interface with peripheral devices Which of the following statements best defines the CPU? a) The CPU outputs the raw computer data, including mathematical calculations and logical operations b) The CPU controls the speed at which instructions are retrieved and processed in the computer c) The CPU is responsible for storing data as it is being processed d) The CPU retrieves the instructions of a computer program and the raw data that is input b) The CPU controls the speed at which instructions are retrieved and processed in the computer Which of the following is an example of what 1gb would store? a) a large text file b) an mp3 file of a song c) a library of movies d) thousands of books d) thousands of books Which of the following statements accurately describes random access memory (RAM)? a) RAM can be read but not written to b) RAM is short-term memory c) RAM is found in the ROM chip on the mother board d) RAM is storage for instructions that the computer needs to boot up b) RAM is short-term memory Which is found on the motherboard and stores information but the information is not permanent? a) CPU b) RAM c) Bus d) ROM b) RAM What peripheral component houses CDs and DVD