Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The answer of When a view is no longer needed,you...

Question 3

A view can join two or more tables.​

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

When you create a query that involves a

Question 6

The types of constraints supported in SQL are ____.​

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

The answer of In general,views that involve joins of ____________________...

Question 10

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

Accepted Answer

The answer of The GRANT command to indicate that all...

Question 11

The system catalog is also called the ____.​

Accepted Answer

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

Question 12

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

Accepted Answer

A) WHERE 
B) ​REFERENCES 
C) FROM 
D) ​IN 
A) WHERE 
B) ​REFERENCES 
C) FROM 
D) ​IN

Question 13

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

Accepted Answer

The answer of A(n)____________________ is an application program's or an...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

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.

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

A view can join two or more tables.

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

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

The types of constraints supported in SQL are ____.

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

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

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

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.

The system catalog is also called the ____.

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(n)____________________ is an application program's or an individual user's picture of the database.

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.

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

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

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

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

A view can join two or more tables.​

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

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

The types of constraints supported in SQL are ____.​

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

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

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

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

The system catalog is also called the ____.​

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(n)____________________ is an application program's or an individual user's picture of the database.​

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

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

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

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.

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

A view can join two or more tables.

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

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

The types of constraints supported in SQL are ____.

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

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

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

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.

The system catalog is also called the ____.

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(n)____________________ is an application program's or an individual user's picture of the database.

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.

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