Database Ch. 4

To insert a new field in a table, the ____ keyword should be used with the ALTER TABLE command.

ADD

The CHECK clause can be included in the ____ command.

ALTER TABLE

The SQL command for deleting the Storehouse field from the Item table is ____.

ALTER TABLE Item DROP COLUMN Storehouse ;

Which of the following statement fragments will only allow a CreditLimit of $5,000, $7,500, or $15,000?

CHECK (CreditLimit IN (5000, 7500, 15000))

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order, the command is ____.

CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

The ____ command will create an application program's or individual user's picture of the database.

CREATE VIEW

The statement, ____, removes the table Smaller from a DBMS.

DROP TABLE Smaller ;

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.

Documenter

A stored procedure is placed on a client computer.

False

A view is a physical table in the DBMS.

False

Access supports stored procedures.

False

One advantage of using views is that they provide data dependence.

False

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

False

The command DEL INDEX CustList; would remove the index named CustList.

False

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

False

Views cannot be used to examine table data

False

To create the primary key clause for the Customer table on the CustomerNum field, the correct statement is ____.

PRIMARY KEY (CustomerNum)

To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields, the correct statement is ____.

PRIMARY KEY (OrderNum, ItemNum)

In Access, a key symbol appears in the row selector of the field that is the ____ key.

Primary

The ____ statement will take away user privileges to the database.

REVOKE

___________________ is the prevention of unauthorized access to the database.

Security

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

Systables

An individual can use a view to create reports, charts, and other objects that show database data.

True

Indexes can increase the efficiency with which data is retrieved from the database.

True

Information about tables in the database is kept in the system catalog.

True

Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values.

True

One advantage of a view is that different users can view the same data in different ways.

True

To create a view in Access, you simply create and then save a query.

True

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

True

A(n) ____ is a computer that is connected to a network and has access through the server to the database.

client

In a client/server system, users access the database through ____.

clients

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

data macro

Within an organization, the ____________________ determines the types of access various users can have to the database.

database administrator DBA

The field or combination of fields on which an index is built is called the ____________________ key.

index

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 ____________________.

index

In SQL, you use the CHECK clause to enforce ____ integrity.

legal-values

A(n) ____________________ index is an index with more than one key field.

multiple-field multiple field multiple-column multiple column

Essentially, setting the value in a given field to ____ is similar to not entering a value in it at all.

null

The type of field for which you should never allow nulls is the ____________________.

primary key

A trigger is stored and compiled on the ____.

server

In a client/server system, the database resides on a computer called the ____.

server

If you anticipate running a particular query often, you can improve overall performance by saving the query in a special file called a(n) ____.

stored procedure

A(n) ____ is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command

trigger

In Access, you can restrict the legal values accepted by a field by entering an appropriate ____________________ that data entered in the field must follow.

validation rule

A row-and-column subset ____ consists of a subset of the rows and columns in some individual table.

view