Question

Does a wizard function allow the user to enter or modify data in the records? Select Yes or No.

	A) Yes
	B) No

What are procedures that help keep a database current?

	A) Database query procedures
	B) Report generation procedures
	C) File maintenance procedures
	D) Data entry procedures

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

	A) It allows for reduced complexity in the design and implementation.
	B) It enables reduced memory and storage allocation.
	C) It reduces data redundancy.
	D) It reduces risk of unauthorized access to the data.

Which of the following would be an example of a loss of record confidentiality in a database?

	A) You make all your personal information on the Facebook site "public" and available to everyone.
	B) Although you clicked the option to "Do not share information with any other companies or sites" on an online bookstore's website, you are getting unsolicited e-mail messages from some of the companies that post ads on that site.
	C) 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.
	D) Your credit card company issued you a new card when your old one was about to expire.

Answer 1

First Question:

Option (A) is the correct answer.

A wizard function allows the user to enter or modify data in the records.

Second Question:

Option (C) is the correct answer.

File maintenance procedures are the procedures used to keep the database up to date. Other given options are incorrect as database query procedures are used for data retrieval from the database. Report generation procedures are used for database report generation. Data entry procedures are used for data entry.

Third Question:

Option (C) is the correct answer.

The advantage of using a relational database over a spreadsheet or flat file to store data is that it reduces data redundancy.

Fourth Question:

Option (B) is the correct answer.

When someone clicks the option to "Do not share information with any other companies or sites" on an online bookstore's website, and still receives unsolicited e-mail messages from some of the companies that post ads on that site is an example of a loss of record confidentiality in a database.

Other given options are incorrect as they are not examples of record confidentiality loss in a database.

Hope this helps.