sql queries - 2

sql queries - 2

12th Grade

20 Qs

quiz-placeholder

Similar activities

Storage

Storage

9th - 12th Grade

17 Qs

Google

Google

7th - 12th Grade

20 Qs

SciVis II 4 D

SciVis II 4 D

9th - 12th Grade

16 Qs

4.6.4 Logic Gates

4.6.4 Logic Gates

10th Grade - Professional Development

15 Qs

quiz_G10

quiz_G10

12th Grade

20 Qs

Quiz1_12&11_2t_20214

Quiz1_12&11_2t_20214

12th Grade

20 Qs

Ap computer science a

Ap computer science a

1st - 12th Grade

15 Qs

sql queries - 2

sql queries - 2

Assessment

Quiz

Computers

12th Grade

Practice Problem

Hard

Created by

sreerekha R

Used 222+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which would show all fields from the Pupils table?

SELECT * FROM Pupils

SELECT Name, Form FROM Pupils

SELECT * FROM *

SELECT * FROM Forms

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which Symbol means "All"

*

&

%

!

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which would find pupils with "er" anywhere in their name?

SELECT * FROM Pupils Where Name = "%er"

SELECT * FROM Pupils Where Name = "$er$"

SELECT * FROM Pupils Where Name = "%er%"

SELECT * FROM Pupils Where Name = "er%"

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is it called when SQL is used in an attempt to harm a database?

SQL Injection

SQL Interception

SQL Attack

SQL Misuse

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Choose the correct query

SELECT * FROM EMP WHERE NAME=NULL

SELECT * FROM EMP WHERE NAME IS NULL;

SELECT FROM EMP WHERE NAME IS NULL;

SELECT *FROM EMP WHERE NAME IS 'NULL';

6.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

The restrictions or conditions applied on data are known as ______________

7.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

The primary key of a table which is present in another table for referencing is known as ________________________

Create a free account and access millions of resources

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?