CRUD operation verification in Testing Fundamentals - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ Predict Output

intermediate

Output of Create Operation Test

What will be the output of this test code that verifies a create operation in a simple in-memory list database?

Testing Fundamentals

database = []

def create_item(item):
    database.append(item)
    return True

result = create_item({'id': 1, 'name': 'Test Item'})
print(result, len(database))

A True 0

B False 0

C True 1

D False 1

💡 Hint

Check what the create_item function returns and how the database list changes.

The create_item function appends the item and returns True. The database length becomes 1 after adding the item.

❓ assertion

intermediate

Correct Assertion for Update Operation

Which assertion correctly verifies that an update operation changed the name of an item in a dictionary database?

Testing Fundamentals

database = {1: {'id': 1, 'name': 'Old Name'}}

# Update operation
updated_item = {'id': 1, 'name': 'New Name'}
database[1] = updated_item

# Assertion to verify update:

A assert database[1]['name'] == 'New Name'

B assert database[1]['name'] == 'Old Name'

C assert database[1]['id'] == 2

D assert 'New Name' in database

💡 Hint

Check the updated value of the name key for item with id 1.

After update, the name should be 'New Name'. Option A correctly asserts this.

🔧 Debug

advanced

Identify the Bug in Delete Operation Test

What is the bug in this delete operation test code?

Testing Fundamentals

database = [{'id': 1}, {'id': 2}]

# Delete item with id 1
database = [item for item in database if item['id'] != 1]

# Test if item deleted
assert 1 not in database

A The assertion is incorrect because it checks if integer 1 is not in list of dicts

B The delete operation raises a syntax error

C The database variable is not updated after deletion

D The list comprehension does not remove the item with id 1

💡 Hint

Look at what the assertion is checking inside the list.

The assertion checks if integer 1 is not in the list of dictionaries, which is always true. It should check the 'id' keys instead.

🧠 Conceptual

advanced

Best Practice for Verifying Read Operation

Which option describes the best practice to verify a read operation in a CRUD test?

A Only check that the read function does not raise an error

B Confirm that the read function returns data faster than 1 second

C Verify that the read function returns a non-empty list regardless of content

D Check that the read function returns the exact expected data structure and values

💡 Hint

Think about what ensures the read operation is correct, not just working.

Verifying the exact data returned ensures the read operation fetches correct and complete data.

❓ framework

expert

Choosing the Right Test Framework Feature for CRUD Tests

Which test framework feature is most useful to isolate each CRUD operation test to avoid side effects?

A Running all CRUD tests in a single test method to share state

B Using setup and teardown methods to reset the database state before and after each test

C Using global variables to store test data across tests

D Disabling assertions to speed up test execution

💡 Hint

Consider how to keep tests independent and repeatable.

Setup and teardown methods ensure each test starts fresh, preventing interference between tests.