Ch 6 Info 3130
T or F The Domain Name System (DNS) converts IP addresses to domain names.
F
In Europe, and much of the world, the standard for cellular services is:
GSM
Which digital cellular standard is used widely throughout the world except the United States?
GSM
Which of the following enables users to view the same data in different ways using multiple dimensions?
OLAP
Which of the following is not a characteristic of packet switching? -Packet switching requires point-to-point circuits. -Packets are routed through many different paths. -Packets include data for checking transmission errors. -Packet switching makes efficient use of a network's communications capacity. -Packets travel independently of each other.
Packet switching requires point-to-point circuits.
The most prominent data manipulation language today is
SQL
T or F Data governance deals with the policies and processes for managing the integrity and security of data in a firm.
T
T or F In a client/server network, a network server provides every connected client with an address so it can be found by others on the network.
T
T or F In-memory computing relies on a computer's main memory for storing data.
T
T or F Two computers using TCP/IP can communicate even if they are based on different hardware and software platforms.
T
Which of the following best illustrates the relationship between entities and attributes? -The entity PRODUCT with the attribute PURCHASE -The entity ADDRESS with the attribute CUSTOMER -The entity PRODUCT with the attribute CUSTOMER -The entity CUSTOMER with the attribute ADDRESS -The entity CUSTOMER with the attribute PRODUCT
The entity CUSTOMER with the attribute ADDRESS
In a relational database, a record is referred to in technical terms as a(n)
Tuple
Relational database systems use ________ to ensure that relationships between coupled tables remain consistent.
referential integrity rules
In a relational database, the three basic operations used to develop useful sets of data are
select, project, and join
The child domain of the root is the
top-level domain
In the US cellular (verizon)
CDMA
Access is a:
DBMS for desktop PC systems.
The confusion created by ________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.
Data Redundancy
Which of the following best describes the importance of creating an accurate data model for your business's database? -It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve. -It is essential, as table relationships cannot be created without an accurate data model. -It is unnecessary, as a well-designed database should not require one. -It is not essential, as the data model itself is modified by the database continuously. -It is somewhat important, as the type of data model will define what kinds of data will be stored.
It is critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve.
A field identified in a table as holding the unique identifier of the table's records is called the:
Primary Key
Which of the following is the type of logical database model that treats data as if they were stored in two-dimensional tables? -Open source DBMS -Pre-digital DBMS -Relational DBMS -Hierarchical DBMS -Two-tiered DBMS
Relational DBMS
In a table for customers, the information about a single customer would reside in a single:
Row
The "Internet of Things" refers to:
a vision of a pervasive web in which common objects are connected to and controlled over the Internet.
In the domain name "http://books.azimuth-interactive.com", which element is the second-level domain?
azimuth-interactive
Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:
business intelligence.
The Internet is based on which three key technologies?
client/server computing, packet switching, and the development of communications standards for linking networks and computers
The select operation:
creates a subset consisting of all records in the file that meet stated criteria.
The data dictionary serves as an important data management tool by
creating an inventory of the data elements contained in the database.
DBMS typically include report-generating tools in order to:
display data in an easier-to-read-format.
A schematic of the entire database that describes the relationships in a database is called a(n):
entity-relationship diagram.
Data mining is a tool for allowing users to:
find hidden relationships in data
A VPN
is an encrypted private network configured within a public network.
A DBMS reduces data redundancy and inconsistency by
minimizing isolated files with repeated data
A DBMS reduces data redundancy and inconsistency by
minimizing isolated files with repeated data.
OLAP is a tool that enables users to:
obtain online answers to ad hoc questions in a rapid amount of time.
Hadoop is a(n)
open-source software framework designed for distributing data-processing over inexpensive computers.
The logical view of a database:
presents data as they would be perceived by end users.
Which of the following is not one of the main problems with a traditional file environment? -poor security -data inconsistency -program-data independence -lack of flexibility in creating ad-hoc reports
program-data independence
