N5CS: Database Testing and Evaluation

N5CS: Database Testing and Evaluation

9th Grade

28 Qs

quiz-placeholder

Similar activities

Database DIT

Database DIT

6th - 10th Grade

23 Qs

Concepts of Database Mgmt. Chapter 3 Review

Concepts of Database Mgmt. Chapter 3 Review

9th - 12th Grade

26 Qs

TDP112 Introduction to Laravel

TDP112 Introduction to Laravel

8th - 10th Grade

25 Qs

HYKwCS-CH05-S05-Databases

HYKwCS-CH05-S05-Databases

9th - 12th Grade

24 Qs

Computer Science Revision Quiz

Computer Science Revision Quiz

9th - 12th Grade

30 Qs

COMP9. DATA MANIPULATION LANGUAGE

COMP9. DATA MANIPULATION LANGUAGE

9th Grade

30 Qs

PHP + MySQL

PHP + MySQL

7th Grade - University

25 Qs

sql

sql

6th - 9th Grade

24 Qs

N5CS: Database Testing and Evaluation

N5CS: Database Testing and Evaluation

Assessment

Quiz

Computers

9th Grade

Hard

Created by

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

Media Image

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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?