Question 1

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 2

The command used to delete an index is ____________________.​

Accepted Answer

DROP INDEX​

Question 3

Which of the following commands deletes an index?​

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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 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 specify a foreign key,the table referenced by the foreign key is the ____.​

Accepted Answer

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

Question 8

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 9

Access does not support the DROP VIEW command.​

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

Views provide data validation.​

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

A) True 
 B)False

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

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 19

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 20

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

Exam 7: Database Administration

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

The command used to delete an index is ____________________.

Which of the following commands deletes an index?

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

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

The privilege ____ can be granted to change data.

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

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

Access does not support the DROP VIEW command.

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

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

Views provide data validation.

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

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

The process of managing a database is called database ____________________.

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

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

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.

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

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

Exam 7: Database Administration

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

The command used to delete an index is ____________________.​

Which of the following commands deletes an index?​

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

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

The privilege ____ can be granted to change data.​

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

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

Access does not support the DROP VIEW command.​

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

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

Views provide data validation.​

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

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

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

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

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

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

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

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

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

The command used to delete an index is ____________________.

Which of the following commands deletes an index?

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

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

The privilege ____ can be granted to change data.

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

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

Access does not support the DROP VIEW command.

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

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

Views provide data validation.

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

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

The process of managing a database is called database ____________________.

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

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

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.

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

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