When documenting the results of testing, it is good practice to state the ‘expected result’ of a query. What does the term ‘expected result’ mean?
The expected result is the result that is recorded after the query is executed
The expected result is the result that is anticipated before the query is executed
The expected result is taken from the data dictionary and checked during testing
If an error is encountered during the testing of a query, which of the following should be checked for accuracy first?
Query design and SQL
Data dictionary and ERD
End user and functional requirements
What should a developer do if they encounter an error during testing?
Re-test until you get the results that you wanted the first time
Revisit previous phases of database development to rectify errors found in testing, then test again and repeat this process until software is fit for purpose
Start again, beginning with analysis of end user and functional requirements and recreate the database entirely
Which term describes a database that meets the end user and functional requirements?
Ready to use
Fit for purpose
Complete