SQL Programming Revision

SQL Programming Revision

Professional Development

20 Qs

quiz-placeholder

Similar activities

Photoshop tools

Photoshop tools

6th Grade - Professional Development

16 Qs

Office 365 & Services

Office 365 & Services

Professional Development

20 Qs

Kelas X 28 Spreadsheet 2020

Kelas X 28 Spreadsheet 2020

Professional Development

15 Qs

L4 Ôn tập HK 2 - 22-23

L4 Ôn tập HK 2 - 22-23

Professional Development

16 Qs

Sensibilisation sécurité informatique

Sensibilisation sécurité informatique

Professional Development

15 Qs

Quis Freetest Microsoft Word

Quis Freetest Microsoft Word

KG - Professional Development

15 Qs

MOC 20744C-Securing Windows Server 2016 - Part 2

MOC 20744C-Securing Windows Server 2016 - Part 2

Professional Development

17 Qs

dasar komputer jaringan

dasar komputer jaringan

Professional Development

15 Qs

SQL Programming Revision

SQL Programming Revision

Assessment

Quiz

Computers

Professional Development

Medium

Created by

rahul g

Used 24+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

SQL Clause Used to Filter Aggregated Data is:

WHERE

GROUP BY

HAVING

ORDER BY

2.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

SQL Tables do NOT exist on physical locations.

TRUE

FALSE

3.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

Which SQL statement is used to extract data from a database?

SELECT

OPEN

EXTRACT

GET

4.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

Which SQL statement is used to insert new data in a database?

ADD RECORD

ADD NEW

INSERT NEW

INSERT INTO

5.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

Which SQL statement is used to return only different values?

SELECT DIFFERENT

SELECT UNIQUE

SELECT DISTINCT

6.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

With SQL, how can you insert a new record into the "Persons" table?

INSERT VALUES ('JIMMY','JACKSON') INTO Persons

INSERT INTO Persons VALUES ('JIMMY','JACKSON')

7.

MULTIPLE CHOICE QUESTION

20 sec • 5 pts

With SQL, how can you return the number of records in the "Persons" table?

SELECT LEN(*) FROM Persons

SELECT COUNT(*) FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT NO(*) FROM Persons

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?