isds final
The field that has a unique entry for each record in a database table is called the master field. foreign key. primary key. logical key.
primary key
a system that is designed to help keep track of everyday business activities is an management information system transaction processing system enterprise resource planning system decision support system
transaction processing system
The protocol used to send e-mail over the Internet is (1 point) SMTP. DNS. DHTML. HTTP.
SMTP
the protocol to send email over the internet is
SMTP
Encryption is used to? a. code your e-mail so only one person can decipher it b. shrink the amount of space it takes to store e-mail c. transfer e-mail more quickly d. make shopping on the Internet more available
A.
IPv6 uses 32 bits to assign? a. data packet to each transmission b. a memory address to the CPU c. an address to every device connected to the Internet d. a destination Internet address to each e-mail
C
The information in a data packet includes? a. the data and the destination b. the data and circuit identifier c. the "To" address, "From" address, data, and reassembly instructions d. different types of information depending on the type of message being sent
C. "to" address, "from" address, data, and reassembly instructions
The collection of large national and international network providers used to establish the internet is called the? a. T1 b. highway system c. OC d. Internet backbone
D Internet Backbone
A small slice of a data warehouse is called a data mine. True False
False
Julian owns a large garment store that attracts hundreds of customers every week. His manager requests him to purchase a database system to track store inventory, sales, and customers. However, Julian wishes to traditionally maintain separate lists for stock, sales, and prospective customers and updates them manually every month. Which of the following is true with regard to this scenario? Julian would incur heavier expenses in maintaining a list than setting up and administering a database. Julian's entries might be subject to data redundancy. There is no possibility of Julian's data being inconsistent. If Julian changes any entry in a list, it would be automatically changed in all the lists.
Julian's entries might be subject to data redundancy
network adapters send data packets based on
MAC address
The main suite of Internet protocols used to transmit data is called (1 point) DNS. HTTP. XML. TCP/IP.
TCP/IP
a network consisting of two LANS separated by great physical distances is known as
WAN
Which of the following best refers to a group of related records in a database? Metadata Schema A table A field
a table
Which of the following is true of a database? A centralized database is a shared source of information that everyone can access. It lacks features such as accuracy and reliability of data. It requires database administrators to create simple and small databases. It is created and managed using an accounts management system.
a centralized database is a shared source of information that everyone can access
Which best describes a data warehouse? a database that organizes data from multiple organizations a collection of all the data from an organization's databases a building that stores computer servers a software program that assists with file management
a collection of all the data from an organizations databases
Which of the following statements is a characteristic of enterprise resource planning (ERP) systems? ANSWER Manual integration of various processes within the organization is required. A common database to store and integrate information is used. Data gathered from the individual business units are kept confidential. Usage of information is restricted to a single area of an enterprise.
a common database to store and integrate information is used
In data centralization, __________. access is granted to the owner of the centralized database solely security of data is diminished greatly a single file is maintained to ensure reliability and accuracy of data the efficiency is decreased as there are files to reconcile with each other
a single file is maintained to ensure reliability and accuracy of data
IPv6 uses 32 bits to assign a(n) (1 point) estination Internet address to each e-mail. address to every device connected to the Internet. memory address to the CPU. data packet to each transmission.
address to every device connected to the internet
In the client-server model, clients are phones or computers and servers are (1 point) computers hosting web pages. computers with software allowing you to make purchases. computers that are storehouses for files. all of the above
all of the above
The rise of the Internet of Things has meant (1 point) light bulbs can join your WiFi network at home. there are more machines with wireless network adapters. we need longer IP addresses than are available in IPv4. all of the above
all of the above
Which is a report generated by a management information system? exception report summary report detail report all of the above
all of the above
in client server models, clients are phones or computers and servers are computers? a. computers hosting web pages b. computers with software allowing you to make purchases c. computers that are storehouses for files d. all of the above
all of the above
Which of the following is true of records? All records in a table have the same fields but usually different data. Each column in a database is represented as a record. An entire record functions as the primary key in a database. A record is a database object in the form of rows and columns in which data is stored.
all records in a table have the same fields but usually different data
Angels is a kids-wear manufacturing company in Boston. The company wants to use software to integrate the information flowing from the production, supply chain management, and the project management departments to enable better coordination between these departments and improve the production rate. Which of the following business intelligence systems can best assist Angels in the given scenario? an enterprise resource planning system a clickstream data system a natural language processing system a batch processing system
an enterprise resource planning system
Correctly entering the user ID and password on your college network is an example of (1 point) scalability. authentication. virtualization. packet screening.
authentication
To ensure only authorized users are logging onto a network, which server would a client/server network include? (1 point) application communications authentication Internet
authentication
correctly entering the user ID and password on your college network is an example of
authentication
which of the following is used to increase security on a client/server network
bastion host
Packet switching sends information between two points (1 point) by breaking it into small chunks and sending the chunks across different routes. by finding one route between the two points and sending the data. differently for each company using it. by encrypting the data, then sending it.
by breaking it into small chunks and sending the chunks across different routes
data ______ maintains integrity
centralization
Data captured from websites as users navigate through a website is called? web-user data clickstream data time-variant data staged data
clickstream data
To manage authorized connections to external networks, which server would a client/server network include? (1 point) authentication communications application database
communications
to manage authorized connections to external networks which server would a client/server network include?
communications
Data integrity is best maintained in a database through __________. data staging data centralization data normalization data centers
data centralization
Two lists showing different values for the same data in different places of a database is an example of data irregularity. data inconsistency. data redundancy. data disparity.
data inconsistency
The process by which great amounts of data are analyzed and investigated is known as clustering. data staging. data mining. online analytical processing.
data mining
The Grey Tome library uses a large database to manage its collection of books. However, a large number of records are duplicates. This has increased the database size tremendously. Which database strategy should the library follow to overcome this redundancy? Data mining Data normalization Data centralization Data staging
data normalization
__________ reduces data redundancies in a database and ensures that the data is organized most efficiently. Data normalization Data staging Data mining Data centralization
data normalization
Paris is a librarian. She uses four different lists to maintain the library by categorizing books based on genres, authors, publishers, and price. She finds that many books in the genre list are repeated in the authors and the publishers lists. Which of the following terms best describes this duplication across lists? Data inconsistency Data redundancy Data warehousing Data staging
data redundancy
When importing data electronically from other files, __________. databases apply filters to the data to determine if it's in the correct format as defined by the data dictionary nonconforming data cannot be modified to fit the database's format the format of the database is insignificant to that of the data it is imperative to know that data cannot be imported from word processing documents
databases apply filters to the data to determine if its in the correct format as defined by the data dictionary
Which of the following is NOT a true statement when considering using databases instead of lists? Databases are easier to build and maintain than lists. Data can be easily shared among users. Data integrity can be ensured with a database. Data-entry errors can be minimized with databases.
databases are easier to build and maintain than lists
Which of the following is true of databases? Data contained in databases are seldom accurate or reliable. Use of databases invariably leads to data redundancy issues. Databases can be more time consuming and expensive to set up and administer than lists. Data stored in databases are prone to data inconsistency issues.
databases can be more time consuming and expensive to set up and administer than lists
which of the following is not an advantage of installing a network in a business enables peripheral sharing enables software sharing decentralization of files and data centralization of files and data
decentralization of files and data
A private key is important (1 point) because it enables you to use MIME. to reset your public key if you lose a password. to reboot system hardware. to decode an encrypted message.
decode an encrypted message
A _________ takes the place of an IP address because it's easier for humans to recall than a long string of numbers. (1 point) CGI domain name DNS HTML
domain name
fiber optic cable would most likely be used in business networks when:
electrical or magnetic interference is present
Bridges are used to route data between two different networks. (1 point) True False
false
If you use an Internet cache, then the information displayed in your browser is automatically refreshed. (1 point) True False
false
Instant messaging is secure because of the type of encryption used. (1 point) True False
false
A database stores each category of information in columns known as __________. fields tables schema records
fields
A(n) __________ database is the simplest form of database consisting of a single list of items in a document or a spreadsheet. object-oriented relational multidimensional flat file
flat file
__________ are used to enter data into tables and make changes to existing data in the database. Data marts Input forms Foreign keys Join queries
input forms
A flat file database __________. is the most complex form of database stores data in objects is adept at handling binary large object (BLOB) type of data is a list or table in a document or a spreadsheet
is a list or table in a document or a spreadsheet
Which of the following best describes a database feature? It categorizes, filters, and sorts data within a table or between multiple tables. It controls the software and hardware that runs on a network. It manages system resources and only runs on GPS devices and video game consoles. It maintains a computer and protects it from viruses, worms, malware, and adware.
it categorizes, filters, and sorts data within a table or between multiple tables
HTTPS is different than HTTP because (1 point) it extracts data from source databases. it stores data in the data warehouse. it is a combination of HTTP and the Secure Sockets Layer (SSL). of how it transforms or reformats the data.
it is a combo of HTTP and the secure sockets layer (ssl)
Which of the following is the advantage of using a database? Large volumes of data can be stored in a single list or table in a database. Databases offer the advantage of data decentralization. It manages large amounts of data efficiently without compromising data accuracy. It is comparatively cheaper and easier to maintain than lists.
it manages large amounts of data efficiently without compromising data accuracy
Which SQL query is used to extract data that is in two or more tables? Join query Truncate query Insert query Create query
join query
Which of the following database systems uses artificial intelligence? enterprise resource planning system transaction-processing system office support system knowledge-based system
knowledge based system
Which of the following statements best distinguishes lists from databases? Unlike databases, lists incorporate data centralization techniques. Lists organize complex information, whereas databases handle relatively simpler information. Unlike databases, lists are always more expensive to create and maintain. Lists are prone to data inconsistencies, whereas databases promote data integrity.
lists are prone to data inconsistencies, whereas databases promote data integrity
JSON, Javascript Object notation is useful because it;
makes the document object modal usable in HTML
The type of database that uses fields, records, and measure as data attributes is relational. object-oriented. two-dimensional. multidimensional.
multidimensional
Siri, Cortana, and Google Now are examples of which type of knowledge-based system? expert system natural language processing system voice management system artificial intelligence
natural language processing system
A(n) __________ is the data type that is used to store pictures, charts, or files from another Windows-based application. ANSWER text object memo hyperlink
object
Which type of database would be best to handle unstructured data? object-oriented database relational database multidimensional database all of the above
object oriented database
NOS software is needed
on all computers in a client/server network
NOS software is needed (1 point) on all computers in a client/server network. only if a communications server is deployed on a client/server network. only when configuring a network in a star topology. only on the servers in a client/server network.
on all computers in a client/server network
Which type of relationship should be used to connect a Password table to a User Account table? one-to-one relationship one-to-none relationship many-to-many relationship one-to-many relationship
one to one relationship
Providing adequate security on a corporate network involves all of the following issues except
proprietary software lockout
Providing adequate security on a corporate network involves all of the following issues except (1 point) limiting physical access to networking equipment. authentication. proprietary software lockout. restricting access to servers.
proprietary software lockout
With respect to database software, a __________ contains information about a single entry in the database. ANSWER INCORRECT footnote header record cell
record
Which of the following statements is true of data normalization? It reduces the size of the database. It increases data redundancy by combining tables. It complicates the process of keeping records up to date. It decreases query speed.
reduces the size of the database
For each value in the foreign key table there is a corresponding value in the primary key table. Which of the following terms best describes this statement? Validation rule Data staging Referential integrity Normalization
referential integrity
In a database, a field __________. is a database object in which data is stored in rows and columns contains the information for a single entry in the database refers to a single piece of information in a record within a database represents each row in a database
refers to a single piece of information in a record within a database
Which is NOT a component of a database that describes how data is stored? report field record table
report
In SQL, a(n) __________ query displays a subset of data from one or more tables based on the criteria specified. insert select join delete
select
MIME is a protocol that's used when you're (1 point) executing a CGI script. sending a video file to YouTube. sending an e-mail that has a photo attached. encrypting an e-mail message.
sending an e-mail that has a photo attached
MIME is a protocol thats used when youre
sending an email that has a photo attached
Which type of network topology is most popular? (1 point) star Ethernet bus ring
star
which type of network topology is most popular?
star
HTML5 (1 point) is used to program server-side applications. supports powerful multimedia effects. provides high-level security for e-mail. is obsolete.
supports powerful multimedia effects
HTML5?
supports powerful multimedia effects
Which of the following best refers to a group of related records in a database? A table Schema A field Metadata
table
Which of the following is NOT considered metadata? the data type field name field size table name
table name
The following is a database of books in a library. From this database, which of the following best refers to a field? The column, "Publisher" The cell, "$230.00" All the records in the database The entire second row
the column,
Which of the following is a characteristic of relational database? Data synchronization across related tables is achieved by avoiding referential integrity. One relationship exists in a relational database—the many-to-many relationship. The common field in one table is the primary key, whereas the common field in a related table is the foreign key. A dimension refers to the link between tables that defines how the data is related.
the common field in one table is the primary key, whereas the common field in a related table is the foreign key
The following is a database of books in a library. From this database, which of the following refers to a record? The cell, "$230.00" The entire second row All the records in the database The column, "Publisher"
the entire second row
June Summers joins a university. The university allows new students to choose between two study plans and update it in their Fresher's List. Instead of choosing between the two plans, June writes a study plan that does not exist in the university's list of study plans. Upon review, the university administrators are confused with this nonexistent entry. Which problem is best described in this example? The inappropriate data problem The data inconsistency problem The data redundancy problem The incomplete data problem
the inappropriate data problem
Cascading style sheets allow you to quickly change? a. from server-side processing to client-side processing b. to a more secure transport protocol c. the rules for applying formatting to an HTML document d. from HTML to XML.
the rules for applying formatting to an HTML document
Which of the following best denotes a safe primary key for the employee database? The social security number of each employee The credit card number of each employee The staff ID of each employee The last name of each employee
the staff ID of each employee
Which of the following is true of lists? They are relatively expensive to maintain than databases. They actively avoid data redundancy. They are inefficient when used as a shared resource for multiple users. They do not lead to data inconsistency.
they are inefficient when used as a shared resource for multiple users
Which of the following statements is NOT true of databases? They can organize complex data at ease. They promote data integrity through data centralization. They are invariably cheaper to build and maintain than lists. They use normalization techniques to avoid data redundancy problems.
they are invariably cheaper to build and maintain than lists
Why are client/server networks usually installed in businesses?
they are more scalable than P2P networks
On client/server networks, routers (1 point) move data efficiently from node to node on the internal network. route data between two collision domains on a single network. are necessary only in networks using the ring topology. transfer data between two networks.
transfer data between two networks
on a client server network, routers
transfer data between two networks
A query is used to extract a subset of data from a database. True False
true
A web server is used to host websites on a client/server network. (1 point) True False
true
MIME is the protocol that supports sending files as e-mail attachments. (1 point) True False
true
Most modern operating systems include some type of NOS functionality. (1 point) True False
true
Your Internet service provider has a default domain name server to translate a URL into an IP address. (1 point) True False
true
