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) 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 
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 
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 
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 
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 
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 
A) single quotes 
B) ​double quotes 
C) parentheses 
D) ​square brackets

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.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

SQL Functions and Procedures

Filters

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

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

SQL Functions and Procedures

Filters

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.