I have 35 written questions and 5 SQL assignments. I will provide all three Query languages for the database and the ER Diagram. For the SQL assignments, you must provide both the SQL statement an

Review Questions 5


Please answer these questions in your own words:


1. What is metadata? Which component of a DBMS maintains meta data?

2. How does a catalog differ from a data dictionary?

3. What is meant by concurrent update?

4. Describe a situation that could cause a lost update.

5. What is locking, and what does it accomplish?

6. Describe two-phase locking.

7. What is deadlock? How does it occur?

8. What is security?

9. What is encryption? How does encryption relate to security?

10. What is authentication? Describe three types of authentication.