CIS Study Guide for Exam 3

Websites reside on __________.

A server

Which of the following is an example of a one-to-many relationship?

A student takes more than one course.

In the SQL statement "FROM Parts", Parts refers to what?

A table

What was the internet's original name?

ARPANET

Website reengineering and business facelifts in e-commerce are components of which part of an e-commerce business plan?

Agility

ISPs provide which of the following? Email Web hosting Broadband All of the above

All of the above

The usability of a browser can be described as ________________. Ease of use Displaying any website as intended A robust set of tools All of the above

All of the above

In the SQL statement "SELECT Lname", Lname refers to what?

An attribute

Which of the following is an example of B2E?

An employee purchasing goods from the company store

What is the first step in developing a computer security plan?

Assess all risks

What is the IT term for when smart devices are rendered nonfunctional?

Bricking

Which software provides an interface that displays information on the World Wide Web?

Browser

Which of the following seller-customer relationships describes how Craigslist does e-commerce?

C2C

Who is responsible to ensure that security is maintained over IT assets?

CIO

The term for stored pages of previously visited web pages is ________.

Cache

The internet can be described as which type of model?

Client/server

Put the IoT life cycle actions in the correct order.

Collect, communicate, analyze, act

What does the top-level domain ".com" stand for?

Commercial

Which is NOT a use of a business intranet?

Conducting business-to-consumer transactions

What is the term for text files used for tracking what sites are visited on the World Wide Web?

Cookies

Ensuring that the ZIP CODE attribute is populated with usable data is called ________.

Data validation

The security of a database is the responsibility of the _________.

Database administrator

A set of tools that provide programmers with the ability to create, modify, and extract data is known as a _______________.

Database management system

One or more tables in a database with each record indexed is called a __________.

Database structure

Social engineering is _________________.

Deception used to manipulate individuals into divulging confidential information

HCI is a measure of a website's ____________.

Design

What is the term used when a criminal sifts through trash for information?

Dumpster diving

Which of the following is NOT a standard email protocol?

EMSP

What do database designers use to design and construct databases?

Entity relationship diagrams

What is another name for a bookmark?

Favorite

A column in a database table is called a ________.

Field

Which attribute points to a primary key in another table within a database?

Foreign Key

What is the term for someone who attempts to steal information from a computer?

Hacktivist

The ____________ file is a list of cached websites on a computer.

History

What is the term for a clickable navigation element?

Hyperlink

What system is used to address each node on the internet?

IP

_____________ is the term for when someone wrongfully uses another person's information for criminal gain.

Identity theft

What does ISP stand for in the realm of the internet?

Internet Service Provider

The ________ is composed of millions of smart devices and sensors connected to the internet.

Internet of Things

What is one reason the internet is moving from IPv4 to IPv6?

IoT devices have used up all the IPv4 addresses.

Which type of malware is installed on a computer to capture or monitor keystrokes and transmit information to a third party?

Keylogging

Redirecting a user to a bogus website with an official-looking URL is known as ________.

Pharming

A scam using a fraudulent email that appears to have come from a legitimate source requesting information is known as _________________.

Phishing

A separate window that opens within a browser without user interaction is known as a _________________.

Popup

The function that is used to retrieve data from a database is called a(n) ___________.

Query

What is the latest type of malicious software that has the ability to completely cripple a computer and require payment to re-enable the computer?

Ransomware

Which of the following is the correct order of steps for risk management?

Recognition, consequences, assessment, strategies

A row in a database table is called a ________.

Record

Database normalization is a process used to _______________.

Reduce redundancy

Which of the following is NOT a type of ransomware?

Reverse phishing

The most widely used query language for a DBMS is _______________.

SQL

A map of a database that shows tables and relationships is called a(n) _______.

Schema

Yahoo, Google, and Bing are examples of _____________.

Search engines

The use of deception to manipulate individuals to divulge confidential or personal information is known as ____________.

Social engineering

Email, faxes, mobile phones, blogs, and news groups are victims of which type of malware threat?

Spam

Which type of malware gleans personal data and information about the user without his or her knowledge?

Spyware

In a website attack involving a denial of service, who is most affected by the malicious software?

Those who want to use the website

One way a deceptive website can know where a visitor has been on the web is through the use of _____________.

Tracking cookies

What allows a website you have previously visited to know information about you when you return to it?

Tracking cookies

What is the term for a malicious program that seems harmless until it is executed?

Trojan horse

Which type of malware usually activates at a future date?

Trojan horse

True or false: A relational database must have more than one table.

True

True or false: All email should be considered public information.

True

True or false: Attribute and Field are different terms for the same thing.

True

True or false: Metasearch engines utilize multiple search engines to return results.

True

True or false: Without a firewall, an intranet just becomes part of the internet.

True

Voiceover Internet Protocol (VoIP) is the use of internet networks to carry voice phone calls. Which of the following is NOT true of VoIP?

Uses TCP protocol

Which type malware has the ability to be self-replicating?

Worm

Which type of malware does NOT need to attach itself to an existing program or email to spread?

Worm

Web pages are usually programmed using ____________. a. HTML b. JavaScript c. CSS d. A and B only e. A, B, and C

e. A, B, and C

Which of the following are components of e-commerce? a. Advertising b. Buying c. Selling d. Distribution e. B and C only f. A, B, C, and D

f. A, B, C, and D