Question 1

The ________ contains the queries,forms,and reports of the database.
A) back-end database
B) database documenter
C) front-end database
D) design tools

Accepted Answer

The answer of The ________ contains the queries,forms,and reports of...

Question 2

Minimizing data redundancy is one of the benefits of normalization.

Accepted Answer

Normalization involves organizing data in a systematic manner to reduce redundancy and inconsistencies, thereby improving data integrity and minimizing the risk of data anomalies.

Question 3

What appears when you point to a table name of a linked table?
A) ScreenTip
B) Splitter
C) Table Analyzer
D) Wizard

Accepted Answer

When you point to a table name of a linked table, a ScreenTip appears displaying information about the table, such as the source database and location.

Question 4

A ________ is a combination of the date and time that is encrypted as part of the digital signature.
A) timestamp
B) certificate
C) navigation
D) password

Accepted Answer

A timestamp is the correct answer as it is a combination of the date and time that is encrypted as part of the digital signature. A certificate is a digital document that is used to verify the identity of a person or organization. Navigation refers to the process of moving through a website or application. A password is a secret code that is used to gain access to a system or account. None of these options fit the description of a combination of date and time encrypted in a digital signature.

Question 5

What does the Database Splitter do?
A) Splits database into two files, a back-end and a front-end database
B) Divides the table and creates relationships that control how the new tables are linked
C) Adds more indexes to increase database performance
D) Provides a brief description of a potential problem and its possible solution

Accepted Answer

The Database Splitter is a tool in Microsoft Access that splits a database into a back-end database file that holds the tables and a front-end database file that holds all other database objects such as queries, forms, reports, and macros. The back-end file is typically stored on a shared network drive allowing multiple users to access the data simultaneously. This improves performance and reduces the risk of data corruption.

Question 6

What is the main reason to split an Access database?
A) Improve development and maintenance
B) To confirm the primary key of each table
C) Controls how the tables are linked
D) To decide which fields go to which tables

Accepted Answer

The main reason to split an Access database is to improve development and maintenance. This is accomplished by separating the database into a front-end application and a back-end storage for data.

Question 7

One benefit of normalization is the improvement of referential integrity enforcement in relationships.

Accepted Answer

Normalization helps in breaking down large tables into smaller, more manageable tables that have a clear and logical relationship with each other. This improves referential integrity enforcement as it reduces the chances of data inconsistencies and deletion anomalies.

Question 8

Which process guarantees that you are the only one currently using the database?
A) Open exclusive
B) Encryption
C) Password protect
D) Selfcert

Accepted Answer

Opening the database in exclusive mode ensures that no other user can access the database while it is being used by you. Encryption and password protection do not guarantee exclusive access, and selfcert is not a valid option for ensuring exclusive access to a database.

Question 9

________ reduce the time it takes to run queries and reports.
A) Indexes
B) Ideas
C) Suggestions
D) Recommendations

Accepted Answer

Indexes are database structures that improve the speed of data retrieval operations such as queries and reports. They work by creating a sorted list of the values within a specific column of a table, allowing the database management system to locate the data more quickly when it is queried. Ideas, suggestions, and recommendations may all be useful in optimizing database performance, but indexes are a proven mechanism for reducing query and report turnaround times.

Question 10

What does a back-end database contain?
A) Tables of the database
B) Queries, forms, and reports of the database
C) Tables and queries of the database
D) Tables, forms, and reports of the database

Accepted Answer

The back-end database primarily contains tables, which store the data in structured fields and columns. Queries, forms, and reports are typically created within a front-end application that is connected to the back-end database, but these elements do not exist within the database itself. Therefore, the correct answer is A.

Question 11

________ is the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key.
A) Encryption
B) Open exclusive
C) Password
D) Selfcert

Accepted Answer

Encryption is the process of making digital information unreadable by using an algorithm. The encrypted data can only be read or restored to its original format by using a key or password.

Question 12

What database format prohibits users from making design and name changes to forms or report within the database,and prohibits users from creating new forms and reports?
A) Access Database Executable file
B) Access Database file
C) Access Database Template file
D) Database Documenter

Accepted Answer

The Access Database Executable file format (.accde) prohibits users from making design changes to forms or reports and from creating new forms or reports, ensuring the database design remains unchanged by end users.

Question 13

There are three normal forms; however,the majority of database designs only require the first two normal forms.

Accepted Answer

There are actually more than three normal forms in database normalization, including the First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), Fourth Normal Form (4NF), and Fifth Normal Form (5NF). While the first three normal forms are commonly used and often sufficient for many database designs, more complex designs may require normalization beyond the third normal form to eliminate all redundancy and ensure data integrity.

