Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The answer of The process of managing a database is...

Question 3

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

Accepted Answer

The answer of The database administrator uses the ____________________ command...

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

Which of the following commands deletes an index?​

Accepted Answer

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

Question 7

The command used to delete an index is ____________________.​

Accepted Answer

DROP INDEX​

Question 8

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

Accepted Answer

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

Question 9

Views provide data validation.​

Accepted Answer

A) True 
 B)False

Question 10

The privilege ____ can be granted to change data.​

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

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

Question 13

Access does not support the DROP VIEW command.​

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of In a DBMS,the main mechanism for increasing...

Question 15

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

Accepted Answer

The answer of A(n)____________________ subset view consists of a subset...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

The answer of If the user needs to be able...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 7: Database Administration

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following commands deletes an index?​

Correct AnswerverifiedD

The command used to delete an index is ____________________.​

Correct AnswerverifiedDROP INDEX​

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

Correct AnswerverifiedShow Answer

Views provide data validation.​

Correct AnswerverifiedShow Answer

The privilege ____ can be granted to change data.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA

Access does not support the DROP VIEW command.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

The process of managing a database is called database ____________________.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Which of the following commands deletes an index?

Correct Answer
verified
D

The command used to delete an index is ____________________.

Correct Answer
verified
DROP INDEX

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

Correct Answer
verified

Views provide data validation.

Correct Answer
verified

The privilege ____ can be granted to change data.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
A

Access does not support the DROP VIEW command.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

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

Correct Answer
verified