Practice Traditional File Processing Vs Dbms (3) - Database Management System (DBMS)

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What is data redundancy?
Show hintHide hint
Think about why it might be a problem.
Question 2.
Name one advantage of using DBMS over traditional file processing.
Show hintHide hint
Consider why centralization may be beneficial.
3Question 3.
What is a major issue with traditional file processing systems?
- Data Redundancy
- High Speed
- Low Complexity
Show hintHide hint
Think about why multiple files would be a problem.
4Question 4.
True or False: DBMS allows for program-independent data access.
- True
- False
Show hintHide hint
Consider what program independence means.
Question 5.
Consider a company that has been using a traditional file system. Evaluate the potential impacts of switching to a DBMS?
Show hintHide hint
Think about how data is currently managed versus how it will be managed.
Question 6.
Design a small DBMS structure for a library system. How would you ensure data integrity in this structure?
Show hintHide hint
Consider the types of data you need to manage and what rules will keep it correct.

5 more questions in this section. Enroll free to practise them all.