Question 14

What is a certification authority?
A) A commercial company that issues and validates identities using digital signatures for a fee
B) An electronic, encryption-based, secure stamps of authentication
C) A guarantee that you are the only one using the database
D) Altering digital information using an algorithm

Accepted Answer

A certification authority is a commercial company that issues and validates identities using digital signatures for a fee. It is a trusted third-party organization that verifies the identity of individuals, organizations, or devices in the digital world. They issue digital certificates that contain information like the owner's name, public key, and the certificate's expiration date. These certificates are used to secure online transactions, authenticate users, and protect sensitive information.

Question 15

________ makes the database unreadable by encrypting the database.
A) Password protect
B) Make ACCDE
C) Digital Signature
D) Encryption

Accepted Answer

The answer of ________ makes the database unreadable by encrypting...

Question 16

________ is the protection of data from unauthorized access,change,or destruction.
A) Computer security
B) Improved performance
C) Encryption
D) Flexible Environment

Accepted Answer

Computer security refers to the protection of data from unauthorized access, change, or destruction. Improved performance, encryption, and flexible environment may support computer security but are not the definition of it.

Question 17

________ is electronic,encryption-based,secure stamps of authentication that confirms who created the file,that the file is valid,and that no changes have been made to the file after its authentication.
A) Digital signature
B) Digital certificate
C) Package and sign
D) ACCDE

Accepted Answer

Digital signature is an electronic authentication method that uses encryption to ensure the validity and integrity of a file. It confirms the identity of the file creator, verifies that the file has not been modified since it was signed, and provides assurance that the contents of the file are legitimate. Digital certificates and package and sign are related concepts, but do not provide the same level of verification and security as a digital signature. ACCDE is a Microsoft Access file format, and is not related to digital signatures.

Question 18

What is database security?
A) A specialty within computer security that protects a database application from unintended use
B) Protecting assets you can touch, such as computers, storage devices, backup tapes, and office safe
C) Protecting the information that resides on the physical devices, including databases and other computer software
D) A tabbed menu system that ties the objects in the database together

Accepted Answer

Database security is the protection of a database application from unintended use, malicious attacks, and unauthorized access, in order to preserve the confidentiality, integrity, and availability of the data. This involves implementing security measures such as access controls, encryption, auditing, and monitoring.

B and C are incorrect because they refer to physical security and software security, respectively, which are important but not the same as database security. D is a description of a database schema or interface, but not related to database security.

Question 19

What does the Table Analyzer do?
A) Analyzes the tables in a database and normalizes them for you
B) Gives you notes and specifications recommended and then fixes them
C) Provides a brief description of potential problems and possible solutions
D) Lists three kinds of analysis results

Accepted Answer

The answer of What does the Table Analyzer do?
A) Analyzes...

Question 20

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.
A) navigation form
B) switchboard
C) command option
D) ribbon

Accepted Answer

A navigation form is specifically designed to provide an interface for the user to interact with the database objects easily. It displays a tabbed menu system, which is linked to the objects in the database, so the user can quickly access what they need. Switchboard, command option, and ribbon are all common design elements but are not specifically designed to tie database objects together in the same way as a navigation form.

Quiz 21: Fine-Tuning the Database: Analyzing and Improving Database Performance

The ________ contains the queries,forms,and reports of the database.

Minimizing data redundancy is one of the benefits of normalization.

What appears when you point to a table name of a linked table?

A ________ is a combination of the date and time that is encrypted as part of the digital signature.

What does the Database Splitter do?

What is the main reason to split an Access database?

One benefit of normalization is the improvement of referential integrity enforcement in relationships.

Which process guarantees that you are the only one currently using the database?

________ reduce the time it takes to run queries and reports.

What does a back-end database contain?

________ is the process of altering digital information using an algorithm to make it unreadable to anyone except those who possess the key.

What database format prohibits users from making design and name changes to forms or report within the database,and prohibits users from creating new forms and reports?

There are three normal forms; however,the majority of database designs only require the first two normal forms.

What is a certification authority?

________ makes the database unreadable by encrypting the database.

________ is the protection of data from unauthorized access,change,or destruction.

________ is electronic,encryption-based,secure stamps of authentication that confirms who created the file,that the file is valid,and that no changes have been made to the file after its authentication.

What is database security?

What does the Table Analyzer do?

A ________ is a tabbed menu system that ties the objects in the database together so that the database is easy to use.