Structured Query Language Quiz

Structured Query Language Quiz

12th Grade

15 Qs

quiz-placeholder

Similar activities

CP1222-WEEK 1-2 QUIZ

CP1222-WEEK 1-2 QUIZ

12th Grade

10 Qs

MYSQL

MYSQL

12th Grade

15 Qs

SQL

SQL

10th - 12th Grade

11 Qs

sql queries - 2

sql queries - 2

12th Grade

20 Qs

SQL

SQL

12th Grade

20 Qs

SQLDatabase

SQLDatabase

12th Grade

15 Qs

MySQL-Grade XII IP

MySQL-Grade XII IP

12th Grade

20 Qs

J277 - 2.2 - The use of SQL to search for data

J277 - 2.2 - The use of SQL to search for data

10th Grade - University

10 Qs

Structured Query Language Quiz

Structured Query Language Quiz

Assessment

Quiz

Computers

12th Grade

Medium

Created by

Mr Long

Used 12+ times

FREE Resource

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of SQL?

To retrieve, delete, and manipulate data in relational databases

To express the logic of how something needs to be achieved

To define and control data access

To create and modify tables in a database

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL command is used to select specific data from a table?

INSERT INTO

DELETE FROM

UPDATE

SELECT

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SQL command 'SELECT *' do?

Selects all fields from the table

Selects only the primary key field

Selects fields with a specific value

Selects fields based on a condition

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you select records from a table where the name starts with 'A' and the population is greater than 1 million?

SELECT name, population FROM table WHERE name = 'A' AND population > 1 million

SELECT name, population FROM table WHERE name LIKE 'A%' AND population > 1 million

SELECT name, population FROM table WHERE name = 'A' OR population > 1 million

SELECT name, population FROM table WHERE name LIKE 'A%' OR population > 1 million

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL command is used to insert new records into a table?

INSERT INTO

DELETE FROM

UPDATE

SELECT

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you delete all records from a table with a population larger than 10 million?

DELETE FROM table WHERE population > 10 million

DELETE FROM table WHERE population < 10 million

DELETE FROM table WHERE population = 10 million

DELETE FROM table WHERE population >= 10 million

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL command is used to modify data in a table?

INSERT INTO

DELETE FROM

UPDATE

SELECT

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?