Search Header Logo

CHAPTER9 Quiz

Authored by jasmine chen

Computers

10th Grade

Used 6+ times

CHAPTER9 Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

18 questions

Show all answers

1.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

If input could be:

SELECT HospitalNumber, FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Smith';

What are the following output:

Evaluate responses using AI:

OFF

Answer explanation

Media Image

2.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

If input could be:

SELECT HospitalNumber, FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Smith'

ORDER BY FamilyName;

What are the following output could be:

Evaluate responses using AI:

OFF

Answer explanation

Media Image

3.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

Using the single table database PATIENT you have created:

Write an SQL query to list all Mr Jones’ patients.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName

FROM PATIENT

WHERE Consultant = 'Mr Jones'; 

4.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

Using the single table database PATIENT you have created. Write an SQL query to list all the patients not in ward 6.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName

FROM PATIENT

WHERE WardNumber <> 6; 

5.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

Using the single table database PATIENT you have created.

Write an SQL query to list all the patients who arrived on 12/11/2022.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName

FROM PATIENT

WHERE DateOfAdmisson = '12/11/2022’; 

6.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

Using the single table database PATIENT you have created.

Write an SQL query to list all the patients who arrived between 12/10/2022 AND 30/10/2022.

Evaluate responses using AI:

OFF

Answer explanation

SELECT FirstName, FamilyName, DateOfAdmission  

FROM PATIENT

WHERE DateOfAdmission >= '12/10/2022' AND DateOfAdmission <= '30/10/2022’ ; 

7.

OPEN ENDED QUESTION

3 mins • 1 pt

Media Image

Using the single table database PATIENT you have created.

Write down the output from this SQL query.

SELECT FirstName, FamilyName, BedNumber

FROM PATIENT

WHEREWardNumber= 7;

Evaluate responses using AI:

OFF

Answer explanation

Media Image

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers