Intro to IT D322 Flashcards
What is the definition of information technology (IT)?
It is the technology used to create, maintain, and make information accessible.
Which IT position has the responsibility of working with routers and switches?
Network Administrator
In which generation were silicon chips first used in computers?
Third generation
Which low-level language corresponds one-to-one with assembly?
Machine language
What is a cloud model that delivers third-party software such as email or games through the internet?
SaaS (Software as a Service)
What is one of IT’s roles in globalization?
It allows companies to reach a wider customer base.
Which category of computer has an external flat screen monitor, optical disk drive, and a large capacity hard drive?
Desktops
Which two software application packages would be classified as productivity software?
Word processors & spreadsheets
Which two computer peripherals are connected to the computer through a port?
External microphones & USB flash drive
Which term is defined as a collection of information used to support management of an organization?
Information System
A website logs the timestamp, location, and browser of every visitor. It then aggregates this content into peak traffic times and days, minimum and maximum hits for each country and region, and popularity of certain browsers among visitors. What is the timestamp considered in this scenario?
Data
A departmental manager is creating a budget estimate for the upcoming year. The manager would like to determine whether the data will be available when the decisions for the next year have to be made. Which characteristic of valuable data is the manager considering?
Timely
Which two are parts of an information system?
Networks and Databases
What is the difference between processing and storage?
Processing collects and translates data into useful information, while storage places the translated data in specific locations.
Which is a benefit of multiple interconnected computers (distributed) versus mainframes or large computers?
Costs for hardware resources are decreased.
Match each description with the type of computing ecosystem it describes. Answer options may be used more than once or not at all. Select your answer from the pull-down list.
One computer will request information from another computer, which responds with requested information.
A software emulator program that permits a computer user to use multiple computers and multiple platforms without the expense of purchasing multiple computers.
Each computer is roughly equal to every other computer.
One computer will request information from another computer = Client-server
A software emulator program = Virtual machines
Each computer is roughly equal to every other computer = Peer-to-peer
Which data type is used to represent product order code that comprises alphanumeric characters?
String
Armando is a freelance graphic designer. He has decided to create a database of the artwork he has done throughout the years. Each of his pieces of art is sorted using an assigned name and number. Which data type will be required in order to create his database?
Character string
Why is it important to ensure that data support business goals?
To aid in making strategic decisions
In which category of the Data, Information, Knowledge, Wisdom (DIKW) hierarchy would business intelligence be located?
Knowledge
Which field must contain a unique value in order for a relational database table to function?
Primary Key
What are the three main categories of databases?
Flat File, Relational, Hierarchal
What is the database administrator’s role in security?
To institute protocols to protect the databases from external threats.
What is the role of drivers in facilitating communication between applications and databases?
They allow the application to interact with the database.
Which SQL clause is used to inform the database management system (DBMS) which tables should be interrogated by the query?
FROM
Which statement correctly describes the operating system?
Allows the user to control the actions of the software, and through the software, to access hardware.
Which action by application programs requires support from a networked operating system?
An Internet browser displays a web page.