Question 1

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 2

The types of constraints supported in SQL are ____.

Accepted Answer

A)   data types, indexes, and system catalogs
B)   foreign keys, qualifiers, and naming conventions
C)   user privileges, data types, and legal values
D)   primary keys, foreign keys, and legal values D

Question 3

Updating a database using a view can pose problems. Describe some of these problems that occur with views that join two or more base tables. How can a database administrator minimize problems when creating views that join tables?

Accepted Answer

In general, views that involve joins of ...

Question 4

What are the benefits of using views?

Accepted Answer

The use of views provides several benefi...

Question 5

The issues involved in updating data within base tables through a view are the same regardless of the type of view.

Accepted Answer

A) True 
 B)False

Question 6

When you specify a foreign key, the table referenced by the foreign key is the _____.

Accepted Answer

A)   super
B)   sibling
C)   parent
D)   child

Question 7

In Oracle, which table contains information about the columns within tables?

Accepted Answer

A)   SYSTABLES
B)   DBA_TAB_COLUMNS
C)   COLUMNS
D)   USER_OBJECTS

Question 8

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.

Accepted Answer

A)   AC
B)   SA
C)   AS
D)   IN

Question 9

Adding rows to a view is most troublesome for the view user when that view contains _____.

Accepted Answer

A)   statistics calculated from base tables
B)   a base table's primary key
C)   more than five columns
D)   data from more than one base table

Question 10

A database can be readily updated through a view when that view is derived from joining two base tables on a shared _____.

Accepted Answer

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

Question 11

Percy is promoted and is no longer responsible for making updates to several database tables. Which command should Percy's database administrator use to prevent Percy from making future updates?

Accepted Answer

A)   DROP
B)   REMOVE
C)   REVOKE
D)   CANCEL C

Question 12

Which privilege should be granted to users who are authorized to change a table's structure?

Accepted Answer

A)   WRITE
B)   UPDATE
C)   ALTER
D)   MODIFY

Question 13

Which statement about views is correct?

Accepted Answer

A)   A view can join two or more tables and/or involve statistics.
B)   A view is a temporary table the DBMS creates in response to a query.
C)   A query of a view is executed in the form in which the user enters it.
D)   The column names in a view must match those in the base table(s) .

Question 14

What happens once the following command is executed? ALTER TABLE ORDERS
ADD FOREIGN KEY (CLIENT_ID)  REFERENCES CLIENT (CLIENT_ID) ;

Accepted Answer

A)   The DBMS will reject updates to the ORDERS table with CLIENT_ID values missing from the CLIENT table.
B)   The DBMS will reject the insertion of rows that have different primary keys but are otherwise identical into the ORDERS table.
C)   The DBMS will reject updates to the CLIENT table with CLIENT_ID values missing from the ORDERS table.
D)   The DBMS will ensure that only legal values are entered into the CLIENT_ID column in the ORDERS table.

Question 15

An index _____.

Accepted Answer

A)   involves complexities that are not managed directly by most DBMSs
B)   can be essential to the retrieval performance of very large database
C)   must be created at the same time as the database
D)   provides significant benefits for databases of all sizes

Question 16

A program's or an individual user's picture of the database is called a(n)  _____.

Accepted Answer

A)   transaction
B)   view
C)   catalog
D)   index B

Question 17

The system catalog is also called the _____.

Accepted Answer

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

Question 18

The purpose of creating databases indexes is to _____.

Accepted Answer

A)   maintain the integrity of the data stored in tables
B)   reduce the database's storage (memory)  requirements
C)   avoid searching through every row in a table with every query
D)   grant and/or revoke privileges for certain actions to users

Question 19

Which MySQL command displays all tables associated with the database ELPATRON?

Accepted Answer

A)   SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA = 'ELPATRON') ;
B)   SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE (TABLE_SCHEMA = 'ELPATRON') ;
C)   SELECT * FROM USER_OBJECTS 'ELPATRON';
D)   SHOW TABLES WHERE TABLE_SCHEMA = ELPATRON;

Question 20

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 and column that the foreign key must match.

Accepted Answer

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

Exam 7: Database Administration

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.

Correct AnswerverifiedShow Answer

The types of constraints supported in SQL are ____.

Correct AnswerverifiedD

Updating a database using a view can pose problems. Describe some of these problems that occur with views that join two or more base tables. How can a database administrator minimize problems when creating views that join tables?

Correct AnswerverifiedIn general, views that involve joins of ...View AnswerShow Answer

What are the benefits of using views?

Correct AnswerverifiedThe use of views provides several benefi...View AnswerShow Answer

The issues involved in updating data within base tables through a view are the same regardless of the type of view.

Correct AnswerverifiedShow Answer

When you specify a foreign key, the table referenced by the foreign key is the _____.

Correct AnswerverifiedShow Answer

In Oracle, which table contains information about the columns within tables?

Correct AnswerverifiedShow Answer

The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, the word ____, and then a query.

Correct AnswerverifiedShow Answer

Adding rows to a view is most troublesome for the view user when that view contains _____.

Correct AnswerverifiedShow Answer

A database can be readily updated through a view when that view is derived from joining two base tables on a shared _____.

Correct AnswerverifiedShow Answer

Percy is promoted and is no longer responsible for making updates to several database tables. Which command should Percy's database administrator use to prevent Percy from making future updates?

Correct AnswerverifiedC

Which privilege should be granted to users who are authorized to change a table's structure?

Correct AnswerverifiedShow Answer

Which statement about views is correct?

Correct AnswerverifiedShow Answer

What happens once the following command is executed? ALTER TABLE ORDERS ADD FOREIGN KEY (CLIENT_ID) REFERENCES CLIENT (CLIENT_ID) ;

Correct AnswerverifiedShow Answer

An index _____.

Correct AnswerverifiedShow Answer

A program's or an individual user's picture of the database is called a(n) _____.

Correct AnswerverifiedB

The system catalog is also called the _____.

Correct AnswerverifiedShow Answer

The purpose of creating databases indexes is to _____.

Correct AnswerverifiedShow Answer

Which MySQL command displays all tables associated with the database ELPATRON?

Correct AnswerverifiedShow Answer

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 and column that the foreign key must match.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified
In general, views that involve joins of ...
View Answer

Correct Answer
verified
The use of views provides several benefi...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified