Final Quiz: 12/12/17 Flashcards
What is NOT an advantage of ERP?
supports access control, security, version tracking of documents
Which of the following senses a person’s actions and, based on logical assumptions and prior experience, takes the appropriate action to complete the task?
AI
What does Microsoft produce and sell with computers and mobile devices?
software
A typical enterprise consists of wide variety of departments, centers, and divisions - collectively known as functional units.
True
What type of information is error free?
accurate
What type of information can be proven as correct or incorrect?
verifiable
Which of the following is an information system that captures and processes data from day-to-day business activities?
Transaction Processing System
Which of the following is an information that captures and stores the knowledge of human experts and then imitates human reasoning and decision making?
expert system
You have taken a temporary position as an IT consultant for a large firm with a variety of database solutions that you and your team are working to consolidate into one enterprise-wide solution. You are currently in the process of gathering information about where things stand with each of the individual database solutions.
database administrator
Who installs, configures, and maintains LANs and WANs?
network engineer
Which of the following is a collection of related records, as shown in the accompanying figure, stored on storage media such as a hard drive or on cloud storage?
file
Which of the following is a request for specific data from a database?
query
Which of the following languages consists of simple, English-like statements that allow users to specify the data to display, print, or store?
query
In a database which of the following is a connection within the data?
relationship
What type of database exists in many separate locations throughout a network or the Internet?
distributed
What is DBMS?
software
What is the smallest unit of data the computer can process?
bit
What is data redundancy?
Each department has its own files, so the same data might be stored in multiple files.
Which of the following is a nonprocedural language that enables users and software developers to access data in a database?
4GL
Data in a database is less vulnerable than data in file processing systems.
False
A working model of the proposed system’s essential functionality
proof of concept
The more errors that data contains, the lower this is.
integrity
This type of information can lead to incorrect decisions.
inaccurate
Eight bits grouped together in a unit comprise this.
byte
The collection and summarization of data, information, and deliverables.
documentation
What each byte represents in ASCII
character
What is done to a record so the DBMS will not process it again
flagged
A field that uniquely identifies each record in a file
primary key
Kind of rules that decrease data entry errors, and thus enhance the data’s integrity
validation
Performed by end users and checks the new system to ensure that it works
acceptance test
While a user is working with the database, this resides in the memory of the computer.
DBMS
Information that has meaning to the person who receives it.
useful
Whether designed for a small or large computer, most DBMSs perform common ones.
functions
Verifies that each individual program or object works by itself
unit test
This database capability is one of the most powerful database features.
querying
Verifies that all programs in an application work together properly.
systems test
Verifies that an application works with other applications.
integration test
In addition to storing data, a relational database also stores there.
data relationship
Has special keywords and rules that users include in statments
SQL
A group of related fields
record
Which of the following is a LAN that uses no physical wires?
WLAN
The design of computers, devices, and media in a network is categorized as either client/server or peer-to-peer. What is the term used to refer to this characterization?
network architecture
The type of network shown in the accompanying figure, describes a network in which each computer has equal responsibilities and capabilities. What is this kind of network called?
P2P
Which of the following is the data transfer rate equivalent to one million bits per second?
Mbps
Which of the following terms identifies any network based on the 802.11 family of standards?
Wi-Fi
Which of the following has the fastest transfer rate?
ATM
Which of the following enables a computer or device that does not have built-in networking capability to access a network?
NIC
Which of the following terms is an electrical disturbance that can degrade communications?
noise