IS212 Ch 5&6 study questions
Although _____ does not have any pre-defined markup tags, it is used as the markup language for Web documents containing structured information, including words and pictures. -Extensible Markup Language (XML) -Hypertext Markup Language (HTML) -Standard Generalized Markup Language (SGML) -Hypermedia/Time-based Structuring Language (HyTime)
Extensible Markup Language (XML)
Which of the following is used to define the contents of a Web page or group of pages? -Cascading Style Sheets (CSS) -Java -JavaScript -Extensible Markup Language (XML)
Extensible Markup Language (XML)
A database, a database management system, and the application programs that use the data make up the communication environment in an organization. True/False
False
A major advantage of NoSQL databases is the lateral dissemination capability, which enables hundreds or even thousands of servers to operate on the data, providing faster response times for queries and updates. True/False
False
Cascading Style Sheets (CSS) tell the browser how to display font characteristics, paragraph formatting, page layout, image placement, hyperlinks, and the content of a Web page. True/False
False
On a client/server system, a server is any computer on a network that sends messages requesting services from the clients on the network. True/False
False
One drawback to cloud computing is that an organization can only access whatever technology is available through its provider, which may not be state-of-the-art. True/False
False
Private cloud computing refers to deployments in which service providers offer their cloud-based services to the general public. True/False
False
Some Web developers are creating programs and procedures to combine two or more Web applications into a new service, called a duo. True/False
False
The Web is the infrastructure on which the Internet exists. True/False
False
The database approach to managing data is not as good as the traditional file-based approach, where each operational system uses its own data files. True/False
False
Assume that your home's appliances have an IP address. They are part of the ______. -virtual private network -satellite communication network -Internet of Things -Internet
Internet of Things
if you wish to use a visual approach to query building, you would use ________. -SQL -noSQL -Query by Example -Windows
Query by Example
_____ is a special-purpose programming language for accessing and manipulating data stored in a relational database. -Java -COBOL -DML -SQL
SQL
Sometimes incomplete, incorrect, inaccurate, or irrelevant data has to cleaned. This can be corrected or deleted through data scrubbing. True/False
True
The Internet Protocol enables traffic to be routed from one network to another as needed. True/False
True
The World Wide Web is a hyperlink-based system that uses a client/server model. True/False
True
Web development software helps the designer keep track of all the hyperlinks that connect to the files. True/False
True
Web browser software programs, such as Chrome, Firefox, Internet Explorer, Safari, and Opera, are used to view Web pages. They are known as _____. -Web servers -Web engines -Web clients -development tools
Web clients
The _______________ allows users to relate data in new ways without having to redefine complex relationships. -ability to link relational tables -accuracy of data -redundancy in data -ability to use the SELECT query
ability to link relational tables
In a bus network, ________. -all network devices are connected to a common backbone that serves as a shared communications medium -multiple access points are used to link a series of devices that speak to each other to form a network connection across a large area d. -all network devices connect to one another through a single central device called the hub node -each computer is directly connected with all other computers
all network devices are connected to a common backbone that serves as a shared communications medium
Data governance is defined as the set of policies and procedures that control how data is collected, stored, and maintained by an organization. True/False
false
In the relational database model, each row of a table represents a record. True/False
false
Intranets are browser-based networks that connect people who are external to the company. True/False
false
Java is a popular programming language created by Microsoft. True/False
false
MS Access is an open-source software framework that includes several software modules that provide a means for storing and processing extremely large data sets. True/False
false
Messages on the Internet are typically sent through one or more satellites to reach their destination. True/False
false
One of the primary disadvantages of a relational database is that it allows large amounts of redundancy among data. True/False
false
Records form the smallest piece of information in the data hierarchy. True/False
false
Ron is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use "joining" to create his new database. True/False
false
Sensors that can monitor and report on data about traffic and parking conditions are part of a network of physical objects known as the Internet of Traffic. True/False
false
Suppose we have a table that stores Instructors data. Within it, there is a field called "instructorID" that uniquely identifies each instructor record. This field is known as the ID key. True/False
false
The relational model can place data in one-dimensional, two-dimensional, or three-dimensional tables. True/False
false
Usually measured in pulses per minute (ppm), channel bandwidth refers to the rate at which data is exchanged. True/False
false
Wrapping is the process by which virtual private networks (VPNs) transfer information by encapsulating traffic in Internet Protocol (IP) packets over the Internet. True/False
false
if an organization uses the traditional approach to data management, it would have multiple information systems sharing a pool of related data. True/False
false
HTML, the standard language for page description language for Web pages, is in its _____. -third revision -fifth revision -second revision -ninth revision
fifth revision
A search engine is a valuable tool that enables a user to _______. -create Web pages -learn programming -find information on the Web -create online games
find information on the Web
The access method in a Web address tells your software to access a file using the ______ protocol. -mail transfer -uniform resource location -hyper-text transfer -domain name server
hyper-text transfer
Search engine optimization _________. -is a process for driving traffic to a Website by improving the site's ranking in search engines -is the same as running the server at a steady pace -is the same as fine tuning search engines -is a technique for minimizing load times
is a process for driving traffic to a Website by improving the site's ranking in search engines
In a relational database model, the cost of performing data cleansing or data scrubbing can be quite high. True/False
true
In the context of the relational database model, joining involves combining two or more tables. True/False
true
Network management includes a wide range of technologies and processes that monitor the network and help identify and address problems before they can create a serious impact. True/False
true
Public cloud computing may not be suitable for organizations that are handling sensitive data. True/False
true
The primary key is used to distinguish records so that they can be accessed, organized, and manipulated. True/False
true
Unstructured data comes from sources such as social media, email, and surveillance video. True/False
true
While building a database, an organization must carefully consider content, access, logical structure, and physical organization. True/False
true
f an organization is taking a "store everything" approach to data, it will save all the data in its raw and unaltered form in a data lake. True/False
true
oT sensors are used extensively in the utilities industry to predict when critical pieces of equipment or power lines are about to fail so that quick, anticipatory corrective action can take place before any failure. True/False
true
A primary key is a field or set of fields in a record that _______. -is the most important field or field set -uniquely identifies the record -is always 1 -always resides in the first column of the database
uniquely identifies the record
Leila's employer, a major auto manufacturer, has asked her to capture and review the tsunami of social media posts and customer service emails about their company's latest recall. In terms of the characteristics of big data, Leila is dealing with ________. -variety -velocity -volume -veracity
variety
The _________ takes the information from the Internet, translates it into a radio signal, and sends it to the device's wireless adapter. -bluetooth signal -charging station -wireless access point -satellite signal
wireless access point
_____ is used within a Web page to describe and transfer data between Web service applications. -XML -A database table -HTML -CSS
xml
Geolocation services provide ______. -location-specific business information -mobile Internet access -assistance in finding the ideal location for a new business -free access to the Internet while on the road
-location-specific business information
How many bits make up a byte? -16 -8 -4 -12
8
Which of the following statements is true of a star network? -Multiple access points are used to link a series of devices that speak to each other to form a network connection across a large area. -All network devices are connected to a common backbone that serves as a shared communications medium. -A failure in any link of the star network will isolate only the device connected to that link. -Each computer is directly connected with all other computers in the network.
A failure in any link of the star network will isolate only the device connected to that link.
If "temperature" is an attribute, then "80 degrees" is a data item. True/False
true
Which of the following statements is true of a database? -It provides an essential foundation for an organization's computer network. -It is an unstructured collection of bits of data. -It can contribute to organizational success by providing timely, accurate, and relevant information built on data. -It will constantly troll the Internet for additional data.
It can contribute to organizational success by providing timely, accurate, and relevant information built on data.
Why hasn't social journalism replaced traditional journalism? -It may not be as reliable as mainstream media sources. -It is not widely available. -It costs more. -It is a good source for facts.
It may not be as reliable as mainstream media sources.
Which of the following allows consumers to swipe their credit cards—or even their smartphones—within a few inches of point-of-sale terminals to pay for purchases? -Wireless mesh -Near field communication (NFC) -Microwave transmission -Wi-Fi
Near field communication (NFC)
Which of the following statements is true of network-management software? -With network-management software, a manager on a networked personal computer can spy on anyone else's computer. -Network-management software allows software to be copied, modified, or downloaded legally or illegally. -One of the disadvantages of network-management software is the large amount of time spent on routine tasks. -Network-management software simplifies the process of updating files and programs on computers on the network.
Network-management software simplifies the process of updating files and programs on computers on the network.
A DBMS is a group of programs used as an interface between a database and application programs or a database and the user. True/False
True
A collection of data fields that are all related to one object, activity, or individual is called a record. True/False
True
A virtual private network (VPN) supports a secure, encrypted connection between two points on the Internet. True/False
True
Home and small business networks are being set up to connect computers, printers, scanners, and other devices. True/False
True
If you wish to display photos in a slideshow style, use JavaScript code. True/False
True
Large database systems typically use schemas to define the tables and other database features associated with a person or user. True/False
True
Organizations are using the IoT to capture and analyze streams of sensor data to detect patterns and anomalies. True/False
True
Perhaps the most important decision in moving to a cloud environment is to choose your cloud provider wisely. Migrating to a new provider is costly and time-consuming so you wouldn't want to do it twice. True/False
True
Some IS departments are creating a new position—video content manager—who will create and post videos to public Websites. True/False
True
Some people have privacy concerns about the fact that corporations are harvesting huge amounts of personal data that can be shared with other organizations. True/False
True
SQL databases conform to ACID properties, which stands for _______. -automation, currency, isolation, durability -atomicity, consistency, isolation, durability -atomicity, consistency, independence, durability -automation, consistency, independence, durability
atomicity, consistency, isolation, durability
Using _______ technology, users of multifunctional devices can synchronize data on their devices with information stored in a desktop computer, send or receive faxes, and print. -Wi-Fi -near field communication -Bluetooth -infrared
bluetooth
Melissa is a photographer, and she'd like to publish her photos online. Melissa ____________. -can use Flickr to post photos -will need to learn Java -will need her own server and IT people to run the server -will need to run her own web server on leased servers
can use Flickr to post photos
In a database, bits can be organized into bytes, and each byte represents is a(n) ______. -file -attribute -record -character
character
The process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database is called ________. -data cleansing -enterprise data modeling -data selecting -social graph analysis
data cleansing
Suppose you wish to find what tables are in a database, what fields they have, and how they are related. You would review the _____. -attributes -data dictionary -SQL commands -sample data
data dictionary
If you had a job where you were responsible for setting policies and managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data, you would be a ________. -data manager -database administrator -data steward -data lifecycle manager
data lifecycle manager
A ______ is the highest level of data hierarchy. -database -record -field -file
database
William works at a paper goods distributor. He is responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in the organization. William is a ________. -data administrator -database administrator -data steward -data manager
database administrator
A data definition language is a collection of instructions and commands used to __________. -cleanse the data in a database -define and describe data and relationships in a specific database -retrieve data from a database -administer a database server
define and describe data and relationships in a specific database
What is the main purpose of LinkedIn? -finding long-lost friends -obtaining information about local services -developing your professional network -reading reviews of various products
developing your professional network
Which of the following is NOT one of the popular categories of NoSQL databases? -key-value NoSQL -graph NoSQL -dimensional NoSQL -document NoSQL
dimensional NoSQL
The primary concern of the Internet Corporation for Assigned Names and Numbers (ICANN) is to make sure that each _________ represents only one individual or entity. -Web page -IP address -email ID -domain name
domain name
A(n) __________ uses basic graphical symbols to show the organization of and relationships between data. -enterprise data model -data diagram -data model -entity-relationship diagram
entity-relationship diagram
A data dictionary describes the meanings of data elements that are in a different language. True/False
false
A record is typically a name, number, or combination of characters that describes an aspect of a business object, such as a location. True/False
false
Iridium Communications provides a global communications network that spans the entire Earth, using 66 satellites in a near-polar orbit at an altitude of 485 miles. These are known as ______ satellites. -microwave -low earth orbit (LEO) -very small aperture terminal (VSAT) -geostationary
low earth orbit (LEO)
Each attribute in a ________ model can be constrained to a range of allowable values called a domain. -relational database -NoSQL database -traditional database -flat file
relational database
If you have weekly sales data and you wish to get monthly sales data, then use the ______ feature. -drill down -slice and dice -roll up -extract data
roll up
Which of the following is NOT a common challenge related to the use of the Internet of Things? -slow Internet speeds -security risks -faulty sensors providing inaccurate or incomplete data -data lacking time stamps
slow Internet speeds
A data mart is a ______. -simplified data model -subset of a data warehouse -portable data dictionary -schema that is available for sale
subset of a data warehouse
If the receiving and sending computers are not directly connected to the same network, the sending computer relays the message to another computer that can forward it using _____. -a Uniform Resource Locator (URL) -the Internet Protocol (IP) -the ARPANET -a Wi-Fi
the Internet Protocol (IP)
With Database as a Service, the database is stored on a service provider's server and accessed by the client over _______. -4GL -a cellular network -the Internet -WiFi
the internet
In a data warehouse, during which stage of the ETL process is the data subjected to a series of rules or algorithms that will derive the data that's meant to be stored from the rest? -transform -transfer -extract -load
transform
A blog is a Website that people can create and use to write about their observations, experiences, and opinions on a wide range of topics. True/False
true
A database should be designed to store all data relevant to the business and provide quick access and easy modification. True/False
true
A podcast is an audio blog that is accessed over the Internet. True/False
true
An entity is a general class of people, places, or things for which data is collected, stored, and maintained. True/False
true
Content streaming is a method of transferring large media files over the Internet so that the data stream of voice and pictures plays more or less continuously as the file is being downloaded. True/False
true
