Question 1

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 
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 2

An index makes certain types of retrieval more efficient.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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

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

Question 6

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

Accepted Answer

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

Question 7

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 8

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; 
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 9

What are the disadvantages of using an index?

Accepted Answer

First, an index occupies disk space. Usi

Question 10

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

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 
A)  database analyst 
B)  developer 
C)  database administrator 
D)  programmer

Question 12

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 
A)  CREATE UNIQUE INDEX command 
B)  CREATE NONPRIMARY INDEX command 
C)  CREATE INDEX command 
D)  CREATE ONLY INDEX command

Question 13

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 
A)  customization and data independence 
B)  simplicity and security 
C)  data independence and portability 
D)  performance and reliability

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

When you create a query that involves a

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

An index makes certain types of retrieval more efficient.

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

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?

Which of the following commands deletes an index?

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

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

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

What are the disadvantages of using an index?

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?

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

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

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

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

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

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Functions Procedures and Triggers

Filters

Exam 7: Database Administration

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

An index makes certain types of retrieval more efficient.

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

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?

Which of the following commands deletes an index?

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

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

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

What are the disadvantages of using an index?

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?

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

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

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

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

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

Introduction to Kimtay Pet Supplies and Staywell Student Accommodation Databases

Database Design Fundamentals

Creating Tables

Single Table Queries

Multiple Table Queries

Updating Data

Functions Procedures and Triggers

Filters