Exam 4: The Relational Model 3: Advanced Topics

Access has a tool called the ____________________, which allows you to easily print detailed documentation concerning any table, query, report, form, or other object in the database.

Which rule uses a foreign key in Table B to ensure that the field matches a primary key field in Table A?

In SQL, what type of integrity are you enforcing by using the CHECK clause?

Which statement removes the table Category from a DBMS?

When a new table is added or deleted, or the structure of a table is changed, where does the DBMS record these changes?

You use the __________ statement to give users privileges to the database.

When you create an index whose key has a single field, you have created what is called a single-column index.

A value of ________ is used when a value is missing, unknown, or inapplicable.

When you create a query that involves a view, the DBMS immediately executes the query you created.

Where can you save a query if you anticipate running it often?

Within relational model systems on both mainframes and personal computers, the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.

What are the advantages of having views only contain the fields required by a given user?

In a system catalog, the ____________________ table contains information about the tables known to SQL.

You can take away user privileges to the database using the ____________ statement.

Which of the following is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command?

In Access, a(n) ____________________ enables you to add logic to table events such as adding, changing, or deleting data.

Views cannot be used to examine table data.

Referential integrity is specified using the FOREIGN KEY clause in the CREATE TABLE command.

The following command will enable Jones to retrieve data from the Customer table, but not to take any other action: GRANT SELECT ON Customer To Jones ;

In SQL, you specify _____________ integrity using a FOREIGN KEY clause in either the CREATE TABLE or ALTER TABLE commands.