Study sets, textbooks, questions
Upgrade to remove ads
IT Fundamentals Final
Terms in this set (108)
How many data types would be required to store the following entry in a database? 3.87
One data type would be required. A floating point data type would be used because the number includes a decimal.
The volunteer is expected to answer questions with a simple yes or no. What data type would be most effective in storing the answers to these questions?
It is most important to ask which of the following questions before designing a database?
What is the purpose of the database, and how will it be used?
What type of database allows new tables to be created out of information that is requested in a search of the database?
What type of database organizes data in a tree-like or organizational chart type structure?
If a relation contains five records for individual songs and each of the records has data entered for the artist, duration, and release year, these three categories are ________of the records.
Which of the following is a common example of a type of software that uses flat file structuring?
Alicia is working with a database relation that contains data about the litters of puppies that her dogs have had over the years. Each row in the relation represents a litter of puppies and contains information about the number of puppies, when they were born, and how much they weighed at 6 weeks of age. In such a relation, each row of data about a litter of puppies is known as a
Kevin is doing some unique database research. He wants to evaluate whether there is any significant connection between the color of an individual's car and how likely the individual is to receive a speeding ticket. He has access to databases with all the information he needs about individuals and their vehicles, but the color of the vehicle is in the vehicle registration database relation while the ticket information is in a separate database relation for traffic violations. Fortunately, both relations include the unique vehicle identification number (VIN) as the primary key. What query tool can he use to return information from both relations at the same time so that he can see the vehicle color information alongside of the ticket information in the same table?
When a join operation is used in a query, the records from different relations must be associated through the use of a field with unique values for each and every record. What is the name of that field?
Which task is not associated with managing a DBMS?
account creation, installation, performance analysis. All of these are associated with managing a DBMS.
Which of the database administrator's roles requires a special set of skills that includes database modeling, schema development, normalization, and performance tuning?
application design and development
One of the main purposes of a BI system is to improve the________of the information that is used to make strategic decisions.
Timeliness and quality
The supermarket where Victor works as a manager collects large amounts of data about sales, inventory, customers, and other related aspects of their operations. They have invested in an advanced database system that uses product barcodes to track sales and inventory. They have also purchased an additional software application program that tracks customer purchases on an individual basis using loyalty cards at the checkout locations. They also have separate records of all the promotions and sales they have implemented over the years. How do these data collection processes relate to the potential implementation of a BI system?
A BI system would be very helpful because it would be able to integrate these various sources of data into one database that could be organized and interpreted much more usefully.
Evan wants to integrate the data from numerous databases into a single data warehouse. He recognizes that he will need to develop a system that can extract data from many different sources and then load that data into the data warehouse. What other important step does he need to consider and develop for this process?
The data extracted from the various sources must be formatted consistently to fit the format of the warehouse.
When data from a data warehouse is utilized and processed, what useful step is often done with the resulting information?
It is often stored back in the data warehouse as data for future use.
Answering which of the following questions would be enabled by OLAP software?
If the unemployment rate decreases 1% and the housing market increases by 2%, how will demand for our construction services be affected?
A candy store has records of all the different sales it has made over the past three years. The types, colors, quantities, and names of the candies sold each day are recorded. The owner of the store uses OLAP operations to show only the colors of candies purchased during the month of December over the past three years. He plans to purchase greater quantities of those colors during the next December period. What OLAP operation was used in this research?
What type of data processing is defined by the fact that it takes place in real time?
What type of processing takes place based on the occurrence of a certain event rather than a user command or the arrival of a scheduled point in time?
What is needed in order for an ODBC compliant application to communicate understandably with a database?
a database driver
JDBC is a driver used for applications written in what language?
What change in how applications handle data has provided the advantage that changes can be made to the data without the need to rewrite the application?
Applications today do not store data themselves, but rather the data is stored in separate databases
What basic SQL command can be used to specify that the query should only return data from records where the field "last_name" begins with a certain letter?
Which of the following data manipulation techniques will allow for modifications to columns in an existing table?
ALTER TABLE command
What would the following table modifying command do?
ALTER TABLE students ADD homePhone STRING(10)
add a new field to the table students
SQL commands can be used for which of the following database language types?
DDL, DML, DQL, all of the above
Which component is responsible for commanding the other components of the computer?
Disk drives form a part of what component?
What is stored in the memory of a computer?
The programs currently being executed and the data used by those programs.
What component consists of wires that allow electrical current to flow between components?
Which basic hardware component might include sticks of SRAM or DRAM?
Which of the following internal components is not housed directly in the motherboard?
What motherboard component usually has a heat sink and fan on it to distribute the heat it produces?
Which part of the processor does the actual processing operations?
What unit for measuring the speed of a processor is equivalent to a billion processes per second?
What are the two main forms of random access memory?
DRAM and SRAM
How long does ROM memory retain its contents?
It retains information indefinitely.
Why is information stored in RAM generally faster to access than information stored in other forms?
Because information can be recalled from RAM at the same speed regardless of where it is stored.
What term is used to refer to forms of storage that do not retain their information when the power to the system is lost?
Which of the following is a form of volatile storage?
RAM memory is used when data is being processed, and________storage is designed to store information even when the computer is off.
Which of the following peripheral devices would be appropriate for use in the first step of the IPOS cycle?
A speaker is what type of peripheral device?
A computer user has provided input, and the computer system has completed its processing functions, but the user does not have an immediate use for the information that resulted from the processing. What type of peripheral device might then be used for the next step of the process?
a hard drive
What component of the motherboard is designed to allow the system to extend its capabilities and perform new operations it was not previously capable of doing?
What are two ways that peripheral devices might be connected to the system unit?
through physical wiring or through wireless network connections
What are computer ports used for?
connecting additional input, output, and storage devices
In a laptop computer, where are internal components such as the motherboard, hard drive, and other peripherals located?
It is beneath the integrated keyboard.
Which of the following is one common way in which many mobile computing devices are designed to be more transportable?
They generally have less storage capacity than desktop computers.
They generally have slightly less powerful processors than desktop computers.
They often, though not always, combine input and output functions into one single peripheral device.
all of the above
A certain computer user is trying to decide what platform would best fit his needs. He has a use for a computer device very frequently throughout each day for tasks that require minimal computing power, such as managing team communication channels. Mobility is critical because his daily routine usually carries him to numerous locations rather than keeping him in one place. What platform will best meet his needs?
In many mobile devices, what manual pointing device sometimes replaces the mouse and allows you to enter data, select items, and give commands by touching the screen with it?
Which of the following is not a characteristic of first generation computers?
They were not programmable.
Which of the following were key technological advances introduced during the second generation of computers?
transistors and magnetic core memory
During the third generation of computers, an organization that previously would not have been able to consider the purchase of a computer now felt that perhaps the lower costs of the new computer models might make the purchase of one a reasonable consideration. The organization would have a few dozen users, and they would not need as much computer processing power as the most powerful models provided. What type of computer model should they consider purchasing?
What was the defining characteristic of a microprocessor?
It was built around a single chip rather than numerous chips.
What type of memory stored information by having individual rings with a current that rotated either clockwise or counterclockwise?
magnetic core memory
How often did Moore's original observations predict that the transistor count on computer chips would double in number?
What type of language is exemplified in the following sample: 0011011011010001
Which of the following is not an example of a type of language translator program?
After machine language, what is the next most basic type of programming language, which still uses many length strings of numerals and cryptic language, but does at least make use of some abbreviations of English words and commands?
What type of language needs a compiler in order to become executable?
high-level languages to machine language
In object-oriented programming, what is the relationship between objects and variables?
Variables are single values, whereas objects are single entities that contain multiple variable values as their own characteristics.
What term is used to describe a program in which the sequential order of the lines is severely mixed up by excessive use of GOTO statements?
An IT administrator is attempting to write a short program to fix a security issue that he has discovered. However, when he attempts to execute his new program, he receives the message that some of the class names he used are undefined, and the program does not run. What kind of language must he be using, and why?
A compiled language; because it requires that all parts of the program be defined before the program can run.
What advantage does an interpreted language have compared to a compiled language?
An interpreted language allows for the testing of partially completed programs, speeding the code development process.
Kevin's work situation sometimes allows him the flexibility of working from home. When he does so, he accesses his workstation at the office by logging on to it through the Internet. While he is using his workplace computer from home, his workplace computer is what type of computer in relation to him?
Which of the following is not a common way to view a computer network?
the user interface level
Fiber optic cables transmit what type of signal in place of electromagnetic waves?
Which of the following is not a network device that may be used to connect multiple computers together?
a network hub, a network switch, a router
All of the above are used to connect multiple computers together.
Which of the following is a significant example of a circuit switched network?
Which of the following is a factor in the pathway chosen in a packet switched network?
other message traffic on the network
Why is a switch able to utilize bandwidth more efficiently than a hub?
Because it recognizes the intended recipient for a particular message and is able to direct that message only towards that single device.
Which of the following is a common trait of both routing and switching?
Individual device addresses are used to direct messages.
A server provides information to what type of computer?
Which of the following correctly describes the characteristics of most servers?
Servers generally need to be more powerful machines with greater disk storage and faster response times.
How do virtual machines relate to operating systems?
Virtual machines allow users to emulate various operating systems on a single computer.
A virtual machine falls into which of the following categories?
What type of server may be used to support both application software and data files but usually is limited to serving requests only from clients within the local network?
Why are servers sometimes built into cabinets?
to allow for large numbers of components to be inserted, such as numerous hard disk drives for large storage capacity
Kyle is wanting to create a simple network between a few devices. He needs the network to be reliable even if one of the devices fail. The devices will not be creating large volumes of traffic. The most important factor in his decision making process is cost, which needs to be low. What is probably the best network topology for his needs?
How does a DNS relate to how a user interacts with IP addresses?
A DNS converts an English-like name provided by a user to its corresponding numerical IP address so that the user does not have to remember the numerical form.
What part of an incoming packet does a router examine in order to determine the next location to send it to?
destination IP address
When a large message is broken down into multiple smaller message units which are sent across the Internet to their destination individually, what are the individual units called?
What device connects a computer or computer network to the Internet?
What kind of tables does a DNS have?
tables that contain host IP addresses and their corresponding aliases
Which of the following steps comes first in the process of communicating a message over the Internet?
The message is placed into packets.
What is the major advantage for communications provided by DNS services?
Users are far more likely to remember names for websites rather than the lengthy numerical addresses that would be needed without DNS services.
Which of the following is not a common top-level domain name for websites hosted in the United States?
What symbol(s) separate(s) the domain name portion of a URL from the resource ID portion?
a slash (/)
What are the two categories of concern in IAS?
security and assurance
Which of the following is not a concern related to data integrity?
Data must be stored in such a way that access is denied to those who should not see it, but is available to those who need to use it.
Lisa is in charge of employee payroll for her company. Sensitive personal employee information must be collected for payroll purposes, including such things as addresses, social security numbers, and retirement account information. Lisa is one of only two employees in the company who have access to the password protected files where the information is stored. She is able to access that information either from a secure workstation at the office or through secure remote access from her personal computer at home. She is able to make changes to the information in those files, but those changes are always recorded and documented. If she opens one of the sensitive files, the other employee who has access to it cannot alter it in any way while she is using it. What is the violation of IAS principles in this scenario?
There are no obvious violations of IAS principles in this scenario.
What is the first step in strategic risk analysis?
identifying information assets
Which of the following is an example of public information?
an employee's address
True or false. Phishing is an example of social engineering.
Alan is a web administrator and he is facing a problem with one of his servers. He cannot get it to respond to requests the way it should. When he logs directly into the server and explores the situation, he finds that millions of requests are flooding the server from the same few machines over and over again so that it cannot handle the volume of activity. What type of attack is Alan dealing with?
a denial of service attack
What is a grey-hat hacker?
a hacking professional who hacks for both "good and bad purposes"
What type of malware is usually downloaded unknown to the user and observes the user's activities in order to gain sensitive information that the user might enter in regular activities?
Anti-malware software can be configured to run on-demand, but what is another common approach to configuring when it is to run?
It can be configured to scan every incoming message.
What type of security software prevents certain types of messages from coming into or out of the network?
Which of the following is not a common basis for authenticating identity?
In what type of access control is a user's access defined; according to which preset category best describes his function in the organization, such as a supervisor, manager, or analyst?
role-based access control
The many parties involved in a business setting can mutually benefit from one another in their activities, but only if they are connected through some sort of
What term refers to the interdependent and constantly developing relationships between customers, suppliers, employees, and others involved in the business process?
Which of the following statements accurately describes the benefits of computer networks in business settings?
In most business settings, computer networks provide many significant benefits, but there is always a need to be aware of the increased risk associated with them.
Why might a company's software expenses decrease if they implement a computer network for their office?
They can potentially share software over the network rather than purchasing copies of the software for each user.
A computer network can increase the productivity of an employee traveling to attend a conference. True or false?
Other sets by this creator
OB- Ch 13-15
IT fundamentals final 2
Other Quizlet sets
chapter 9 antient history quiz
Tech Tools for Engagement PL
Is it possible for two screw dislocations of opposite sign to annihilate each other? Explain.
A spacecraft with a mass of 800 kg is traveling in a circular orbit 6000 km above the earth. It is desired to change the orbit to an elliptical one with a perigee altitude of 3000 km. The transition is made by firing the retro-engine at A with a reverse thrust of 2000 N. Calculate the required time t for the engine to be activated.
A vapor-compression refrigeration system for a household refrigerator has a refrigerating capacity of 900 Btu/h. Refrigerant enters the evaporator at $-15^\circ F$ and exits at $20^\circ F.$ The isentropic compressor efficiency is 75%. The refrigerant condenses at $110^\circ F$ and exits the condenser subcooled at $100^\circ F.$ There are no significant pressure drops in the flows through the evaporator and condenser. Determine the evaporator and condenser pressures, each in $lbf/in.^2,$ the mass flow rate of refrigerant, in lb/min, the compressor power input, in horsepower, and the coefficient of performance for working fluids: (a) Refrigerant 134a, (b) propane.
A mechanic claims to have developed a car engine that runs on water instead of gasoline. What is your response to this claim?