Question 1

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

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 4

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

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

What are the benefits of using views?

Accepted Answer

The answer of What are the benefits of using views?...

Question 7

The system catalog is also called the _____.

Accepted Answer

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

Question 8

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 9

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 10

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 11

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

The answer of Updating a database using a view can...

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

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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

Exam 7: Database Administration