CSC 365 FINAL REVIEW UPDATED ACTUAL QUESTIONS AND CORRECT ANSWERS

CSC 365 FINAL REVIEW UPDATED ACTUAL QUESTIONS
AND CORRECT ANSWERS

Question:
1. What is a DBMS?
Answer:
• database management system

Question:
2. What are features of a DBMS?
Answer:
• EFFICIENT ACCESS to data: using indices to
• access CONTROL: who can see and change the data?
• CONCURRENT access: can multiple users access the data simultaneously?
• RECOVERY: can you recover data?
• data INTEGRITY: are there integrity constraints on the data?

Question:
3. What's an advantage of using a DBMS?
Answer:
• it's easy to program

Question:
4. What's a disadvantage of using a DBMS?
Answer:
• it may be inefficient

Question:
5. Example of one to many relationship
Answer:
A soccer team can have many players.

Question:
6. Example of many to many relationship
Answer:
Many soccer teams can have many player numbers.

Question:
7. If you have many candidate keys, how do you choose a primary key?
Answer:
Choose what would be more efficient for searching on a query.

Question:
8. ACID?