CH4-DB - Ch4 True/False Indicate whether the statement is true or false 1 A view is a physical table in the DBMS 2 To create a view in Access you

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

View Full Document Right Arrow Icon
Ch4 True/False Indicate whether the statement is true or false. ____ 1. A view is a physical table in the DBMS. ____ 2. To create a view in Access, you simply create and then save a query. ____ 3. Indexes can make the process of retrieving records fast and efficient. ____ 4. When you create an index whose key has a single field, you have created what is called a single-column in- dex. ____ 5. The command DEL INDEX CustList; would remove the index named CustList. ____ 6. The following command will enable Jones to retrieve data from the Customer table, but not to take any other action: GRANT SELECT ON Customer Jones ; ____ 7. Referential integrity is specified using the FOREIGN KEY clause in the SELECT command. ____ 8. Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values. ____ 9. Information about tables in the database is kept in the system catalog. ____ 10. Access supports triggers. Multiple Choice Identify the choice that best completes the statement or answers the question. ____ 11. The ____ command will create an application program's or individual user's picture of the database. a.
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 10/20/2008 for the course IST 331 taught by Professor Sikder during the Spring '08 term at Cleveland State.

Page1 / 4

CH4-DB - Ch4 True/False Indicate whether the statement is true or false 1 A view is a physical table in the DBMS 2 To create a view in Access you

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