Question 1

What happens if Samantha, whose view of the database contains only a portion of the rows and columns of the base table, attempts to add a row to the table through her view?

Accepted Answer

A)   Samantha's INSERT command will automatically be rejected.
B)   Samantha could accidentally add a row with a duplicate primary key to the table.
C)   If Samantha's INSERT command succeeds, the new row will contain several null values.
D)   If all the columns in the base table accept nulls, Samantha's INSERT command will fail.

Question 2

When renaming columns for a view, 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

Question 3

Which command will allow user Thompson to remove rows from the CUSTOMER table?

Accepted Answer

A)   GRANT DROP ON CUSTOMER TO THOMPSON;
B)   GRANT THOMPSON REMOVE ON CUSTOMER;
C)   SELECT* CUSTOMER GRANT THOMPSON DELETE;
D)   GRANT DELETE ON CUSTOMER TO THOMPSON;

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

Martine's database administrator has set up a view for her so that she can access the information she needs from the database. What will happen when new columns Martine does not need to see are added to the base tables used for Martine's view?

Accepted Answer

A)   The new columns will appear in Martine's view.
B)   The data independence provided by the view will be lost.
C)   The administrator will have to change the view's defining query.
D)   Martine can continue to use her view as usual.

Question 7

What does this SQL command accomplish? ALTER TABLE PRODUCTS
ADD CHECK (SIZE IN ('S', 'M', 'L', 'XL', 'XXL') ) ;

Accepted Answer

A)   updates all values in the SIZE column
B)   adds a parent-child constraint to the PRODUCTS table
C)   establishes a foreign key for the PRODUCTS table
D)   establishes legal values for the SIZE column

Question 8

Views can contain only the columns required by a given user. What two advantages are conferred by this aspect of views?

Accepted Answer

A)   customization and data independence
B)   simplicity and security
C)   data independence and portability
D)   performance and reliability

Question 9

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

Accepted Answer

When you create a query that involves a ...

Question 10

To ensure the uniqueness of values in a nonprimary key column, you can create an index using the _____.

Accepted Answer

A)   CREATE UNIQUE INDEX command
B)   CREATE NONPRIMARY INDEX command
C)   CREATE INDEX command
D)   CREATE ONLY INDEX command

Question 11

What are the disadvantages of using an index?

Accepted Answer

First, an index occupies disk space. Usi...

Question 12

An index makes certain types of retrieval more efficient.

Accepted Answer

A) True 
 B)False

Question 13

In a business organization, the person or entire group of people charged with managing the database is known as the _____.

Accepted Answer

A)   database analyst
B)   developer
C)   database administrator
D)   programmer

Question 14

Which privilege can be granted to allow a user to retrieve data?

Accepted Answer

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

Question 15

Which of the following commands deletes an index?

Accepted Answer

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

Exam 7: Database Administration

Martine's database administrator has set up a view for her so that she can access the information she needs from the database. What will happen when new columns Martine does not need to see are added to the base tables used for Martine's view?

Correct Answer
verified

Views can contain only the columns required by a given user. What two advantages are conferred by this aspect of views?

Correct Answer
verified

What happens if Samantha, whose view of the database contains only a portion of the rows and columns of the base table, attempts to add a row to the table through her view?

Correct Answer
verified

What are the disadvantages of using an index?

Correct Answer
verified
First, an index occupies disk space. Usi...
View Answer

To ensure the uniqueness of values in a nonprimary key column, you can create an index using the _____.

Correct Answer
verified

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

Correct Answer
verified
When you create a query that involves a ...
View Answer

Which of the following commands deletes an index?

Correct Answer
verified

Which command will allow user Thompson to remove rows from the CUSTOMER table?

Correct Answer
verified

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

Correct Answer
verified

In a business organization, the person or entire group of people charged with managing the database is known as the _____.

Correct Answer
verified

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

Correct Answer
verified

What does this SQL command accomplish? ALTER TABLE PRODUCTS ADD CHECK (SIZE IN ('S', 'M', 'L', 'XL', 'XXL') ) ;

Correct Answer
verified

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

Correct Answer
verified

An index makes certain types of retrieval more efficient.

Correct Answer
verified

Which privilege can be granted to allow a user to retrieve data?

Correct Answer
verified

Exam 7: Database Administration

Martine's database administrator has set up a view for her so that she can access the information she needs from the database. What will happen when new columns Martine does not need to see are added to the base tables used for Martine's view?

Correct AnswerverifiedShow Answer

Views can contain only the columns required by a given user. What two advantages are conferred by this aspect of views?

Correct AnswerverifiedShow Answer

What happens if Samantha, whose view of the database contains only a portion of the rows and columns of the base table, attempts to add a row to the table through her view?

Correct AnswerverifiedShow Answer

What are the disadvantages of using an index?

Correct AnswerverifiedFirst, an index occupies disk space. Usi...View AnswerShow Answer

To ensure the uniqueness of values in a nonprimary key column, you can create an index using the _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedWhen you create a query that involves a ...View AnswerShow Answer

Which of the following commands deletes an index?

Correct AnswerverifiedShow Answer

Which command will allow user Thompson to remove rows from the CUSTOMER table?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In a business organization, the person or entire group of people charged with managing the database is known as the _____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What does this SQL command accomplish? ALTER TABLE PRODUCTS ADD CHECK (SIZE IN ('S', 'M', 'L', 'XL', 'XXL') ) ;

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

An index makes certain types of retrieval more efficient.

Correct AnswerverifiedShow Answer

Which privilege can be granted to allow a user to retrieve data?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
First, an index occupies disk space. Usi...
View Answer

Correct Answer
verified

Correct Answer
verified
When you create a query that involves a ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified