Question 1

Access does not support the DROP VIEW command.

Accepted Answer

Access does not support the DROP VIEW command, instead, you can delete a query by selecting it in the Navigation Pane and pressing the delete key.

Question 2

The command to delete a view is ____.
A) DROP VIEW
B) DELETE VIEW
C) REMOVE VIEW
D) REVOKE VIEW

Accepted Answer

The command to delete a view in SQL is DROP VIEW. Therefore, option A is the correct choice. Options B, C and D are all incorrect because they are not valid SQL commands for deleting a view.

Question 3

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

Accepted Answer

The answer of You can create and maintain an index...

Question 4

The correct command to allow user Thompson to delete rows in the CUSTOMER table would be: GRANT ____ ON CUSTOMER TO THOMPSON.
A) DROP
B) REMOVE
C) UPDATE
D) DELETE

Accepted Answer

The correct command to allow a user to delete rows in a table is the DELETE command. Therefore, the best choice is D. The GRANT command is used to grant privileges to users on specific objects in a database, such as tables. The ON clause specifies the object (in this case, the CUSTOMER table) and the TO clause specifies the user (in this case, Thompson).

Question 5

In a business organization, a person or an entire group known as the ____ is charged with managing the database.
A) database analyst
B) developer
C) database administrator
D) programmer

Accepted Answer

A database administrator (DBA) is responsible for the performance, security, and availability of a company's database. They manage the data, install and configure database software, troubleshoot issues, and ensure data backup and recovery. A database analyst may be focused more on analyzing data and making recommendations based on it, while a developer or programmer may create applications that interact with the database but may not be responsible for its overall management.

Question 6

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

Accepted Answer

You can alter a table and add a primary key later on using the ALTER TABLE statement.

Question 7

When you specify a foreign key, the table containing the foreign key is the parent.

Accepted Answer

The table containing the referenced (primary) key is the parent, while the table containing the foreign key is the child.

Question 8

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

The answer of You use the LEGAL clause of the...

Question 9

A(n) ____ is an application program's or an individual user's picture of the database.
A) transaction
B) view
C) catalog
D) index

Accepted Answer

A view is a customized representation of the database that is tailored to the needs of a specific user or application program. It is a virtual table that does not store data, but rather retrieves and manipulates data from one or more underlying database tables. Views can be used to simplify data access, enhance data security, and provide a logical or hierarchical structure to the data. Transactions are a series of actions that represent a single logical unit of work, a catalog is a directory of database objects and their attributes, and an index is a data structure used to speed up data retrieval. None of these options fully match the description of an application program's or user's picture of the database.

Question 10

The main mechanism for providing access to a database is the ____ command.
A) PERMIT
B) ACCESS
C) GRANT
D) REVOKE

Accepted Answer

The GRANT command is used to provide access to a database by granting specific permissions to users or roles. The other listed options are also used to manage database access, but do not serve as the main mechanism for providing that access.

Question 11

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

Accepted Answer

An auxiliary key is not necessarily required to match the primary key of another table. It is simply a column that can be used to establish a relationship between two tables.

Question 12

An index makes certain types of retrieval more efficient.

Accepted Answer

An index is a data structure that is created to improve the speed of data retrieval operations on a database table. By creating an index on a table, the database can quickly find the data according to the values in the indexed columns, rather than scanning the entire table every time. Therefore, an index makes certain types of data retrieval more efficient.

Question 13

Normally, when the database administrator grants a particular privilege to a user, the user cannot pass that privilege along to other users.

Accepted Answer

This is because the database administrator can only grant privileges directly to users and cannot delegate that authority to other users.

Question 14

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

Accepted Answer

The answer of The clause WITH GRANT OPTION is meaningful...

Question 15

The DBMS provides integrity administration, the process of specifying integrity constraints for a database that the DBMS will enforce.

Accepted Answer

The answer of The DBMS provides integrity administration, the process...

Question 16

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.
A) AC
B) SA
C) AS
D) IN

Accepted Answer

The CREATE VIEW command includes the name of the view, the word "AS", and then a query. This is the syntax for creating a view in SQL.

Question 17

A view is updatable when it is derived from joining two base tables on the ____ of each table.
A) row-column
B) foreign key
C) primary key
D) index

Accepted Answer

A view is updatable when it is derived from joining two base tables on the primary key of each table. The primary key ensures that each row in a table is unique and can be used to identify a specific row, which is necessary for updating the view. Joining two tables on their primary keys also ensures that the view is not ambiguous and can be updated without causing data inconsistencies.

Question 18

When the primary key contains more than one column, use commas to separate the column names.

Accepted Answer

When a primary key contains more than one column, the column names must be separated by commas in the CREATE TABLE statement.

Question 19

When renaming columns, you include the new column names in ____ following the name of the view.
A) single quotes
B) double quotes
C) parentheses
D) square brackets

Accepted Answer

The answer of When renaming columns, you include the new...

Question 20

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

Accepted Answer

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

Quiz 7: Database Administration

Access does not support the DROP VIEW command.

The command to delete a view is ____.

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

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

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

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

When you specify a foreign key, the table containing the foreign key is the parent.

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.

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

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