Exam 3: The Relational Model: SQL

In Microsoft Access, what do you need to decrypt an encrypted database?

Some enterprise-level systems refer to the catalog as the _____.

Compare techniques for handling concurrent updates in Access and those in larger database management systems on the web.

_____ means that a copy of a database is distributed to other computers or locations.

In a database catalog, _____ includes information about table relationships, views, indexes, and properties.

Which type of data integrity constraint states that the value entered for any field should be consistent with the data type for that field?

How does Access handle concurrent updates?

Database security can be defined as prevention of changes to the structure of a database.

Describe the legal values constraint and how to apply it to best serve database users, including an example to support your answer.

What type of rules specify user privileges to select, insert, update, and delete data for different tables and views?

Which concept of a DBMS means that you change the database structure without requiring you to change the programs that access the database?

Which Microsoft Access feature do you use to set legal value constraints?

What do key integrity constraints consist of?

Which of the following does a DBMS log typically not include for each transaction?

If you want to constrain a Bonus field to the values 250, 500, and 750, what type of constraint should you apply?

Which of the following is a database-as-a-service product?

Which of the following is not a common security feature used by database management systems?

What technique is used to identify the person who is attempting to access the DBMS?

Which of the following is information that the Access Database Documenter does not provide?

Which of the following is an authentication tool in which information used to identify a user is stored on a physical card?