{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Test 2 - Test 2 Name Multiple Choice Identify the letter of...

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? ____ 3. What is the field or fields on which the index is built called? ____ 4. When you create an index whose key is a single-field, you have created what type of index? ____ 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? ____ 7. When a primary key cannot allow null values, this restriction is called what? ____ 8. A primary key can consist of how many fields? ____ 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? ____
Background image of page 1

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

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

{[ snackBarMessage ]}