Test 2 - Test 2 Name: _ Multiple Choice Identify the letter...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Test 2 Name: ______________________________ Multiple Choice Identify the letter of the choice that best completes the statement or answers the question. ____ 1. An advantage of a view is to a. provide data independence. b. allow different users to view the same data in different ways. c. have the view contain only those fields required by a given user. d. all of the above are correct ____ 2. The main mechanism for increasing the efficiency with which data is retrieved from the database is known as the what? a. index c. page b. table of contents d. table ____ 3. What is the field or fields on which the index is built called? a. the secondary key c. the index key b. the primary key d. the major key ____ 4. When you create an index whose key is a single-field, you have created what type of index? a. single-field index c. single-row index b. single-column index d. both a and b are correct ____ 5. When you create an index that contains multiple fields, it is also known as what? a. a multiple-field index c. a multiple-column index b. a multiple-row index d. both a and c are correct ____ 6. What is the prevention of unauthorized access to the database? a. Indexing c. View creation b. Security d. Selection ____ 7. When a primary key cannot allow null values, this restriction is called what? a. column integrity c. table integrity b. relational integrity d. entity integrity ____ 8. A primary key can consist of how many fields? a. one only c. as many as necessary b. two only d. none ____ 9. A field or collection of fields in a table whose value is required to match the value of a primary key for a second table is known as a a. foreign key. c. list key. b. secondary key. d. special key. ____ 10. What is the name of the rule that states that if table A contains a foreign key that matches the primary key of table B, the values of this foreign key must either match the value of the primary key for some row in table B or be null? a. entity integrity c. primary integrity b. referential integrity d. secondary integrity ____ 11. The deletion of a record that also deletes related records is referred to as a a. cascading update. c. cascade. b.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/03/2011 for the course IT 101 taught by Professor Kutztown during the Spring '11 term at Columbus State Community College.

Page1 / 6

Test 2 - Test 2 Name: _ Multiple Choice Identify the letter...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online