Deck 14: Creating Database Security and Documentation

Question 1

Typically when you open a database, you use the Open mode.

Answer 1

True

Question 2

To remove the password and encryption from a database, you first need to open the database in the Open Read-Only mode.

Answer 2

False

Question 3

If a database file gets damaged or corrupted, you should be able to look at the documentation produced by the Back Up Database Command and fix the database or re-create it.

Answer 3

False

Question 4

A social security number is considered sensitive information.

Question 5

In Open Exclusive mode, only the person who opened the database can use and make changes to it; all other users are locked out from opening and using the database.

Question 6

When saving a backup database file, the date is added after the filename.

Question 7

____ mode allows several users to open and use the database at the same time.

A) Open
B) Read-Only
C) Open Exclusive Read-Only
D) Open Exclusive

Question 8

To avoid losing database information, you can open a database in the Open Exclusive mode.

Question 9

You can only encrypt a database with a password if the database is opened in the Read-Only mode.

Question 10

In Access, the Object Documenter produces a report of selected objects or every object in a database.

Question 11

Row level locking is turned on by default.

Question 12

Once applied, you cannot remove a password and database encryption.

Question 13

Using the ____ mode allows multiple users to open a database, but they cannot add or change records and they cannot create new objects.

A) Read
B) Read-Only
C) Open Read-Only
D) Open Exclusive Read-Only

Question 14

When a database is password protected, users cannot open the database unless they provide the correct login ID.

Question 15

The Back Up Database command uses the same filename as the file that was backed up.

Question 16

Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. To ease Ron's concerns, you start by explaining that Access 2010 combines two tools for database security: ____.

A) login IDs and database passwords
B) login IDs and row-level locking
C) database passwords and encryption
D) system passwords and encryption

Question 17

When you encrypt a database, data within the database is made unusable.

Question 18

Until the correct password is entered, no objects in an encrypted database can be viewed.

Question 19

An encrypted database cannot be viewed or understood unless it is ____ with the correct password.

A) created
B) secured
C) closed
D) opened

Question 20

You select the database open options using the ____ dialog box.

A) Database
B) Open
C) Open Database Mode
D) Open Database

Question 21

A good rule of thumb is to schedule a database backup ____.

A) at the end of each day
B) after every record update
C) once a year
D) whenever the database owner requests it

Question 22

A backup copy of a database is created when you ____ the file using the Back Up Database option.

A) close
B) save
C) open
D) create

Question 23

An Access Database backup file uses ____ for the file extension.

A) .accdb
B) .bkup
C) .adbkf
D) .accbk

Question 24

Selecting the Back Up Database option alerts Access that when you click ____, you want to create a backup of the database.

A) Close
B) Exit
C) Save As
D) Save

Question 25

FIGURE AC 14-11 In Figure 14-11 above, click the ____ tab to see all of the objects in the database.

A) All Object Types
B) Object Types
C) All Database Types
D) Database Object Types

Question 26

If a password is needed to open a database, the ____ dialog box appears.

A) Password
B) Password Required
C) Password Needed
D) Password Necessary

Question 27

If you click the Encrypt with Password button and the database is not opened in the Exclusive mode, ____.

A) the button goes dim
B) the Set Database Password dialog box opens
C) you will receive an error message
D) you will be given a chance to open the database in Exclusive mode

Question 28

Which of the following causes a message similar to " Block cipher is incompatible with row level locking and so row level locking will be ignored" ?

A) Encrypting a database with row level locking turned off.
B) Encrypting a database with row level locking turned on.
C) Encrypting a database with block cipher locking turned off.
D) Encrypting a database with block cipher locking turned on.

Question 29

FIGURE AC 14-11 In Figure 14-11 above, Item 1 points to the tabs that show various parts of the ____.

A) log
B) backup file
C) database
D) database log

Question 30

Case AC 14-1 Ron wants to convert his paper-based customer information system to an Access 2010 database stored on his laptop. However, Ron is concerned about placing the information on his laptop because he also uses the laptop for Internet access. He asks for your advice. Ron questions how a password can be used with an Access database. You explain that when opening a(n) ____ database, Access 2010 will prompt Ron for a password.

A) blocked
B) personal
C) row level locked
D) encrypted

Question 31

The Back Up Database option is accessed by clicking the ____ option within the File tab.

A) Save
B) Save & Publish
C) Backup
D) Save & Backup

Question 32

You can add a password to a database, which encrypts, or ____________________, the data.

Question 33

You can remove the database encryption by using the ____ button.

A) Decrypt Database
B) Release Encryption
C) Relinquish Encryption
D) Unset Encryption

Question 34

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. One of Ted's junior database designers questions the usefulness of the auditor's request. Ted explains that documenting the database design is considered a(n) ____ feature.

A) programming
B) safety
C) SQL
D) logging

Question 35

If you click the File tab and notice that the Encrypt with Password option is ____, this indicates that the password and encryption are removed.

A) grayed out
B) crossed out
C) displayed
D) hidden

Question 36

Case AC 14-2 Ted recently finished creating a supplier database. The internal auditors are currently reviewing Ted's project and would like to see the properties of all the objects as well as their relationships. To satisfy the auditor's request, Ted should use the ____ tool.

A) Recorder
B) Database log
C) Database Recorder
D) Database Documenter

Question 37

Which of the following events may cause data loss requiring a database restore from a backup?

A) power failure
B) hard disk crash
C) accidental deletion of database objects
D) all of the above

Question 38

You should document the database design in case the file gets ____.

A) damaged
B) old
C) corrupted
D) both A and C

Question 39

The message " Block cipher is incompatible with row level locking and so row level locking will be ignored" ensures that ____ will be encrypted.

A) the selected column
B) a block
C) the entire database
D) the entire field

Question 40

To remove database encryption, you must enter the password in the ____ Database Password dialog box.

A) Remove
B) Unset
C) Relinquish
D) Reverse

Question 42

You click the ____________________ tab and if necessary the Info tab, to access the Encrypt with Password option.

Question 43

The database ____________________ refers to the objects in the database and the relationship between these objects.

Question 44

A(n) ____________________ is a duplicate copy of the database.

Question 45

Describe the various security and documentation features Microsoft Access offers to protect a database from losing important information.

Question 46

In the Database Tools tab ____________________ group, click the Database Documenter button to open the Documenter dialog box.