Rutgers University

ACCOUNTING 485

Chapter 8:

1)The forms editor can do a the following except:

2. In a logical data model, a table is not needed for every                                                                          in the conceptual data model:

3. Which clause in an SQL command determines which tables are accessed?

4. RDBMS tables correspond to what in a traditional flat file system?

5. Transaction logging is a key feature of:

6. When we create a physical data model from our logical data model:

7. Data with repeating items, with a single primary key, and transitive dependencies is in:

8.                 prevents simultaneous updates, but permits simultaneous reading of the data:

9. When the primary key of an entity with multiplicities of 0..1 is to be posted as a foreign key, and load is high, we should

10. When we create a physical data model from our logical data model:

11. RDBMS tuples correspond to what in a traditional flat file system?

12. Advantages of database systems include all of the following except

13. Data without repeating items, with a single primary key, and transitive dependencies is in

14. Which clause in SQL command determines which rows are displayed

15. Which for the following is not a rule for relational database systems?

16. When the primary key of an entity with multiplicities of 0..1 is to be posted as a foreign key, and load is low, we should

17. Potential drawbacks of database systems include all for the following except:

18. The primary key cannot be null and must be unique. This rule is called:

19. The data dictionary does not

20. The language used to create structures for data in the RDBMS is the

21. The language used to access data from programs outside the RDBMS is the

22. Which of the following is not one of the main operations in SQL

23. Relational databases:

24. Which clause in an SQL command determines which columns are displayed?