Basics of Databases Module

QUESTION 1

Points:10 out of 10Suppose you need to store and manipulate all data related to customers: names, addresses, items purchased, total purchases for the past year, invoices sent and invoices paid, and shipment records. Your best option for handling this kind of data is a —databasespreadsheet.

QUESTION 2

Points:10 out of 10In terms of customer service issues, which of the following is the least likely reason for using a robust CRM?

1.  A CRM can enable members of pertinent departments to have access to all the relevant information, enabling them to answer queries and resolve problems quickly and easily.
2.  A CRM can provide a company’s marketing department with information needed to identify and target new customers.
3.  A CRM can optimize the information shared among departments, resulting in better management of existing accounts.
4.  A CRM can provide a more rapid response to queries and concerns by forwarding the query to the right department.

QUESTION 3

Points:10 out of 10True or false? A data warehouse will typically contain the history of all previous interactions with specific users (including product use and transactions), but rarely includes other types of data.

1.  True
2.  False

QUESTION 4

Points:10 out of 10A staff/faculty member uses proprietary (owned and protected by the university) data from the university’s student financial records database in a graph that is part of a presentation at a computer education conference. Which of the following best describes the data issue?

1.  Malicious data loss
2.  Accidental data loss
3.  Intentional data leak
4.  Malicious data leak

QUESTION 5

Points:0 out of 10If a patch is required to address a potential loophole in the security of a database, this would be considered a potential security —threatvulnerability.

QUESTION 6

Points:0 out of 10True or false? A record can contain only character data—letters, numbers, or special symbols.

1.  True
2.  False

QUESTION 7

Points:10 out of 10What are procedures that help keep a database current?

1.  Database query procedures
2.  Report generation procedures
3.  File maintenance procedures
4.  Data entry procedures

QUESTION 8

Points:10 out of 10A savvy hacker uses a poorly secured vendor’s website to obtain all the information needed to access the main database of a large chain store, including the store’s database password. Which threat best describes this database breach?

1.  Weak authentication
2.  Accidental breach resulting from incorrect (but not malicious) usage
3.  Unprotected personal hardware collection
4.  Theft of database backup tapes or hard drives

QUESTION 9

Points:10 out of 10You are frustrated to find that the only way to contact the customer service department is to make a phone call. The number listed would result in long distance charges to your phone bill. Which issue should be addressed by the company to keep its CRM in line with your expectations?

1.  Mining the social media inputs
2.  Privacy
3.  Customers expect more
4.  Cleaning up the data

QUESTION 10

Points:10 out of 10You receive an offer for a credit card that can be use to accrue points that apply to purchase of airline tickets. This comes from a bank that you currently do not use for any banking services. This is a form of CRM that is most typically used for —acquiring new customerspromoting loyalty to the companya special service for current customersretention of customers.

QUESTION 11

Points:10 out of 10Which of the following would be an example of a loss of availability to records within a database?

1.  You do a lot of banking online. Today, when you attempted to log in to your account, your valid ID and password are denied, and you cannot get access to your accounts.
2.  A classmate tells you that she could see your grades—not just her own—posted in the class’s roster.
3.  You are applying for a new credit card and the company indicates that they will be checking your credit score at one of the three primary credit reporting companies.
4.  Your favorite online shopping site suddenly begins displaying a different mailing address than the one you use. You know you have not made any changes to your account profile.

QUESTION 12

Points:0 out of 10You make an airline reservation using the airline’s website. While at the site, you are encouraged to “Follow us on…” Facebook, YouTube, or Twitter. You visit the airline’s Facebook page and read notices and comments. What is this an example of?

1.  Increasing brand awareness through groups or fans
2.  Viral marketing
3.  Direct advertising
4.  Using the company’s own social networking site

QUESTION 13

Points:10 out of 10True or false? A database breach always involves PII.

1.  True
2.  False

QUESTION 14

Points:10 out of 10True or false? Risk assessment should cover personnel, as well as technical support such as firewalls, secure operating systems and networks, and antivirus protection.

1.  True
2.  False

QUESTION 15

Points:10 out of 10What is one advantage of using a relational database over a spreadsheet or flat file to store data?

1.  It reduces risk of unauthorized access to the data.
2.  It enables reduced memory and storage allocation.
3.  It reduces data redundancy.
4.  It allows for reduced complexity in the design and implementation.

QUESTION 16

Points:10 out of 10True or false? It is just too challenging to have different passwords for every device you use and every online site that requires an ID and password. It would be OK to use a very strong base word or phrase and change the same 2 or 3 characters in that word/phrase for each site.

1.  True
2.  False

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.