Marking Scheme – NoSQL Database Exam (SWDND501)
Section A: (55 Marks Total)
Each question has individual marks already assigned:
What is NoSQL, and how does it differ from relational databases?
5 marks
- Definition (2 marks)
- Difference (3 marks)
Name and briefly describe four types of NoSQL databases.
5 marks
- 1.25 marks per type (name + brief description)
Explain BASE properties in NoSQL databases.
3 marks
- Basically Available (1 mark)
- Soft state (1 mark)
- Eventually consistent (1 mark)
What are the key advantages of using a NoSQL database?
3 marks
- Any 3 key advantages (1 mark each)
How does data modeling in NoSQL differ from relational databases?
3 marks
- NoSQL modeling (1.5 marks)
- Difference from relational (1.5 marks)
Describe sharding and why it is important in NoSQL databases.
3 marks
- Definition (1.5 marks)
- Importance (1.5 marks)
What do you understand by Compass environment?
3 marks
- Definition (1.5 marks)
- Purpose/use (1.5 marks)
How do you create a collection in MongoDB?
3 marks
- Syntax (1.5 marks)
- Explanation (1.5 marks)
What is the CAP theorem, and how does it relate to NoSQL databases?
3 marks
- Definition of CAP (2 marks)
- Relation to NoSQL (1 mark)
Name two popular NoSQL databases and their use cases.
3 marks
- 1.5 marks each
How does indexing work in NoSQL databases?
3 marks
- Definition (1 mark)
- How it works (2 marks)
What is the difference between sharding and replication in NoSQL databases?
3 marks
- Sharding (1.5 marks)
- Replication (1.5 marks)
What is a conceptual data model?
3 marks
- Definition (1.5 marks)
- Purpose/importance (1.5 marks)
Why is schema validation important in MongoDB?
3 marks
- Definition (1 mark)
- Importance (2 marks)
What are some common tools used for drawing database models?
3 marks
- Any 3 tools (1 mark each)
How do you create a new database in MongoDB?
3 marks
- Command (1.5 marks)
- Explanation (1.5 marks)
How do you rename a collection in MongoDB?
3 marks
- Command (1.5 marks)
- Explanation (1.5 marks)
Section B: (30 Marks Total) – Choose 3 out of 5 Questions (10 Marks Each)
- Each question should be marked out of 10 based on:
- Understanding of concepts (4 marks)
- Accuracy and structure (3 marks)
- Use of correct syntax/examples (3 marks)
Section C: (15 Marks Total) – Choose 1 out of 3 Questions
- Each question should be marked out of 15 based on:
- Complete, accurate explanation (6 marks)
- Relevant and well-structured example(s) (5 marks)
- Clarity and depth (4 marks)