Question 1

You can only specify a primary key when you first create a table.​

Accepted Answer

A) True 
 B)False

Question 2

Information about tables in the database is kept in the system ____________________.​

Accepted Answer

The answer of Information about tables in the database is...

Question 3

The command used to create an index is ____________________.​

Accepted Answer

The answer of The command used to create an index...

Question 4

A view cannot involve statistics.​

Accepted Answer

A) True 
 B)False

Question 5

The GRANT command to indicate that a user has all privileges includes the FULL privilege.​

Accepted Answer

A) True 
 B)False

Question 6

The privilege ____ can be granted to retrieve data.​

Accepted Answer

A) SELECT 
B) ​UPDATE 
C) RETRIEVE 
D) ​READ 
A) SELECT 
B) ​UPDATE 
C) RETRIEVE 
D) ​READ

Question 7

The main mechanism for providing access to a database is the ____ command.​

Accepted Answer

A) PERMIT 
B) ​ACCESS 
C) GRANT 
D) ​REVOKE 
A) PERMIT 
B) ​ACCESS 
C) GRANT 
D) ​REVOKE

Question 8

Views provide a measure of security.​

Accepted Answer

A) True 
 B)False

Question 9

The main mechanism for providing access to a database is the ____________________ command.​

Accepted Answer

The answer of The main mechanism for providing access to...

Question 10

If the database structure changes,the user cannot access and use the view.​

Accepted Answer

A) True 
 B)False

Question 11

What are the disadvantages of using an index?​

Accepted Answer

First,an index occupies disk space.Using

Question 12

The existing,permanent tables in a relational database are called stable tables.​

Accepted Answer

A) True 
 B)False

Question 13

What are the benefits of using views?​

Accepted Answer

The use of views provides several benefi

Question 14

The command to delete a view is ____.​

Accepted Answer

A) DROP VIEW 
B) ​DELETE VIEW 
C) REMOVE VIEW 
D) ​REVOKE VIEW 
A) DROP VIEW 
B) ​DELETE VIEW 
C) REMOVE VIEW 
D) ​REVOKE VIEW

Question 15

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be:
GRANT ____ ON CUSTOMER TO THOMPSON.​

Accepted Answer

A) DROP 
B) ​REMOVE 
C) UPDATE 
D) ​DELETE 
A) DROP 
B) ​REMOVE 
C) UPDATE 
D) ​DELETE

Question 16

An auxiliary key is a column in one table whose values match the primary key in another table.​

Accepted Answer

A) True 
 B)False

Question 17

A view is defined by creating a defining ____________________,which indicates the rows and columns to include in the view.​

Accepted Answer

The answer of A view is defined by creating a...

Question 18

An index makes certain types of retrieval more efficient.​

Accepted Answer

A) True 
 B)False

Question 19

An integrity ____________________ is a rule for the data in the database.​

Accepted Answer

The answer of An integrity ____________________ is a rule for...

Question 20

A view is updatable when it is derived from joining two base tables on the ____ of each table.​

Accepted Answer

A) row-column 
B) ​foreign key 
C) primary key 
D) ​index 
A) row-column 
B) ​foreign key 
C) primary key 
D) ​index

You can only specify a primary key when you first create a table.

Information about tables in the database is kept in the system ____________________.

The command used to create an index is ____________________.

A view cannot involve statistics.

The GRANT command to indicate that a user has all privileges includes the FULL privilege.

The privilege ____ can be granted to retrieve data.

The main mechanism for providing access to a database is the ____ command.

Views provide a measure of security.

The main mechanism for providing access to a database is the ____________________ command.

If the database structure changes,the user cannot access and use the view.

What are the disadvantages of using an index?

The existing,permanent tables in a relational database are called stable tables.

What are the benefits of using views?

The command to delete a view is ____.

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

An auxiliary key is a column in one table whose values match the primary key in another table.

A view is defined by creating a defining ____________________,which indicates the rows and columns to include in the view.

An index makes certain types of retrieval more efficient.

An integrity ____________________ is a rule for the data in the database.

A view is updatable when it is derived from joining two base tables on the ____ of each table.

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

You can only specify a primary key when you first create a table.​

Information about tables in the database is kept in the system ____________________.​

The command used to create an index is ____________________.​

A view cannot involve statistics.​

The GRANT command to indicate that a user has all privileges includes the FULL privilege.​

The privilege ____ can be granted to retrieve data.​

The main mechanism for providing access to a database is the ____ command.​

Views provide a measure of security.​

The main mechanism for providing access to a database is the ____________________ command.​

If the database structure changes,the user cannot access and use the view.​

What are the disadvantages of using an index?​

The existing,permanent tables in a relational database are called stable tables.​

What are the benefits of using views?​

The command to delete a view is ____.​

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.​

An auxiliary key is a column in one table whose values match the primary key in another table.​

A view is defined by creating a defining ____________________,which indicates the rows and columns to include in the view.​

An index makes certain types of retrieval more efficient.​

An integrity ____________________ is a rule for the data in the database.​

A view is updatable when it is derived from joining two base tables on the ____ of each table.​

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

You can only specify a primary key when you first create a table.

Information about tables in the database is kept in the system ____________________.

The command used to create an index is ____________________.

A view cannot involve statistics.

The GRANT command to indicate that a user has all privileges includes the FULL privilege.

The privilege ____ can be granted to retrieve data.

The main mechanism for providing access to a database is the ____ command.

Views provide a measure of security.

The main mechanism for providing access to a database is the ____________________ command.

If the database structure changes,the user cannot access and use the view.

What are the disadvantages of using an index?

The existing,permanent tables in a relational database are called stable tables.

What are the benefits of using views?

The command to delete a view is ____.

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.

An auxiliary key is a column in one table whose values match the primary key in another table.

A view is defined by creating a defining ____________________,which indicates the rows and columns to include in the view.

An index makes certain types of retrieval more efficient.

An integrity ____________________ is a rule for the data in the database.

A view is updatable when it is derived from joining two base tables on the ____ of each table.