Question 1

Views provide data validation.​

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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 4

The command used to delete an index is ____________________.​

Accepted Answer

DROP INDEX​

Question 5

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 6

The privilege ____ can be granted to change data.​

Accepted Answer

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

Question 7

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 8

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

Accepted Answer

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

Question 9

Which of the following commands deletes an index?​

Accepted Answer

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

Question 10

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 11

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 12

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 13

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 14

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 15

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 16

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

Accepted Answer

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

Question 17

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 18

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 19

Access does not support the DROP VIEW command.​

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 7: Database Administration

Views provide data validation.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The command used to delete an index is ____________________.​

Correct AnswerverifiedDROP INDEX​

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

Correct AnswerverifiedA

The privilege ____ can be granted to change data.​

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

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

Correct AnswerverifiedShow Answer

Which of the following commands deletes an index?​

Correct AnswerverifiedD

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

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 in Access,create a query to define the view and then save the query object in the database.​

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

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

Correct AnswerverifiedShow Answer

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

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

Access does not support the DROP VIEW command.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Views provide data validation.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

The command used to delete an index is ____________________.

Correct Answer
verified
DROP INDEX

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

Correct Answer
verified
A

The privilege ____ can be granted to change data.

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

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

Correct Answer
verified

Which of the following commands deletes an index?

Correct Answer
verified
D

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

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 in Access,create a query to define the view and then save the query object in the database.

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

The process of managing a database is called database ____________________.

Correct Answer
verified

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

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

Access does not support the DROP VIEW command.

Correct Answer
verified

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

Correct Answer
verified