Deck 7: Database Administration

Question 1

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

Answer 1

False

Question 2

Views provide a measure of security.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

The existing, permanent tables in a relational database are called stable tables.

Question 5

You can add rows to a view that includes calculations.

Question 6

You cannot delete a row from a view.

Question 7

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

Question 8

If the database structure changes, the user cannot access and use the view.

Question 9

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

Question 10

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.

Question 11

To add a row to your view, simply add a row to each underlying derived table.

Question 12

Most database management systems support the creation of views.

Question 13

To create a view definition, use the DEFINE VIEW command.

Question 14

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.

Question 15

A view is a derived table.

Question 16

A view can join two or more tables.

Question 17

Views provide data validation.

Question 18

The DROP VIEW command removes the tables and data on which the view is based.

Question 19

The defining query can be any transaction.

Question 20

A view cannot involve statistics.

Question 21

Access does not support the DROP VIEW command.

Question 22

The command to delete a view is ____.

A) DROP VIEW
B) DELETE VIEW
C) REMOVE VIEW
D) REVOKE VIEW

Question 23

You can create and maintain an index for any row in any table.

Question 24

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

A) DROP
B) REMOVE
C) UPDATE
D) DELETE

Question 25

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

A) database analyst
B) developer
C) database administrator
D) programmer

Question 26

You can only specify a primary key when you first create a table.

Question 27

When you specify a foreign key, the table containing the foreign key is the parent.

Question 28

You use the LEGAL clause of the ALTER TABLE command to ensure that only legal values satisfying a particular condition are allowed in a given column.

Question 29

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

A) transaction
B) view
C) catalog
D) index

Question 30

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

A) PERMIT
B) ACCESS
C) GRANT
D) REVOKE

Question 31

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

Question 32

An index makes certain types of retrieval more efficient.

Question 33

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

Question 34

The clause WITH GRANT OPTION is meaningful as part of a REVOKE command.

Question 35

The DBMS provides integrity administration, the process of specifying integrity constraints for a database that the DBMS will enforce.

Question 36

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

A) AC
B) SA
C) AS
D) IN

Question 37

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

A) row-column
B) foreign key
C) primary key
D) index

Question 38

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

Question 39

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

A) single quotes
B) double quotes
C) parentheses
D) square brackets

Question 40

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

Question 41

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

Question 42

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

A) DBA_TABLES
B) SHOW_TABLES
C) ALL_TABLES
D) SP_TABLES

Question 43

A(n) ____________________ subset view consists of a subset of the rows and columns in some base table.

Question 44

A view is defined by creating a defining ____________________, which indicates the rows and columns to include in the view.

Question 45

Which of the following commands deletes an index?

A) DELETE INDEX
B) REMOVE INDEX
C) UNINDEX
D) DROP INDEX

Question 46

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

A) DROP
B) REMOVE
C) REVOKE
D) CANCEL

Question 47

____________________ is the prevention of unauthorized access to a database.

Question 48

To create a view definition, use the ____________________ command.

Question 49

The privilege ____ can be granted to change data.

A) WRITE
B) UPDATE
C) ALTER
D) READ AND WRITE

Question 50

The process of managing a database is called database ____________________.

Question 51

The privilege ____ can be granted to retrieve data.

A) SELECT
B) UPDATE
C) RETRIEVE
D) READ

Question 52

The system catalog is also called the ____.

A) system database
B) data dictionary
C) master data table
D) transaction database

Question 53

The types of constraints supported in SQL are ____.

A) primary keys
B) foreign keys
C) legal values
D) All of the above

Question 54

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

A) WRITE
B) UPDATE
C) ALTER
D) MODIFY

Question 55

When a view is no longer needed, you can remove it using the ____________________ command.

Question 56

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.

A) WHERE
B) REFERENCES
C) FROM
D) IN

Question 57

In general, views that involve joins of ____________________ tables can cause problems at update.

Question 58

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

A) CREATE UNIQUE INDEX
B) CREATE NONPRIMARY INDEX
C) CREATE INDEX
D) CREATE ONLY INDEX

Question 59

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

A) SYSCOLUMNS
B) DBA_TAB_COLUMNS
C) COLUMNS
D) SHOW_COLUMNS

Question 60

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

A) super
B) sibling
C) parent
D) child

Question 61

The GRANT command to indicate that all users can retrieve data using a SELECT command includes the word ____________________ rather than the specific name of a user.

Question 62

What are the benefits of using views?

Question 63

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

Question 64

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

Question 65

To add a primary key after creating a table, you can use the ____________________ clause of the ALTER TABLE command.

Question 66

The command used to create an index is ____________________.

Question 67

If the user needs to be able to pass the privilege to other users, the GRANT command must include the ____________________ clause.

Question 68

An integrity ____________________ is a rule for the data in the database.

Question 69

You can create and use a(n) ____________________ to speed up the searching process significantly.

Question 70

Explain what happens when you create a query that involves a view.

Question 71

What are the disadvantages of using an index?

Question 72

The command used to delete an index is ____________________.

Question 73

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

Question 74

To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the ____________________ command.

Question 75

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