CIS Chap 2
Match each sector of the ICT industry on the left with its description on the right.
-Transmits electronic information from one place to another: Telecoms -Takes raw materials and makes them into hardware components: Manufacturing -Helps individual and businesses use computer technology: Support -Sells hardware and software from other companies directly to consumers: Retail -Businesses that users access through an app or web browser and run on the internet: Online & Cloud services -Creates applications for end users: Software publishing
Match each language to its general purpose in a website.
-Makes website elements interactive: JavaScript -Adds colors, fonts, and other design elements to website :CSS -Creates website structure and content: HTML
Match each protocol on the left to its description on the right.
-Verifies that each packet has been transmitted and received correctly: TCP -Encrypts and transfers hypertext pages on the World Wide Web: HTTPS. -Matches unique IP addresses with easy-to-read URLs: DNS -Transfers hypertext pages on the World Wide Web: HTTP -Divides files into packets and routes them through the internet to their destination: Internet protocol -Transmits packets in a continuous stream, but doesn't verify packets: UDP
After running the following pseudocode, what will the value of Variable be? 1. Set value of VARIABLE to 5 2. Increase the value of VARIABLE by 3 3. If the value of VARIABLE is odd, increase its value by 1 4. If the value of VARIABLE is even, increase its value by 1 5. If the value of VARIABLE is odd, increase its value by 1
10
Databases, authentication, and user accounts are all part of a website's _________.
Backend
The vast amount of data collected from internet searches, social media posts, customer transactions, military surveillance, medical tests, weather sensors, and other data sources are collectively referred to as _________.
Big Data
Which installation method often requires you to immediately install updates from the internet after installation is complete?
CD or DVD installation
Which hardware component processes data?
CPU
A service that lets you store data in a remote location over the Internet is called _______
Cloud storage
Which of the following stores data using microscopic light and dark spots?
Compact disc
What is the name of the large background area of the windows environment that holds icons for files, folders, and applications?
Desktop
___________ is a principle that limits access to certain parts of a program to public methods.
Encapsulation
In a relational database table, columns are better known as ______.
Fields
Designations at the end of file names such as .docx and .html are called ______.
File extensions
Which of the following is technically NOT a programming language?
HTML
Which of the following is NOT an optical storage device?
Hard disk
Match each item on the left to its appropriate category on the right.
Hardware: Monitor, Video game controller, touchscreen, power cable and RAM Software: Operating system, Internet browser and video game.
Which of the following is NOT one of the essential components of an information system?
Hyperlinks
Which installation method is most likely to put your computer at risk of downloading a virus?
Internet installation
If you select a file on the desktop and press "Delete" on your keyboard, what happens to the file?
It's moved to the recycle bin
Which of the following printer types is the fastest?
Laser Printer
Assigning a unique letter (such as N:) to a shared drive is called ____ the drive
Mapping
Which of the following is NOT an example of an operating system?
Microsoft
Which of the following is primarily operated by a touchscreen?
Mobile device
Microsoft's cloud storage service, which is automatically installed on new versions of windows, is called?
OneDrive
Which of the following components stores values in short-term memory?
RAM
Which of the following is a SQL statement?
SELECT * FROM Orders WHERE OrderID=5
Which of the following provides services to hosts on its network?
Server
On windows, which application lets you add accounts, change passwords, manage power consumption, and personalize your computer environment?
Settings
Which of the following methods will NOT open a file from the desktop?
Single-click the icon
What is the name of the menu in the bottom left corner of the Windows environment?
Start menu
Which of the following is a methodology used by system analysts?
System development life cycle (SDLC)
What is the name of the protocol suite used on the internet?
TCP/IP
What is the name of the dark strip along the bottom of the windows environment?
Taskbar
Which of the following developments in artificial intelligence has not happened yet?
Technological Singularity
Which of the following is an input device?
Touch screen
Which kind of connector is pictured here?
USB
Which type of connector is commonly used for keyboards and mice?
USB
Which of the following terms is most often used to describe a sequential or linear process of systems analysis and design?
Waterfall
Which application makes sure your computer has the most recent versions of its system software?
Windows update
Which of the following components is NOT required to create a network?
Wireless adapter
The _______ is an information system that connects documents to each other by hypertext links.
World Wide Web
Match each database object on the left to its description on the right?
-Formatted summary of information from a database: Report -User-friendly interface for adding to or retrieving information from a database: Form -Stores raw data in a relational database: Table -Retrieves specific information from a database. Can also be used to update, edit, and delete information: Query
Match each collaboration tool on the left tool to its description on the right.
-Software that keeps track of progress and assignments for large projects: Resource management -Software that allows multiple users to work on a document at the same time: Collaborative writing -Online forum where discussions consist of threads in response to an original post: Discussion board -Software that keeps track of multiple people's schedules: Calendaring -Broadcasting one user's screen to other users: Screen sharing.
Which kind of system software tells the computer how to communicate with peripherals, such as a printer or scanner?
Device drivers
Which kind of system software is preinstalled on electronic products like blenders, automobiles, and televisions?
Firmware
Which of the following should not be used as a primary key in a table?
First name
Which of the following uses persistent memory chips to store data?
Flash drive
A value that's used to identify a record from a linked table is called a _________.
Foreign Key
HTML and CSS are both part of a website's _______
Frontend
Computer programming is _________
Giving a computer precise instructions for what it should do.
Multiple computers configured to be able to communicate and share information with each other form a _________
Network
Which of the following IT jobs specializes in configuring communication hardware such as cabling, routers, and wireless adapters?
Network Architect
The idea of programming by modeling real-world things into computer code is called ________
Object-oriented programming
Which category of system software provides a platform for application software to run on?
Operating system
Keyboards, mice, speakers, microphones, and printers are collectively referred to as _______.
Peripherals
Which of the following commands makes an application shortcut appear on the taskbar?
Pin to taskbar
Which of the following is NOT a long-term storage device?
RAM
Which permission option lets a user view files but not change them?
Read
In a relational database table, rows are better known as ________.
Records
Software that requires a monthly subscription fee is often called ______.
Software as a service
Disk cleaners, antivirus software, backup tools, and file compressors are which kind of system software?
Utility software
Software that is delivered over the internet through a web browser are ________.
Web Applications
