Structured Query Language Quiz

Quiz
•
Computers
•
12th Grade
•
Medium
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
Similar Resources on Wayground
12 questions
Database Knowledge Check 3 (SQL)

Quiz
•
9th - 12th Grade
15 questions
REST API and MySQL Quiz SKG

Quiz
•
12th Grade
18 questions
SQL Tingkatan 5 SPM

Quiz
•
10th Grade - University
10 questions
Advanced SQL

Quiz
•
KG - University
16 questions
National 5 Computing Science Prelim Revision

Quiz
•
9th - 12th Grade
18 questions
Structured Query Language

Quiz
•
12th Grade
15 questions
Introduction to MySQL

Quiz
•
11th - 12th Grade
10 questions
PERINTAH SQL 01

Quiz
•
10th Grade - University
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade