Database Management Tools

Do databases need to be maintained after they have been created?

• Yes

• No

States that table relationships must be consistent. In other words, any foreign key field must agree with the primary key that is referenced by the foreign key.

• Foreign Key

• Primary Key

• Entity integrity

• Referential integrity

a requirement designed to maintain the accuracy of a database

• constraint
• key
• association
• qualifier

Primary key from one table that is used in another table

• Composite Key

• Referential Integrity

• Filter

• Foreign Key

Prevents orphan records, to ensure that records do not reference other records that no longer exist

• Composite Key

• Referential Integrity

• Filter

• Foreign Key

In a split database, the database that contains the tables.

• Delimited File
• Front-End File
• Decrypting
• Back-End File

A database that contains the queries, forms, reports, and other objects created from the tables.

• Back-End File
• Front-End File
• Delimited File
• Fixed-Width File

A copy of a database file.

• Encrypting
• Backup
• Back-End File
• Decrypting

In a split database, the database that contains the tables.

• Delimited File
• Front-End File
• Decrypting
• Back-End File

At least how many characters should your password have?

• 2

• 7

• 8

• 5