N5CS: Database Testing and Evaluation

Quiz
•
Computers
•
9th Grade
•
Hard
Calum Gordon
FREE Resource
28 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is one of the learning objectives for Database Testing and Evaluation?
Evaluate your solution in terms of fitness for purpose and accuracy of output
Understand the history of computer science
Learn the basics of web design and development
Master the principles of graphic design
Answer explanation
The learning objective for Database Testing and Evaluation is to evaluate your solution in terms of fitness for purpose and accuracy of output.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of testing SQL queries?
To make them run faster
To ensure they are fit for purpose and accurate
To make them easier to write
To reduce the size of the database
Answer explanation
To ensure they are fit for purpose and accurate
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does this SQL statement do?
SELECT *
FROM goalscorer
WHERE gtime > 70;
It selects all players who scored in the first 70 minutes of a game
It selects all players from the goalscorer table
It selects all players who scored after the 70th minute of a game
It updates the goalscorer table to only show goals after the 70th minute
Answer explanation
It selects all players who scored after the 70th minute of a game
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which players scored in the last 20 minutes of a game?
Robert Lewandowski and Dimitris Salpingidis
Alan Dzagoev and Roman Pavlyuchenko
Václav Pilar and Theofanis Gekas
Petr Jiráček and Václav Pilar
Answer explanation
The correct players who scored in the last 20 minutes of a game are Alan Dzagoev and Roman Pavlyuchenko.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What are the two criteria against which queries should be evaluated according to the text?
Complexity and efficiency
Fitness for purpose and accuracy of output
Speed and reliability
Length and clarity
Answer explanation
Queries should be evaluated based on their fitness for purpose and accuracy of output, as mentioned in the text.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does "fitness for purpose" mean in the context of query evaluation?
The solution must be the most efficient one available
The solution must be complex and comprehensive
The solution must be good enough to do the task required
The solution must include additional data not asked for
Answer explanation
The solution must be good enough to do the task required
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If a query's output includes additional columns not required but has the necessary information, how is it classified in terms of "fitness for purpose"?
Not fit for purpose
Fit for purpose but not accurate
Fit for purpose
Inaccurate and not fit for purpose
Answer explanation
If a query's output includes additional columns not required but has the necessary information, it is classified as 'Fit for purpose' because it provides the needed data despite the extra columns.
Create a free account and access millions of resources
Similar Resources on Wayground
25 questions
COMP9 - Database Security and DDL

Quiz
•
9th Grade
25 questions
TDP111 - Introduction to PHP

Quiz
•
7th - 10th Grade
27 questions
Quiz: Module 10: Coding Quiz

Quiz
•
9th Grade - University
24 questions
sql

Quiz
•
6th - 9th Grade
23 questions
data base management system

Quiz
•
2nd Grade - University
25 questions
TDP112 Introduction to Laravel

Quiz
•
8th - 10th Grade
30 questions
Computer Science Revision Quiz

Quiz
•
9th - 12th Grade
30 questions
COMP9. DATA MANIPULATION LANGUAGE

Quiz
•
9th Grade
Popular Resources on Wayground
50 questions
Trivia 7/25

Quiz
•
12th Grade
11 questions
Standard Response Protocol

Quiz
•
6th - 8th Grade
11 questions
Negative Exponents

Quiz
•
7th - 8th Grade
12 questions
Exponent Expressions

Quiz
•
6th Grade
4 questions
Exit Ticket 7/29

Quiz
•
8th Grade
20 questions
Subject-Verb Agreement

Quiz
•
9th Grade
20 questions
One Step Equations All Operations

Quiz
•
6th - 7th Grade
18 questions
"A Quilt of a Country"

Quiz
•
9th Grade