Deck 7: Database Administration

Question 1

The defining query can be any transaction.

Answer 1

False

Question 2

A view cannot involve statistics.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

You cannot delete a row from a view.

Question 5

A view can join two or more tables.

Question 6

Most database management systems support the creation of views.

Question 7

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

Question 8

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

Question 9

Views provide a measure of security.

Question 10

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.

Question 11

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

Question 12

MySQL version 4.1 supports views.

Question 13

An index makes certain types of retrieval more efficient.

Question 14

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

Question 15

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

Question 16

A view is a derived table.

Question 17

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 18

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 19

Views provide data validation.

Question 20

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

Question 21

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

Question 22

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 23

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 24

MySQL version 5.0 provides support for views.

Question 25

The types of constraints supported in MySQL are ____.

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

Question 26

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

Question 27

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

Question 28

The defining query for a view can be any valid SQL query.

Question 29

Which of the following commands lists all the privileges granted to a user?

A)SHOW GRANTS
B)SHOW PRIVILEGES
C)SHOW USERS
D)SHOW SECURITY

Question 30

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

Question 31

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

Question 32

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

Question 33

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

Question 34

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 35

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

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

Question 36

Columns that are not included in the view are not accessible to the view's user.

Question 37

The DROP VIEW command removes only a view definition.

Question 38

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 39

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 40

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

Question 41

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

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

Question 42

Which of the following commands deletes an index?

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

Question 43

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

Question 44

The system catalog is also called the ____.

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

Question 45

To create a view definition, use the ____________________ command.

Question 46

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

Question 47

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

Question 48

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 49

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 50

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

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

Question 51

The privilege ____ can be granted to change data.

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

Question 52

The ____ command lists all tables in the default database.

A)SHOW TABLES
B)DISPLAY TABLES
C)VIEW TABLES
D)LIST TABLES

Question 53

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

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

Question 54

To list all the indexes associated with a table, use the ____ command.

A)SHOW INDEX
B)VIEW INDEX
C)LIST INDEX
D)DISPLAY INDEX

Question 55

Which of the following commands deletes a view?

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

Question 56

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

Question 57

The privilege ____ can be granted to retrieve data.

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

Question 58

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

Question 59

The process of managing a database is called database ____________________.

Question 60

The ____________________ command lists all the columns in a given table.

Question 61

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

Question 62

The command used to delete an index is ____________________.

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

What are the benefits of using views?

Question 70

____________________ is the prevention of unauthorized access to a database.

Question 71

The command used to create an index is ____________________.

Question 72

What are the disadvantages of using an index?

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

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

Question 75

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