C182 Practice Exam a Questions and
Answers 100% Verified.
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 - Correct Answer- 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 -
Correct Answer- 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 - Correct
Answer- 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 - Correct Answer- 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 - Correct Answer- 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) - Correct Answer- 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) - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- c) SELECT
Answers 100% Verified.
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 - Correct Answer- 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 -
Correct Answer- 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 - Correct
Answer- 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 - Correct Answer- 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 - Correct Answer- 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) - Correct Answer- 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) - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- 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 - Correct Answer- c) SELECT
