WGU C182 Exam Questions With Verified
Answers
What is technology used in creating, maintaining, and making information accessible? -
answerInformation Technology
What are the 4 steps in information processing? - answerInput, processing, output, storage
What is the collection of data and inform...
What is technology used in creating, maintaining, and making information accessible? -
answer✔Information Technology
What are the 4 steps in information processing? - answer✔Input, processing, output, storage
What is the collection of data and information used to support management of an organization
called? - answer✔Information System
What 5 attributes describe quality data? - answer✔relevant, timely, thorough, accurate, and
reliable
What are the 4 layers of the DIKW Hierarchy? - answer✔Data, Information, Wisdom,
Knowledge
What is the definition of data in the DIKW hierarchy? - answer✔Input directly received by a
human or computer
What is the definition of information in the DIKW hierarchy? - answer✔One or more processes
have been applied to data to transform if into a more useful form.
What is the definition of knowledge in the DIKW hierarchy? - answer✔Information that has
been put to use or a synthesis of multiple sources of information
What is the definition of wisdom in the DIKW hierarchy? - answer✔An understanding of "why".
This come with both knowledge and experience
Which component of a computer executes program instruction and command other various
components? - answer✔CPU
What stores the program being executed and the data that each program is using? -
answer✔Memory
What is a device that permits information to move between each component? - answer✔Bus
What about a bus determines how much data can be transmitted at one time? - answer✔The size
or width
What does OLAP stand for? - answer✔Online Analytical Processing
What does OLTP stand for? - answer✔Online Transaction Processing
What does OLDP stand for? - answer✔Online Data Processing
What is slicing? - answer✔Creating a subset of data by reducing the data from multiple
dimension to one dimension
What is dicing? - answer✔Creating a subset of data, even though it is still from multiple
dimensions
What is drilling down? - answer✔Shifting the view of data to include more detail
What is drilling up? - answer✔Shifting the view of data to less detail
What is a pivot table? - answer✔Rotates the view of data to a different perspective
What does SQL stand for? - answer✔Structured Query Language
What does the SELECT statement do in a SQL query? - answer✔Informs the database what field
or attributes are of interest
What does the FROM statement do in a SQL query? - answer✔Informs the database what tables
are to be interrogated and how will they be combined if more than 1 table contains data of
interest
What does the WHERE statement do in a SQL query? - answer✔Informs the database of specific
criteria the data should match and returned
What are 6 operators used in SQL commands? - answer✔= equal to
<> not equal to
> greater than
< less than
>= greater or equal to
<= less or equal to
What is the first step in the SDLC? - answer✔Preliminary Investigation
What does SDLC stand for? - answer✔System Development Life Cycle
What is the second step in the SDLC? - answer✔Analysis
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Brainbarter. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.49. You're not tied to anything after your purchase.
