Deck 7: Database Administration

Question 1

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

Answer 1

True

Question 2

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

Answer 2

False

Question 3

Views provide a measure of security.​

Answer 3

True

Question 4

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

Question 5

You cannot delete a row from a view.​

Question 6

A view can join two or more tables.​

Question 7

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

Question 8

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

Question 9

Views provide data validation.​

Question 10

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

Question 11

The defining query can be any transaction.​

Question 12

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

Question 13

A view cannot involve statistics.​

Question 14

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

Question 15

Most database management systems support the creation of views.​

Question 16

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

Question 17

A view is a derived table.​

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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

Question 23

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

Question 24

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 25

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

Question 26

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 27

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

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

Question 28

When users create,alter,or drop tables or create or drop indexes,the DBMS updates the system catalog automatically.​

Question 29

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

Question 30

Access does not support the DROP VIEW command.​

Question 31

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

Question 32

The command to delete a view is ____.​

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

Question 33

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 34

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 35

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

Question 36

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

Question 37

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

Question 38

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 39

An index makes certain types of retrieval more efficient.​

Question 40

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 41

The privilege ____ can be granted to change data.​

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

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)____________________ subset view consists of a subset of the rows and columns in some base table.​

Question 44

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

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

Question 45

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 46

The privilege ____ can be granted to retrieve data.​

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

Question 47

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 48

To create a view definition,use the ____________________ command.​

Question 49

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

Question 50

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

Question 51

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

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

Question 52

The process of managing a database is called database ____________________.​

Question 53

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 54

The types of constraints supported in SQL are ____.​

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

Question 55

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

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

Question 56

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

Question 57

The system catalog is also called the ____.​

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

Question 58

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

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

Question 59

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

Question 60

____________________ is the prevention of unauthorized access to a database.​

Question 61

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

Question 62

In a DBMS,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.​

Question 63

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

Question 64

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 65

The command used to create an index is ____________________.​

Question 66

What are the benefits of using views?​

Question 67

What are the disadvantages of using an index?​

Question 68

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

Question 69

The command used to delete an index is ____________________.​

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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