SQL7

When you create a query that involves a view, the DBMS changes the query to one that selects data from the table(s) in the database that created the view.​ T/F

The privilege ____ can be granted to retrieve data.​

Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege along to other users.​ T/F

To create a view definition, use the DEFINE VIEW command.​ T/F

The types of constraints supported in SQL are ____. a.primary keys b.All of the above c.legal values d.foreign keys

A view cannot involve statistics.​ T/F

When renaming columns, you include the new column names in ____ following the name of the view.​

In Oracle, the ____ table contains information about the columns within tables

If two base tables have the same primary key and the primary key is used as the join column, updating the database is a problem.​ T/F

The system catalog is also called the ____.​

A view can join two or more tables.​ T/F

Most database management systems support the creation of views.​ T/F

You can add rows to a view that includes calculations.​ T/F

The general form for assigning a foreign key is ADD FOREIGN KEY, the column name(s) of the foreign key, the ____ clause, and then the table name that the foreign key must match.​

The DROP VIEW command removes the tables and data on which the view is based.​ T/F

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.​

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.​

The main mechanism for providing access to a database is the ____ command.​

An auxiliary key is a column in one table whose values match the primary key in another table.​ T/F

When you create a view, you cannot assign column names that are different from those in the base table.​T/F

The GRANT command to indicate that a user has all privileges includes the FULL privilege.​ T/F

A view is updatable when it is derived from joining two base tables on the ____ of each table.​

To ensure the uniqueness of values in a nonprimary key column, use the ____ command to create an index.​

When the primary key contains more than one column, use commas to separate the column names.​ T/F

Views furnish a certain amount of security; if users are accessing the database through a view, they cannot access any data that is not included in the view.​ T/F

If the database structure changes, the user cannot access and use the view.​ T/F

The existing, permanent tables in a relational database are called stable tables.​ T/F

Views provide a measure of security.​ T/F

An index makes certain types of retrieval more efficient.​ T/F

To create a view in Access, create a query to define the view and then save the query object in the database.​ T/F

Access does not support the DROP VIEW command.​ T/F

In a business organization, a person or an entire group known as the ____ is charged with managing the database.​

In Oracle, the ____ table contains information about the tables known to SQL.​

When you specify a foreign key, the table containing the foreign key is the parent​ T/F

When you specify a foreign key, the table referenced by the foreign key is the ____.

The clause WITH GRANT OPTION is meaningful as part of a REVOKE command.​ T/F

You can only specify a primary key when you first create a table. T/F​

The defining query can be any transaction. T/F

Which of the following commands deletes an index?​

The command to delete a view is ____.​

When users create, alter, or drop tables or create or drop indexes, the DBMS updates the system catalog automatically T/F

The privilege ____ can be granted to change data.​

A view that involves statistics calculated from one or more base tables is the easiest view when attempting to update data. T/F​

You can create and maintain an index for any row in any table.​ T/F

A view is a derived table.​ T/F

The database administrator uses the ____ command to revoke privileges from users.​

Views provide data validation.​ T/F

With a view, the display of data can be customized to meet each user's needs.​ T/F

The privilege ____ can be granted to change the table structure.​

A(n) ____ is an application program's or an individual user's picture of the database.​

The defining query can be any transaction.​ T/F